Wyniki

Kemping w Niemczech - nad morzem, nad jeziorem lub w górach

    • Aktywny wypoczynek i rekreacja w pobliżu
    • Historyczne miasta, browarnie, winiarnie oraz ciekawe cele turystyczne
    • Dużo zabawy dla dzieci

Wakacje na kempingach nad Morzem Bałtyckim, w Pojezierzu Meklemburskim, Hawelandii lub bardzo popularne w okolicy Berlina. Bardziej luksusowe kempingi znajdują się w niemieckich pasmach niskich gór, przy jeziorze Bodeńskiem lub w Alpach Bawarskich. Kempingi w Niemczech oferują dużo zajęć sportowych: żeglarstwo, kajakarstwo, windsurfing, mini golf, tenis, piłka nożna, jazda konna, jazda na rowerze czy wędrówki. Wiele kempingów otwartych jest przez cały rok i oferują przygodę na każdą pogodę. Kryte baseny, place zabaw w budynku, zajęcia w cyrku lub warsztaty rzemieślnicze gwarantują wspaniałą rodzinną zabawę - nawet poza sezonem. A nocleg? Możesz zatrzymać się w domkach ogrzewanych zimą, albo w kwaterach. Wszędzie znajdziecie komfort połączony z atmosferą kempingową.

Po prostu spróbuj - kemping dla osób, które jeszcze nigdy nie były na kempingu

Twój partner nie chce jechać na kemping? Pewnie pamięta jeszcze niewygodne, małe namioty, mały materac do spania, zimne noce i upalne dni. Możesz go uspokoić. Te czasu już dawno minęły, a kemping stał się w międzyczasie bardzo popularną formą wypoczynku nawet dla najbardziej wymagających wczysowiczów. W pełni wyposażone zakwaterowania ze wszystkim czego potrzebujesz. Podczas gdy dzieci bawią się na placu zabaw z nowo poznanymi przyjaciółmi, rodzice w spokoju odpoczywają na tarasie zakwaterowania z dobrą książką w ręku.

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='10' 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