August  2026

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-01' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Sat',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-02' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Sun',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-03' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Mon',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-04' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Tue',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-05' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Wed',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-06' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Thu',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-07' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Fri',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-08' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Sat',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-09' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Sun',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-10' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Mon',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-11' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Tue',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-12' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Wed',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-13' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Thu',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-14' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Fri',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-15' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Sat',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-16' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Sun',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-17' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Mon',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-18' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Tue',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-19' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Wed',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-20' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Thu',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-21' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Fri',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-22' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Sat',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-23' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Sun',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-24' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Mon',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-25' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Tue',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-26' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Wed',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-27' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Thu',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-28' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Fri',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-29' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Sat',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-30' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Sun',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2026-08-31' BETWEEN CAST(`eventStartDate` AS DATE) AND CAST(`eventEndDate` AS DATE) AND (weekdays IS NULL OR weekdays ='' OR FIND_IN_SET('Mon',weekdays) ) AND sysStatus='active' AND approval='approved' AND city RLIKE 'Stratford' AND region = 'Core' ORDER BY RAND()