-SELECT
- backup_id,
- count(backup_id) = count(backup_part_id) as burned
-FROM archive
-JOIN archive_parts ON archive.id = archive_id
-JOIN backup_parts ON backup_part_id = backup_id
-GROUP BY backup_id
-;
+SELECT backup_parts.backup_id,
+count(backup_parts.backup_id) as backup_parts,
+count(archive_burned.archive_id) AS burned_parts,
+count(backup_parts.backup_id) = count(archive_burned.archive_id) as burned
+ FROM backup_parts
+ left outer JOIN archive_parts ON backup_part_id = backup_parts.id
+ left join archive on archive.id = archive_id
+ left outer join archive_burned on archive_burned.archive_id = archive.id
+ GROUP BY backup_parts.backup_id ;
+