Events

query
RESULTSET
query
  DATEFROM DATETO EMAIL ETIME EVENTADDINFO EVENTADDINFO_DT EVENTADDINFO_EN EVENTADDINFO_FR EVENTADDINFO_IT EVENTADDRESSBOOKING EVENTBROCHURE EVENTCAT EVENTDESCRIPTION EVENTDESCRIPTION_DT EVENTDESCRIPTION_EN EVENTDESCRIPTION_FR EVENTDESCRIPTION_IT EVENTFKADDRESSBOOKING EVENTFKADDRESSINFO EVENTID EVENTIMGURL EVENTLOCALITY EVENTPRICEFROM EVENTPRICETO EVENTRESERVATION EVENTRESORT EVENTTITLE EVENTTITLE_DT EVENTTITLE_EN EVENTTITLE_FR EVENTTITLE_IT FAX FK_RESORT IMAGEURL_ICON IMAGEURL_SMALL ORIGLANGUAGE PHONE STARTTIME STIME STREET URL1 X_COORD Y_COORD
CACHED false
EXECUTIONTIME 3
SQL select trim(e.title_it) as eventTitle, e.title_dt as eventTitle_dt, e.title_en as eventTitle_en, e.title_fr as eventTitle_fr, e.title_it as eventTitle_it, e.OrigLanguage_FK as OrigLanguage, datefrom, dateto, starttime, e.fk_resort, e.street, r.name as eventResort, c.name_it as eventCat, e.addressbooking as eventAddressbooking, e.phone, e.fax, trim(e.email) as email, trim(e.url) as url1, e.pricefrom as eventPriceFrom, e.priceto as eventPriceTo, e.description_it as eventDescription, e.description_dt as eventDescription_dt, e.description_en as eventDescription_en, e.description_fr as eventDescription_fr, e.description_it as eventDescription_it, e.addinfo_it as eventAddInfo, e.addinfo_dt as eventAddInfo_dt, e.addinfo_en as eventAddInfo_en, e.addinfo_fr as eventAddInfo_fr, e.addinfo_it as eventAddInfo_it, e.locality as eventLocality, e.picurl as eventImgUrl, e.pk_vk_event as eventID, e.reservationpossible as eventReservation, e.prospectusavailable as eventBrochure, e.fk_addressinfo as eventFKAddressinfo, e.fk_addressbooking as eventFKAddressbooking, e.x as x_coord, e.y as y_coord, date_format(starttime,'%H:%i') as stime, date_format(endtime,'%H:%i') as etime, imageurl_small, imageurl_icon from r_vk_events e, r_vk_eventdates ed, r_resorts r, r_vk_categories c where e.pk_vk_event = ? and (datefrom >= ADDDATE(NOW(),-1) or dateto >= ADDDATE(NOW(),-1)) and (datefrom = ?) and e.pk_vk_event = ed.fk_vk_event and r.pk_resort = e.fk_resort and c.pk_vk_category = e.fk_vk_category order by datefrom
SQLPARAMETERS
array
1 6095030
2 {ts '2012-05-26 00:00:00'}