Kein Event vorhanden

query
RESULTSET
query
  DATEFROM DATETO EMAIL ETIME EVENTADDINFO EVENTADDINFO_DE EVENTADDINFO_EN EVENTADDINFO_FR EVENTADDINFO_IT EVENTADDRESSBOOKING EVENTBROCHURE EVENTCAT EVENTDESCRIPTION EVENTDESCRIPTION_DE EVENTDESCRIPTION_EN EVENTDESCRIPTION_FR EVENTDESCRIPTION_IT EVENTFKADDRESSBOOKING EVENTFKADDRESSINFO EVENTID EVENTIMGURL EVENTLOCALITY EVENTPRICEFROM EVENTPRICETO EVENTRESERVATION EVENTRESORT EVENTTITLE EVENTTITLE_DE EVENTTITLE_EN EVENTTITLE_FR EVENTTITLE_IT FAX FK_RESORT IMAGEURL_ICON IMAGEURL_SMALL ORIGLANGUAGE PHONE STARTTIME STIME STREET URL1 X Y
CACHED false
EXECUTIONTIME 5
SQL select trim(e.title_fr) as eventTitle, e.title_dt as eventTitle_de, 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_fr 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.imageurl_icon as imageurl_icon, e.imageurl_small as imageurl_small, e.priceto as eventPriceTo, e.description_fr as eventDescription, e.description_dt as eventDescription_de, e.description_en as eventDescription_en, e.description_fr as eventDescription_fr, e.description_it as eventDescription_it, e.addinfo_fr as eventAddInfo, e.addinfo_dt as eventAddInfo_de, 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.x,e.y, e.reservationpossible as eventReservation, e.prospectusavailable as eventBrochure, e.fk_addressinfo as eventFKAddressinfo, e.fk_addressbooking as eventFKAddressbooking, date_format(starttime,'%H:%i') as stime, date_format(endtime,'%H:%i') as etime 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 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 6508469