SELECT event_id,title,status_id,time_start
FROM `n4l5a_nitevents_events`
LEFT JOIN `n4l5a_nitevents_dates` USING (event_id)
LEFT JOIN `n4l5a_nitevents_locations` USING (location_id)
LEFT JOIN `n4l5a_nitevents_category_fields_map` USING (event_id)
LEFT JOIN `n4l5a_nitevents_category_fields` USING (field_id)
LEFT JOIN `n4l5a_nitevents_category_groups` USING (group_id)
WHERE `published` = 1 AND `group_id` = 3 AND `time_end` >= '2017-03-30'
GROUP BY `event_id`, `time_start`
ORDER BY time_start