Today 2026-07-02Today 2026-07-03SELECT EvtID, EvtCat, EvtBizID, EvtName, EvtAddress, EvtPhone, EvtURL,
EvtImage, EvtStartDate, EvtEndDate, EvtDayOpt, EvtVariousDays, EvtDays,
EvtMonSeqNbr, EvtMonSeqDay, EvtDayMonDates, EvtStartTime, EvtEndTime, EvtDesc,
EvtMemo, EvtLastEditDate, EvtTestYN, EvtPhoto, EvtSelcDates,
bizID, bizPriority, bizCat, bizName, bizAddress, bizPhone, bizURL, bizImage,
bizPreBeginDate, bizPreDays, bizPreOpenTime, bizPreCloseTime, bizPreEndDate,
bizPrimeBeginDate, bizPrimeDays, bizPrimeOpenTime, bizPrimeCloseTime, bizPrimeEndDate,
bizHolidayDates, bizPostBeginDate, bizPostDays, bizPostOpenTime, bizPostCloseTime,
bizPostEndDate, bizMemo, bizLastEditDate, bizTestYN, bizAcctPostedID
FROM inquest.BizOCEvents, inquest.BizOCBiz
WHERE inquest.BizOCEvents.EvtBizID = inquest.BizOCBiz.bizID AND EvtID>0 AND ((EvtStartDate >= "2026-07-01")
OR (EvtDayOpt="V" AND EvtVariousDays LIKE "%2026-07-01%")) AND ((("2026-07-01">=EvtStartDate)
AND ("2026-07-01"<=EvtEndDate)
AND (EvtDays LIKE "%3%")) OR (("2026-07-02">=EvtStartDate)
AND ("2026-07-02"<=EvtEndDate)
AND (EvtDays LIKE "%4%")) OR (("2026-07-03">=EvtStartDate)
AND ("2026-07-03"<=EvtEndDate)
AND (EvtDays LIKE "%5%"))) ORDER BY EvtName ASC LIMIT 6 Offset 0
--
Evt#: 0, When Select: 3No Events Found using - Category: "All" - Period: "Next 3 Days"