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 EvtStartDate >= "2026-04-06" 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-07">=EvtStartDate)
AND ("2026-04-07"<=EvtEndDate)
AND (EvtDays LIKE "%2%"))) ORDER BY EvtName ASC LIMIT 30