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
Join Young Erie Professionals for a 9 Hole Golf Scramble. No need to be a pro to play! As you arrive, you will choose a card from a deck. Other players with the same face card will make up your team.Not into golf? No problem! Join us in the clubho...