| 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 |