Someone

SELECT username, event_type, GROUP_CONCAT(event_type) FROM eventsWHERE username IN  (SELECT DISTINCT username FROM `events`   WHERE created > '2007-11-15'   AND created < '2007-11-15' + INTERVAL 1 DAY)GROUP BY username, event_type