summaryrefslogtreecommitdiff
path: root/DataBase/cleanup.mysql
diff options
context:
space:
mode:
Diffstat (limited to 'DataBase/cleanup.mysql')
-rw-r--r--DataBase/cleanup.mysql1
1 files changed, 1 insertions, 0 deletions
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 )