SQLSTATE |
42S22 |
DATASOURCE |
montefio1064732 |
VENDORERRORCODE |
207 |
SQL |
SELECT TOP 1000 smx_eventMgmtSystem.ref,
smx_eventMgmtSystem.m_date_create,smx_eventMgmtSystem.m_date_mod,smx_eventMgmtSystem.m_username,smx_eventMgmtSystem.eventTitle,smx_eventMgmtSystem.category,smx_eventMgmtSystem.location,smx_eventMgmtSystem.m_date_activate,smx_eventMgmtSystem.m_date_expire,smx_eventMgmtSystem.ongoing,smx_eventMgmtSystem.eventStartDate,smx_eventMgmtSystem.eventEndDate,smx_eventMgmtSystem.EventDuration,smx_eventMgmtSystem.eventStartTime,smx_eventMgmtSystem.eventEndTime,smx_eventMgmtSystem.weekDays,smx_eventMgmtSystem.description,smx_eventMgmtSystem.maxAttendees,smx_eventMgmtSystem.costFee,smx_eventMgmtSystem.contactInformation,smx_eventMgmtSystem.email,smx_eventMgmtSystem.prerequisites
FROM smx_eventMgmtSystem
WHERE 0=0
and ((1=0) or (eventTitle = 'Manage Your Diabetes Workshop') ) and ((m_date_activate is null) or (m_date_activate <= {ts '2019-02-17 18:41:01'})) and ((m_date_expire is null) or (m_date_expire > '02/17/2019')) AND
( m_date_activate IS NULL OR m_date_activate <= getdate() ) AND
(
(
m_date_expire IS NOT NULL
AND m_date_expire >= getdate()
)
OR
(
m_date_expire IS NULL
AND
(
(
ongoing = 'T'
AND
(
eventEndDate IS NULL
OR eventEndDate >= DateAdd(day,-1,getdate())
)
) OR (
ongoing != 'T'
AND
(
(
(email IS NULL OR len(email)=0)
AND eventEndDate IS NOT NULL
AND eventEndDate >= DateAdd(day,-1,getdate())
) OR (
(
(email IS NOT NULL AND len(email)>0)
OR eventEndDate IS NULL
) AND (
eventStartDate IS NOT NULL
AND eventStartDate >= DateAdd(day,-1,getdate())
)
)
)
)
)
)
)
order by locationcustom,category,eventStartDate,eventTitle |
|