September  2021

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2021-09-01' 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 '2021-09-02' 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 '2021-09-03' 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 '2021-09-04' 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 '2021-09-05' 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 '2021-09-06' 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 '2021-09-07' 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 '2021-09-08' 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 '2021-09-09' 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 '2021-09-10' 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 '2021-09-11' 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 '2021-09-12' 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 '2021-09-13' 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 '2021-09-14' 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 '2021-09-15' 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 '2021-09-16' 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 '2021-09-17' 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 '2021-09-18' 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 '2021-09-19' 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 '2021-09-20' 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 '2021-09-21' 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 '2021-09-22' 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 '2021-09-23' 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 '2021-09-24' 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 '2021-09-25' 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 '2021-09-26' 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 '2021-09-27' 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 '2021-09-28' 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 '2021-09-29' 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 '2021-09-30' 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()