with t1 as (SELECT MAX(event_id) as max_event_id, name FROM events GROUP BY name) 
SELECT * FROM events INNER JOIN t1 ON t1.max_event_id = events.event.id;