June  2027

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