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 inquest.BizOCEvents.EvtID>0 AND ( ("2026-10-04" >= EvtStartDate AND "2026-10-04" <= EvtEndDate) OR ("2026-10-05" >= EvtStartDate AND "2026-10-05" <= EvtEndDate) OR ("2026-10-06" >= EvtStartDate AND "2026-10-06" <= EvtEndDate) ) AND ((EvtDayOpt="V" AND ((EvtVariousDays LIKE "%2026-10-04%") OR (EvtVariousDays LIKE "%2026-10-05%") OR (EvtVariousDays LIKE "%2026-10-06%"))) OR (EvtDayOpt<>"V" AND ( (EvtDays LIKE "%0%") OR (EvtDays LIKE "%1%") OR (EvtDays LIKE "%2%") ))) ORDER BY EvtName ASC
