- backups.id AS backup_id,
- hosts.name AS host,
- backups.num AS num,
- backups.date AS date,
- shares.name AS share,
- backups.size AS backup_size,
- backups.inc_size AS compress_size
- FROM backups
- JOIN backup_parts ON backup_parts.backup_id = backups.id
- JOIN archive_parts ON archive_parts.backup_id = backups.id
- JOIN hosts ON hosts.id = backups.hostid
- JOIN shares ON shares.id = backups.shareid
- WHERE archive_parts.backup_id = backups.id
- AND archive_parts.archive_id = ?
- ORDER BY
- hosts.name, shares.name, backups.num