From 370d4caf1421aa438c2288f6366fbba05877675d Mon Sep 17 00:00:00 2001 From: Hugues Hiegel Date: Wed, 13 Jul 2011 12:48:05 +0200 Subject: [Duplicates] only remove 1-hit duplicates. --- DataBase/cleanup.mysql | 1 + 1 file changed, 1 insertion(+) diff --git a/DataBase/cleanup.mysql b/DataBase/cleanup.mysql index aa51af5..0fb94e9 100644 --- a/DataBase/cleanup.mysql +++ b/DataBase/cleanup.mysql @@ -9,6 +9,7 @@ CREATE TEMPORARY TABLE duplicates (SELECT username, type, COUNT(username) AS cou DELETE badges.* FROM badges, duplicates WHERE badges.username = duplicates.username + AND badges.hits = 1 AND ( (badges.type = duplicates.type AND duplicates.count > 1) OR ( (badges.type LIKE concat(duplicates.type,"%") OR duplicates.type LIKE concat(badges.type,"%")) AND badges.type != duplicates.type ) -- cgit v1.2.3