my Movie
SELECT ME.event_id, ME.title, date_format(ME.start_date, '%m.%d.%y') as start_date, date_format(ME.end_date, '%m.%d.%y') as end_date, COUNT(M.title_id) as movies_seen FROM movie_events ME LEFT JOIN movies M USING(event_id) WHERE ME.event_id = GROUP BY ME.event_id