Ugly SQL query

SELECT  wua.internalKey, wua.fullname, wua.email, wua.logincount, wua.lastlogin
FROM cms_web_user_attributes wua
INNER JOIN (
    SELECT email
    FROM cms_web_user_attributes
    GROUP BY email
    HAVING count(email) > 1
) dup ON wua.email = dup.email
ORDER BY wua.email

SELECT  wua.internalKey, usr.username, wua.fullname, wua.email, wua.logincount, wua.lastlogin
FROM cms_web_user_attributes wua
INNER JOIN (
    SELECT email
    FROM cms_web_user_attributes
    GROUP BY email
    HAVING count(email) > 1
) dup ON wua.email = dup.email
INNER JOIN cms_web_users usr ON wua.internalKey = usr.id
ORDER BY wua.email