query
RESULTSET
query
  ADDED ADDON CEHOURS CONF_DAY COURSE_FEE1 COURSE_FEE2 COURSE_FEE3 COURSE_FEE4 COURSE_FEE5 CUSTOMEMAILMESSAGE DAY1 DAY2 DENTIST_ONLY DESCR EMAILCONF ENDS EVENT_CODE EVENT_NO E_DAY FTEXPDATE GUEST HADDRESS1 HADDRESS12 HADDRESS2 HADDRESS22 HCITY HCITY2 HCOUNTRY HCOUNTRY2 HOTEL HOTEL2 HPHONE HPHONE2 HSTATE HSTATE2 HZIP HZIP2 IAEXAM ID ID INCLUDED INDEX_ID INDEX_ID LIMIT LINK LIVE LOC LOCATIONCODE LOCTYPE NAME NAME2 NOCONFLICT NOTES NOTES1 NOTES2 NOTES2 NUMDAYSDISPLAY ONLINETRAINING ONLINETRAINING PART_NO POLICIES PREREQ RBID REQCODE REQ_APP SEQ SOLD_OUT SORTORDER SPEAKER1 START STREAMLINK STREAMLINK S_DAY TIME_DISPLAY TITLE TITLE2 TYPE TYPE1 TYPE2 TYPE3 TYPE4 TYPE5 TYPE6 TYPE7
CACHED false
EXECUTIONTIME 187
SQL SELECT t.event_no as added ,e.*,l.*, c.descr FROM locations l left join event e on l.[id]+''+l.seq = e.loc and (e.type IS NULL OR e.type = '') left join classes c on e.rbid = c.class_id left join ticket t on e.id = t.event_no and t.registration_id = '0' and t.attendee_no = '' WHERE l.[id]+''+l.seq = '1452%20,1452%20' and e.event_code NOT IN ('r','a','d') and e.part_no IS NULL /*and e.course_fee1 > -1 */ order by e.sortOrder