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;