diff options
-rw-r--r-- | remove-badges-variants.mysql (renamed from database.cleanup) | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/database.cleanup b/remove-badges-variants.mysql index 1d3d918..8108fad 100644 --- a/database.cleanup +++ b/remove-badges-variants.mysql @@ -10,8 +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 ; +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 ; +DELETE badges FROM badges, tmp WHERE badges.username = tmp.username AND badges.type = tmp.type AND tmp.count > 1 ; DROP TABLE tmp ; - |