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	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