- hosts.name as host,
- shares.name as share,
- backups.num as num,
- backups.parts as parts,
- backup_parts.part_nr as part_nr,
- backup_parts.size as part_size,
- backup_parts.md5 as md5,
- backup_parts.items,
- backup_parts.filename
- FROM backup_parts
- JOIN archive_parts ON backup_parts.id = backup_part_id
- JOIN archive ON archive_id = archive.id
- JOIN backups ON backup_id = backups.id
- JOIN hosts ON hostid = hosts.id
- JOIN shares ON shareid = shares.id
- WHERE archive.dvd_nr = ?