1 -- dump all files. Might be VERY VERY slow on large backup pools
8 backups.date as backup_date,
13 backups.size as backup_size
15 join shares on files.shareid = shares.id
16 join hosts on shares.hostid = hosts.id
17 join backups on shares.hostid = backups.hostid
18 and files.backupnum = backups.num
19 and shares.id = backups.shareid
20 order by backups.date;