オブジェクトIDが重複してないか調べるSQL文

[Iz]

コード: 全て選択

SELECT id, COUNT(id) AS cnt FROM (
SELECT id FROM character_items UNION ALL
SELECT id FROM character_teleport UNION ALL
SELECT id FROM character_warehouse UNION ALL
SELECT id FROM character_elf_warehouse UNION ALL
SELECT id FROM clan_warehouse UNION ALL
SELECT objid AS id FROM characters UNION ALL
SELECT clan_id AS id FROM clan_data UNION ALL
SELECT objid AS id FROM pets
) AS tbl GROUP BY id ORDER BY cnt DESC;