SELECT *
FROM m_events
LEFT JOIN m_events_dates ON m_events_dates.event_id = m_events.id
WHERE status = 1
GROUP BY m_events.id
ORDER BY m_events_dates.start_date ASC
#LIMIT 0, 10
YEP invites its members to celebrate the holidays and close a successful year at our annual Holiday Party. This private party will be held at Molly Brannigan's and feature heavy hors d'oeuvres as well as a complimentary signature drink.
...