March  2019

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

SELECT itemID, userID, eventTitle FROM tblEvents WHERE '2019-03-31' 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
SUNMONTUEWEDTHUFRISAT
     Friday, March 1st Saturday, March 2nd
Sunday, March 3rd Monday, March 4th Tuesday, March 5th Wednesday, March 6th Thursday, March 7th Friday, March 8th Saturday, March 9th
Sunday, March 10th Monday, March 11th Tuesday, March 12th Wednesday, March 13th Thursday, March 14th Friday, March 15th Saturday, March 16th
Sunday, March 17th Monday, March 18th Tuesday, March 19th Wednesday, March 20th Thursday, March 21st Friday, March 22nd Saturday, March 23rd
Sunday, March 24th Monday, March 25th Tuesday, March 26th Wednesday, March 27th Thursday, March 28th Friday, March 29th Saturday, March 30th
Sunday, March 31st