November  2019

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-01' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-02' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-03' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-04' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-05' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-06' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-07' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-08' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-09' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-10' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-11' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-12' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-13' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-14' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-15' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-16' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-17' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-18' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-19' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-20' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-21' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-22' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-23' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-24' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-25' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-26' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-27' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-28' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-29' 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()

42S02

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-11-30' 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()

42S02
SUNMONTUEWEDTHUFRISAT
     Friday, November 1st Saturday, November 2nd
Sunday, November 3rd Monday, November 4th Tuesday, November 5th Wednesday, November 6th Thursday, November 7th Friday, November 8th Saturday, November 9th
Sunday, November 10th Monday, November 11th Tuesday, November 12th Wednesday, November 13th Thursday, November 14th Friday, November 15th Saturday, November 16th
Sunday, November 17th Monday, November 18th Tuesday, November 19th Wednesday, November 20th Thursday, November 21st Friday, November 22nd Saturday, November 23rd
Sunday, November 24th Monday, November 25th Tuesday, November 26th Wednesday, November 27th Thursday, November 28th Friday, November 29th Saturday, November 30th