Holiday in the CR:CZeCOTTourmapsEast BohemiaUNESCOCzech inspirationActive holidayTimetablesGEOFUN
Go to text of this page CZeCOT logo The Tourist Portal of the Czech Republic
Czech out Czechia!

extended search
ČeskyDeutschEnglishEspañolFrançaisItalianoNederlandsPolskiпо-русскиCooperation with usCooperation with us  Website mapWebsite map
Book accommodation online: Arrival: Nights:
Photogallery Videogallery
Virtual Tours Weather
Tourist programmes Experience packages
Audio gallery Events calendar
Maps  
Tourist Information Service
News
Region

Czech Republic
Bohemian Forest
Bohemian North
Frýdlant Region
Lázně Libverda
Jizerské Mountains
Mácha’s Country
The Lusatian Mountains and Ještěd Ridge
Lázně Kundratice
Bohemian Paradise
Central Bohemia
Central Bohemia - Labe region
Lázně Toušeň
Poděbrady
Central Bohemia - south
Central Bohemia - west
Central Moravia
Slatinice
Teplice nad Bečvou
East Bohemia
Bohemian-Moravian borderlands
Svitavy
Chrudim-Hlinsko Region
Hradec Králové Region
Hradec Králové
Kladsko Borderland
Velichovky
Králický Sněžník
Orlické Mountains and Podorlicko
Pardubice Region
Lázně Bohdaneč
Highlands (Vysočina)
Krkonoše (Giant Mountains)
Foothills of the Krkonoše Mountains
Lázně Bělohrad
Janské Lázně
Špindlerův Mlýn
North Moravia and Silesia
Beskydy - Valašsko
Jeseníky
Bludov
Jeseník
Karlova Studánka
Lipová-lázně
Velké Losiny
Odra river - Moravian Kravaře region
Ostrava Region
Klimkovice
Silesia around Opava
Silesia around Těšín
Darkov - Karviná
Northwestern Bohemia
Central Bohemian Uplands and Žatecko
Mšené-lázně
Děčín Region and Lusatian Mountains
Krušné Mountains and Podkrušnohoří
Klášterec nad Ohří
Teplice
Pilsen Region
Chodsko
Pilsen
Tachov-Stříbro Region
Konstantinovy Lázně
Prague
Southern Bohemia
Bechyně
Třeboň
Vráž by Písek
South Moravia
Brno and its surroundings
Brno
Lednice - Valtice Region
Lednice
Podyjí
Slovácko
Hodonín
Ostrožská Nová Ves
The Moravian Karst and its environs
Zlín Region
Kostelec u Zlína
Luhačovice
Western Bohemian Spas
Western Bohemian Spas
Františkovy Lázně
Jáchymov
Karlovy Vary (Carlsbad)
Lázně Kynžvart
Mariánské Lázně (Marienbad)

Topic
Active holiday
news
Guide Czechie Walker Guide Czechie Walker
Tips of Czechie Walker:
  • For quick search use fulltext or server map.
  • Would you like to be sent news from various tourism areas or regions? Register your e-mail address for news delivery.

Current tip:
Hotel České Žleby
Hotel České Žleby

Čelina - Jewish cemetery
Čelina - Jewish cemetery

Cooperation with us
Login to administration
Server partners

CzechTourism logo

Survey results

Result of search

Result of search

total found:, shown:1-

Do not click this link and this link or you will be banned!

loginImage
[/data/home/projects/czecot.com/web/soubory/kemp-vyhledavani.php,43] Chyba pri provadeni dotazu "SELECT ( SELECT count(*) FROM nadstandardni_zaznam_stredisko WHERE id_stredisko = .id_ AND stredisko = 6 AND id_nadstandardni_zaznam IN (6,8) AND expirace::date >= now()::date ) as "tucny_zapis", firma.wgs84lat, firma.wgs84long,kemp.datum_otevreni, kemp.logosoubor,firma.logosoubor as "logosoubor2",kemp.id_kemp,(SELECT nazev || coalesce((select ' (' || nazev || ')' from kemp_jazyk r where r.id_kemp=kemp_jazyk.id_kemp and r.id_jazyk='1' and r.nazev<>kemp_jazyk.nazev),'') FROM kemp_jazyk WHERE id_kemp=kemp.id_kemp AND id_jazyk='2') as "nazev",firma.ulice,firma.psc,firma.obec,(CASE WHEN firma.s42x>'0' THEN firma.s42x ELSE (SELECT s42x FROM uir.obec WHERE obec_kod=firma.adresa_obec_kod::numeric(6,0)) END) AS "s42x",(CASE WHEN firma.s42y>'0' THEN firma.s42y ELSE (SELECT s42y FROM uir.obec WHERE obec_kod=firma.adresa_obec_kod::numeric(6,0)) END) AS "s42y",kemp.email,kemp.kod_previo,kemp.previo_collaboration,( NOT ( ( coalesce(kemp.datum_otevreni,'1980-1-1')>coalesce(kemp.datum_uzavreni,'1981-1-1') AND (current_timestampcoalesce(kemp.datum_otevreni,'1980-1-1')) ) OR ( coalesce(kemp.datum_otevreni,current_timestamp-interval'00:01')current_timestamp ) ) ) AS "skrtat" FROM firma,kemp WHERE (( firma.tregion_kod IN ( SELECT idr_uir_tregion FROM region WHERE id_region IN ('15') ) OR firma.toblast_kod IN ( SELECT idr_uir_toblast FROM region WHERE id_region IN ('15') ) )) AND ((firma.ukaz_jazyk & '2')>'0') AND (id_zeme = 57) AND (firma.id_kemp=kemp.id_kemp) AND ((datum_uzavreni IS NULL AND (datum_otevreninow() AND (datum_otevreni IS NULL OR datum_otevreninow()) ORDER BY ( SELECT count(*) FROM nadstandardni_zaznam_stredisko WHERE id_stredisko = .id_ AND stredisko = 6 AND id_nadstandardni_zaznam = 8 AND expirace::date >= now()::date ) DESC, oficialni desc, nls_string((SELECT nazev FROM kemp_jazyk WHERE id_kemp=kemp.id_kemp AND id_jazyk='2'),'en_US.UTF-8')", posledni chyba:"ERROR: syntax error at or near "." LINE 8: id_stredisko = .id_ ^"#0 add_error(Chyba pri provadeni dotazu "SELECT ( SELECT count(*) FROM nadstandardni_zaznam_stredisko WHERE id_stredisko = .id_ AND stredisko = 6 AND id_nadstandardni_zaznam IN (6,8) AND expirace::date >= now()::date ) as "tucny_zapis", firma.wgs84lat, firma.wgs84long,kemp.datum_otevreni, kemp.logosoubor,firma.logosoubor as "logosoubor2",kemp.id_kemp,(SELECT nazev || coalesce((select ' (' || nazev || ')' from kemp_jazyk r where r.id_kemp=kemp_jazyk.id_kemp and r.id_jazyk='1' and r.nazev<>kemp_jazyk.nazev),'') FROM kemp_jazyk WHERE id_kemp=kemp.id_kemp AND id_jazyk='2') as "nazev",firma.ulice,firma.psc,firma.obec,(CASE WHEN firma.s42x>'0' THEN firma.s42x ELSE (SELECT s42x FROM uir.obec WHERE obec_kod=firma.adresa_obec_kod::numeric(6,0)) END) AS "s42x",(CASE WHEN firma.s42y>'0' THEN firma.s42y ELSE (SELECT s42y FROM uir.obec WHERE obec_kod=firma.adresa_obec_kod::numeric(6,0)) END) AS "s42y",kemp.email,kemp.kod_previo,kemp.previo_collaboration,( NOT ( ( coalesce(kemp.datum_otevreni,'1980-1-1')>coalesce(kemp.datum_uzavreni,'1981-1-1') AND (current_timestampcoalesce(kemp.datum_otevreni,'1980-1-1')) ) OR ( coalesce(kemp.datum_otevreni,current_timestamp-interval'00:01')current_timestamp ) ) ) AS "skrtat" FROM firma,kemp WHERE (( firma.tregion_kod IN ( SELECT idr_uir_tregion FROM region WHERE id_region IN ('15') ) OR firma.toblast_kod IN ( SELECT idr_uir_toblast FROM region WHERE id_region IN ('15') ) )) AND ((firma.ukaz_jazyk & '2')>'0') AND (id_zeme = 57) AND (firma.id_kemp=kemp.id_kemp) AND ((datum_uzavreni IS NULL AND (datum_otevreninow() AND (datum_otevreni IS NULL OR datum_otevreninow()) ORDER BY ( SELECT count(*) FROM nadstandardni_zaznam_stredisko WHERE id_stredisko = .id_ AND stredisko = 6 AND id_nadstandardni_zaznam = 8 AND expirace::date >= now()::date ) DESC, oficialni desc, nls_string((SELECT nazev FROM kemp_jazyk WHERE id_kemp=kemp.id_kemp AND id_jazyk='2'),'en_US.UTF-8')", posledni chyba:"ERROR: syntax error at or near "." LINE 8: id_stredisko = .id_ ^", /data/home/projects/czecot.com/web/soubory/kemp-vyhledavani.php, 43) called at [/data/home/projects/czecot.com/web/lib/db_postgre.php:61] #1 query(SELECT ( SELECT count(*) FROM nadstandardni_zaznam_stredisko WHERE id_stredisko = .id_ AND stredisko = 6 AND id_nadstandardni_zaznam IN (6,8) AND expirace::date >= now()::date ) as "tucny_zapis", firma.wgs84lat, firma.wgs84long,kemp.datum_otevreni, kemp.logosoubor,firma.logosoubor as "logosoubor2",kemp.id_kemp,(SELECT nazev || coalesce((select ' (' || nazev || ')' from kemp_jazyk r where r.id_kemp=kemp_jazyk.id_kemp and r.id_jazyk='1' and r.nazev<>kemp_jazyk.nazev),'') FROM kemp_jazyk WHERE id_kemp=kemp.id_kemp AND id_jazyk='2') as "nazev",firma.ulice,firma.psc,firma.obec,(CASE WHEN firma.s42x>'0' THEN firma.s42x ELSE (SELECT s42x FROM uir.obec WHERE obec_kod=firma.adresa_obec_kod::numeric(6,0)) END) AS "s42x",(CASE WHEN firma.s42y>'0' THEN firma.s42y ELSE (SELECT s42y FROM uir.obec WHERE obec_kod=firma.adresa_obec_kod::numeric(6,0)) END) AS "s42y",kemp.email,kemp.kod_previo,kemp.previo_collaboration,( NOT ( ( coalesce(kemp.datum_otevreni,'1980-1-1')>coalesce(kemp.datum_uzavreni,'1981-1-1') AND (current_timestampcoalesce(kemp.datum_otevreni,'1980-1-1')) ) OR ( coalesce(kemp.datum_otevreni,current_timestamp-interval'00:01')current_timestamp ) ) ) AS "skrtat" FROM firma,kemp WHERE (( firma.tregion_kod IN ( SELECT idr_uir_tregion FROM region WHERE id_region IN ('15') ) OR firma.toblast_kod IN ( SELECT idr_uir_toblast FROM region WHERE id_region IN ('15') ) )) AND ((firma.ukaz_jazyk & '2')>'0') AND (id_zeme = 57) AND (firma.id_kemp=kemp.id_kemp) AND ((datum_uzavreni IS NULL AND (datum_otevreninow() AND (datum_otevreni IS NULL OR datum_otevreninow()) ORDER BY ( SELECT count(*) FROM nadstandardni_zaznam_stredisko WHERE id_stredisko = .id_ AND stredisko = 6 AND id_nadstandardni_zaznam = 8 AND expirace::date >= now()::date ) DESC, oficialni desc, nls_string((SELECT nazev FROM kemp_jazyk WHERE id_kemp=kemp.id_kemp AND id_jazyk='2'),'en_US.UTF-8'), /data/home/projects/czecot.com/web/soubory/kemp-vyhledavani.php, 43) called at [/data/home/projects/czecot.com/web/soubory/kemp-vyhledavani.php:43] #2 include(/data/home/projects/czecot.com/web/soubory/kemp-vyhledavani.php) called at [/data/home/projects/czecot.com/web/index.php:1372]