--- trunk/lib/BackupPC/SearchLib.pm	2005/09/23 15:04:37	136
+++ trunk/lib/BackupPC/SearchLib.pm	2005/09/29 08:46:13	137
@@ -309,8 +309,8 @@
 		FROM backups 
 		INNER JOIN shares	ON backups.shareID=shares.ID
 		INNER JOIN hosts	ON backups.hostID = hosts.ID
-		LEFT OUTER JOIN archive_backup ON archive_backup.backup_id = backups.id AND archive_backup.backup_id IS NULL
-		WHERE backups.size > 0
+		LEFT OUTER JOIN archive_backup ON archive_backup.backup_id = backups.id 
+		WHERE backups.size > 0 AND archive_backup.backup_id IS NULL
 		GROUP BY
 		        backups.hostID,
 			hosts.name,