SELECT 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"