Vragen?  +31 6 39 712 717
  Vroegboekvoordeel
   Laagsteprijsgarantie (1)
Meer informatie
An Error occured!SQLSTATE[42S22]: Column not found: 1054 Unknown column 'c.campsite_id' in 'on clause'
select c.campsite_id, c.campsite_latlong, c.campsite_name, co.country_id, co.country_value_nl as country_name, cr.country_region_id, cr.country_region_value_nl as region_name, c.campsite_city, c.search_score_nl, c.campsite_country, c.campsite_region, capl.campsite_accommodation_price_list_id as _x, c.campsite_stars, min(capl.campsite_accommodation_arrival_date) as campsite_accommodation_arrival_date, min(abs(datediff(capl.campsite_accommodation_arrival_date, '2024-05-11'))) as near from campsite_accommodation_price_list capl inner join campsite_group_combinations cgc on cgc.item_id=c.campsite_id inner join campsites c on capl.campsite_id = c.campsite_id inner join country co on co.country_id = c.campsite_country INNER JOIN campsite_accommodations ca ON ca.campsite_accommodation_id= capl.campsite_accommodation_id inner join country_region cr on cr.country_region_id = c.campsite_region where (select count(*) from imagepool_images iip where iip.campsite_id = c.campsite_id and isnull(iip.deleted_date) ) >0 and c.campsite_online=1 and ca.campsite_accommodation_state=1 and ifnull(capl.campsite_accommodation_stock,0)>0 and capl.campsite_accommodation_arrival_date >='2024-05-11 00:00:00' and capl.campsite_accommodation_price_duration = '7' and capl.campsite_accommodation_person_max >= '2' and cgc.item_id=c.campsite_id and cgc.group_id='11' group by c.campsite_id order by campsite_accommodation_final_price asc