| SUN | MON | TUE | WED | THU | FRI | SAT |
SELECT itemID, userID, eventTitle FROM tblEvents
WHERE '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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 '2025-02-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()
42S02
| | | | | | | Saturday, February 1st |
| Sunday, February 2nd |
Monday, February 3rd |
Tuesday, February 4th |
Wednesday, February 5th |
Thursday, February 6th |
Friday, February 7th |
Saturday, February 8th |
| Sunday, February 9th |
Monday, February 10th |
Tuesday, February 11th |
Wednesday, February 12th |
Thursday, February 13th |
Friday, February 14th |
Saturday, February 15th |
| Sunday, February 16th |
Monday, February 17th |
Tuesday, February 18th |
Wednesday, February 19th |
Thursday, February 20th |
Friday, February 21st |
Saturday, February 22nd |
| Sunday, February 23rd |
Monday, February 24th |
Tuesday, February 25th |
Wednesday, February 26th |
Thursday, February 27th |
Friday, February 28th |
|
Print This Page