SUN | MON | TUE | WED | THU | FRI | SAT |
SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-01' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-02' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-03' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-04' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-05' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-06' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-07' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-08' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-09' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-10' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-11' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-12' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-13' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-14' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-15' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-16' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-17' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-18' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-19' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-20' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-21' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-22' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-23' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-24' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-25' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-26' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-27' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-28' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-29' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-30' 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()
42S02SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2022-05-31' 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
Sunday, May 1st |
Monday, May 2nd |
Tuesday, May 3rd |
Wednesday, May 4th |
Thursday, May 5th |
Friday, May 6th |
Saturday, May 7th |
Sunday, May 8th |
Monday, May 9th |
Tuesday, May 10th |
Wednesday, May 11th |
Thursday, May 12th |
Friday, May 13th |
Saturday, May 14th |
Sunday, May 15th |
Monday, May 16th |
Tuesday, May 17th |
Wednesday, May 18th |
Thursday, May 19th |
Friday, May 20th |
Saturday, May 21st |
Sunday, May 22nd |
Monday, May 23rd |
Tuesday, May 24th |
Wednesday, May 25th |
Thursday, May 26th |
Friday, May 27th |
Saturday, May 28th |
Sunday, May 29th |
Monday, May 30th |
Tuesday, May 31st |
| | | |