最近の検索
検索オプション
SELECT username, domain, count(*) AS dups FROM accounts GROUP BY username, domain HAVING COUNT(*) > 1;
したら何行出てきたと思います？
(1239 rows)
でした
SELECT id, username, domain FROM accounts WHERE id NOT IN (SELECT MIN(id) FROM accounts GROUP BY username, domain);
で雑に眺めてみて問題なさそうだったので、
DELETE FROM accounts WHERE id NOT IN (SELECT MIN(id) FROM accounts GROUP BY username, domain);
いきます