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