SELECT DISTINCT e.PkID, e.Title, e.StartDate, e.StartTime, e.EndTime, e.TBD, e.Description,
e.LocID, l.Name, l.Lat, l.Lon, e.SeriesID
FROM hc_events e
LEFT JOIN hc_locations l ON (e.LocID = l.PkID)
WHERE (e.SeriesID = '0' OR e.LocID = '0') AND e.IsActive = 1 AND e.IsApproved = 1 AND e.StartDate >= '2024-04-19'
ORDER BY e.Title, e.StartDate, e.TBD, e.StartTime
Japanese Calendar Festivals & Events | Japanese-City.com