SUN | MON | TUE | WED | THU | FRI | SAT |
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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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()
42S02SELECT 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
| | | | | 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 |