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