From ae5ee7a18295b0f50ce2a363d01eed8a45fd9bb5 Mon Sep 17 00:00:00 2001
From: Hugues Hiegel <hugues@hiegel.fr>
Date: Thu, 11 Dec 2008 14:05:12 +0100
Subject: [DB] Displays which entries will be deleted with database.cleanup

---
 database.cleanup | 1 +
 1 file changed, 1 insertion(+)

diff --git a/database.cleanup b/database.cleanup
index a3ebe2b..1d3d918 100644
--- a/database.cleanup
+++ b/database.cleanup
@@ -10,6 +10,7 @@ USE lastfm
 
 DROP TABLE IF EXISTS tmp ;
 CREATE TEMPORARY TABLE tmp (SELECT username, type, COUNT(username) AS count FROM badges GROUP BY username, type ) ;
+SELECT * FROM tmp WHERE count > 1 ;
 DELETE badges FROM badges, tmp WHERE badges.username = tmp.username AND tmp.count > 1 ;
 DROP TABLE tmp ;
 
-- 
cgit v1.2.3