--- trunk/lib/BackupPC/SearchLib.pm	2005/09/15 13:54:29	121
+++ trunk/lib/BackupPC/SearchLib.pm	2005/09/16 14:11:00	122
@@ -301,7 +301,7 @@
 
 	my $dbh = get_dbh();
 
-	my $sql = q{ 
+	my $sql = q{
 		SELECT 
 			backups.hostID AS hostID,
 			hosts.name AS host,
@@ -311,7 +311,20 @@
 			backups.date AS date,
 			backups.size AS size
 		FROM backups 
-		WHERE id not in( select id from backups,archive_backup where archive_backup.backup_id=backups.id)
+		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
+		GROUP BY
+		        backups.hostID,
+			hosts.name,
+			shares.name,
+			backups.num,
+			backups.shareid,
+			backups.id,
+			backups.type,
+			backups.date,
+			backups.size
 		ORDER BY backups.date
 	};
 	my $sth = $dbh->prepare( $sql );