Doublons

SELECT   id,COUNT(*) AS nbr_doublon,FROM_UNIXTIME(timecreated), username,lastname,firstname,auth FROM     mdl_user GROUP BY trim(username) HAVING   COUNT(*) > 1;