Wyniki

Region wakacyjny Pikardia we Francji to prawdziwy raj dla miłośników kempingów i przyrody. Malownicze krajobrazy, liczne zabytki i bogate dziedzictwo kulturowe sprawiają, że region oferuje wszystko, czego pragnie twoje serce.

Pikardia jest znana z pięknych krajobrazów i bogatej przyrody. Zielone lasy, falujące wzgórza i malownicze krajobrazy rzeczne stanowią doskonałe tło dla wakacji na kempingu. W regionie znajduje się wiele kempingów, od małych, rodzinnych obiektów po duże, w pełni wyposażone ośrodki. Niektóre kempingi znajdują się w pobliżu takich atrakcji jak Château de Compiègne czy Parc du Marquenterre, podczas gdy inne są położone w bardziej wiejskich miejscach i oferują możliwość cieszenia się naturą i odpoczynku.

Jedną z głównych atrakcji regionu Pikardii jest miasto Amiens. Stolica Pikardii słynie ze swojej sztuki, architektury i żywej sceny kulturalnej. Wakacje na kempingu w tym regionie dają możliwość zwiedzenia miasta i zobaczenia słynnych zabytków, takich jak Katedra w Amiens czy Maison de Jules Verne. W mieście znajduje się wiele muzeów, teatrów i innych instytucji kulturalnych, które warto odwiedzić.

Oprócz miasta Amiens w regionie Pikardii znajduje się wiele innych zabytków i atrakcji do odkrycia. Château de Compiègne jest jednym z najsłynniejszych zamków we Francji i oferuje wspaniałą architekturę i ogrody. Parc du Marquenterre to piękny park krajobrazowy z licznymi ścieżkami spacerowymi i miejscami na pikniki. A dla tych, którzy lubią spędzać czas na świeżym powietrzu, region oferuje wiele możliwości uprawiania turystyki pieszej, rowerowej i konnej.

Wakacje na kempingu w regionie Pikardii to okazja, by cieszyć się przyrodą i kulturą Francji. Jest wiele powodów, dla których Pikardia jest idealnym miejscem na wakacje na kempingu!

An Error occured!SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION'
( select ''as tt_campsite_id, c.campsite_id, /*str_radius*/ c.campsite_name, ifnull(c.campsite_bestplace,0) as campsite_bestplace, ifnull(c.campsite_status,0) as campsite_status, c.campsite_latlong, co.country_value_pl as country_name, cr.country_region_value_pl as region_name, c.campsite_zip, c.campsite_phone, c.campsite_email, c.campsite_website, c.campsite_city, c.campsite_country, c.campsite_region,c.campsite_street, GROUP_CONCAT( cc.campsite_characteristic_id ) as defids , ( select concat('[', GROUP_CONCAT( DISTINCT( concat('{"id":"', cc.campsite_characteristic_id, '","title":"', cc.campsite_characteristic_name_pl , '","icon": "', cc.campsite_characteristic_type_icon,'"}' ) ) ) ,']') ) as char_defs, ( select concat('[', (select GROUP_CONCAT(DISTINCT CONCAT(' {"image":"', ac.campsite_accommodation_type_icon ,'", "id":"', ac.campsite_accommodation_type_id,'", "pos":"', ac.sortposition,'", "text":"', ac.campsite_accommodation_type_value_pl,'"}' ) ) from campsite_accommodations_combinations acc inner join campsite_accommodation_type ac on ac.campsite_accommodation_type_id = acc.campsite_accommodation_type_id where acc.campsite_id=c.campsite_id GROUP by acc.campsite_id ) ,']') ) as json_accos, ( select concat('[', (select GROUP_CONCAT(DISTINCT CONCAT('{"provider":"',p.campsite_provider_name, '", "provider_id":"',p.campsite_provider_id, '", "provider_image":"', ifnull(p.campsite_provider_image,'') , '", "id":"', cpc.campsite_provider_combination_id , '","deeplink":"', cpc.deeplink, '","premium":"', (select count(*) from campsite_provider_premium cpp where cpp.campsite_provider_id = cpc.campsite_provider_id and cpp.campsite_id =c.campsite_id ),'"}' ) order by (select count(*) from campsite_provider_premium cpp where cpp.campsite_provider_id = cpc.campsite_provider_id and cpp.campsite_id =c.campsite_id ) desc ) from campsite_provider p inner join campsite_provider_combinations cpc on cpc.campsite_provider_id = p.campsite_provider_id inner join campsite_accommodations_combinations cac on (cac.campsite_provider_id = p.campsite_provider_id and cac.campsite_id = cpc.campsite_id ) left join campsite_provider_status s on ( s.campsite_provider_id = p.campsite_provider_id and s.campsite_id = cpc.campsite_id ) where cpc.campsite_id=c.campsite_id and cpc.language='pl' and cpc.deeplink!='' and ifnull(p.campsite_provider_status,1)<=1 and ifnull(p.campsite_provider_activ_pl,1)=1 and ifnull(s.campsite_provider_status_value,1)=1 ) ,']') ) as provider_json, ifnull(c.campsite_description_pl,'') as campsite_description, c.campsite_stars /*, ( select GROUP_CONCAT(post_id) as posts from wp_postmeta WHERE meta_key='cb_campsite_id' and meta_value=c.campsite_id ) as post_ids */ from campsites c inner join campsite_characteristics_combinations ccc on ccc.campsite_id = c.campsite_id inner join campsite_characteristics cc on cc.campsite_characteristic_id=ccc.campsite_characteristic_id inner join country co on co.country_id = c.campsite_country 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_country='1' and c.campsite_region='145' and (select count(*) from campsite_provider_combinations acc_main inner join campsite_provider p on p.campsite_provider_id = acc_main.campsite_provider_id left join campsite_provider_status s on ( s.campsite_provider_id = p.campsite_provider_id and s.campsite_id = acc_main.campsite_id ) where acc_main.campsite_id=c.campsite_id and acc_main.language='pl' and ifnull(p.campsite_provider_activ_pl,1)=1 and ifnull(s.campsite_provider_status_value,1)=1 and acc_main.deeplink!='') >0 and c.campsite_online=1 and ifnull(c.campsite_online_pl,1)=1 group by c.campsite_id order by ifnull(c.campsite_bestplace,0) desc, -c.campsite_description_de DESC, FIELD(c.campsite_status, '7') DESC, (select count(*) from campsite_provider_combinations acc_main where acc_main.campsite_id=c.campsite_id and acc_main.language='pl' and acc_main.deeplink!='') desc ) UNION ( SELECT t.tt_campsite_id, t.campsite_id AS campsite_id, t.name AS campsite_name, 0 AS campsite_bestplace, 1 AS campsite_status, concat(t.latitude, ',', t.longitude) AS campsite_latlong, t.country AS country_name, t.region AS region_name, '' AS campsite_zip, '' AS campsite_phone, '' AS campsite_email, '' AS campsite_website, t.city AS campsite_city, t.country AS campsite_country, t.region AS campsite_region, t.address AS campsite_street, '' AS defids, '' AS char_defs, '' AS json_accos, '' AS provider_json, '' AS campsite_description, '' AS campsite_stars FROM tradetracker_campsites t where t.language = 'pl' )limit 0,12