SELECT * FROM lb_users a WHERE (a.nickname) IN (SELECT nickname FROM lb_users GROUP BY nickname HAVING COUNT(*) > 1)