[DB] cleanup : display filenames to delete

1 files changed, 2 insertions, 1 deletions

diff --git a/remove-badges-variants.mysql b/remove-badges-variants.mysql
index 8108fad..69cc068 100644
--- a/remove-badges-variants.mysql
+++ b/remove-badges-variants.mysql
@@ -10,7 +10,8 @@ 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 badges.username, badges.type, badges.style, badges.color FROM badges, tmp WHERE badges.username = tmp.username AND badges.type = tmp.type AND tmp.count > 1 ;
+#SELECT badges.username, badges.type, badges.style, badges.color FROM badges, tmp WHERE badges.username = tmp.username AND badges.type = tmp.type AND tmp.count > 1 ;
+SELECT badges.png FROM badges, tmp WHERE badges.username = tmp.username AND badges.type = tmp.type AND tmp.count > 1 ;
 DELETE badges FROM badges, tmp WHERE badges.username = tmp.username AND badges.type = tmp.type AND tmp.count > 1 ;
 DROP TABLE tmp ;