trunk/sql/xx_display_archive.sql

select
        hosts.name as host,
        shares.name,
        backups.num as share,
        inc_size,
        inc_deleted,
        parts
from archive_backup
        join backups on backups.id = backup_id
        join shares on shares.id = shareid
        join hosts on hosts.id = shares.hostid
where archive_id = 21 order by hosts.name, shares.name, backups.num ;

1	dpavlin	366	select
2			hosts.name as host,
3			shares.name,
4			backups.num as share,
5			inc_size,
6			inc_deleted,
7			parts
8			from archive_backup
9			join backups on backups.id = backup_id
10			join shares on shares.id = shareid
11			join hosts on hosts.id = shares.hostid
12			where archive_id = 21 order by hosts.name, shares.name, backups.num ;
13