9sFJNsHV

1CREATE TABLE IF NOT EXISTS dupeUsers (
2	id INT(8) NOT NULL DEFAULT 0
3);
4
5TRUNCATE TABLE dupeUsers;
6
7INSERT INTO dupeUsers
8(id)
9(
10	SELECT users.id
11	FROM `users`
12	JOIN users AS uDup ON uDup.username = users.username
13	AND uDup.id != users.id
14);
15
16SELECT DISTINCT users.*
17FROM dupeUsers
18JOIN users ON users.id = dupeUsers.id
19ORDER BY username;