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 >= '2019-05-24'
ORDER BY e.Title, e.StartDate, e.TBD, e.StartTime
2019 Japanese Calendar Events & Festivals | Japanese-City.com
Japanese Summer Obon Festivals occur between June to August.
Obon or just Bon is the most important religious holiday in Japan.
A Japanese Buddhist custom to honor the spirits of one's ancestors
and returning to one's family roots.
