query
RESULTSET
query
  ADDON CEHOURS CONF_DAY COURSE_FEE1 COURSE_FEE2 COURSE_FEE3 COURSE_FEE4 COURSE_FEE5 DAY1 DAY2 DENTIST_ONLY 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 PART_NO POLICIES PREREQ RBID REQCODE REQ_APP SEQ SOLD_OUT SORTORDER SPEAKER1 START S_DAY TIME_DISPLAY TITLE TITLE2 TYPE TYPE1 TYPE2 TYPE3 TYPE4 TYPE5 TYPE6 TYPE7
CACHED false
EXECUTIONTIME 32
SQL SELECT e.*,l.* FROM locations l left join event e on l.[id]+''+l.seq = e.loc and (e.type IS NULL OR e.type = '') WHERE l.[id]+''+l.seq = '660 ' and e.event_code NOT IN ('r','a','d') /*and e.course_fee1 > 0 */ order by e.sortOrder