Duplicate Records GRRR!

SELECT DISTINCT u.userid, u.lastname, u.firstname, u.department,
                u.otherdept, u.fotc, u.registered AS reg, r.tue_amworkshop, (SELECT DISTINCT room FROM workshops WHERE workshopid=r.tue_amworkshop) AS 'amroom', r.tue_pmworkshop
            FROM users u JOIN registered r ON u.userid=r.userid
            WHERE fotc='yes'
GROUP BY u.userid
            ORDER BY reg DESC, lastname, firstname;