FROM backups
INNER JOIN hosts ON (hosts.id=backups.hostid)
INNER JOIN shares ON (shares.id=backups.shareid)
- INNER JOIN archive_backup ON (archive_backup.backup_id=backups.id)
- INNER JOIN archive_burned ON (archive_burned.archive_id=archive_backup.archive_id)
+ INNER JOIN archive_backup_parts ON (archive_backup_parts.backup_id=backups.id)
+ INNER JOIN archive_burned ON (archive_burned.archive_id=archive_backup_parts.archive_id)
GROUP BY 1, 2, 3
HAVING MAX(archive_burned.copy)>=2;
};