| SQL |
select
trim(e.title_en) 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_en 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_en 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_en 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 |
