SELECT EvtID, EvtCat, EvtBizID, EvtName, EvtAddress, EvtPhone, EvtURL,
EvtImage, EvtStartDate, EvtEndDate, EvtDayOpt, 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,
bizOpenHolidays, 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 ((("2026-04-06">=EvtStartDate)
AND ("2026-04-06"<=EvtEndDate)
AND (EvtDays LIKE "%1%")) OR (("2026-04-07">=EvtStartDate)
AND ("2026-04-07"<=EvtEndDate)
AND (EvtDays LIKE "%2%")) OR (("2026-04-08">=EvtStartDate)
AND ("2026-04-08"<=EvtEndDate)
AND (EvtDays LIKE "%3%"))) ORDER BY EvtName ASC LIMIT 30