SELECT id, COUNT(id) AS NumOccurrences FROM legions GROUP BY id HAVING ( COUNT(id) > 1 )
SELECT itemUniqueId, COUNT(itemUniqueId) AS NumOccurrences FROM inventory GROUP BY itemUniqueId HAVING ( COUNT(itemUniqueId) > 1 )
SELECT id, COUNT(id) AS NumOccurrences FROM legion_members GROUP BY id HAVING ( COUNT(id) > 1 )
SELECT mailUniqueId, COUNT(mailUniqueId) AS NumOccurrences FROM mail GROUP BY mailUniqueId HAVING ( COUNT(mailUniqueId) > 1 )
SELECT id, COUNT(id) AS NumOccurrences FROM players GROUP BY id HAVING ( COUNT(id) > 1 )