Поиск кемпа / дачного поселка - CZeCOT - Отдых и проживание

Отпуск в Чешской республике:CZeCOT Tourmaps Восточная Чехия UNESCO GEOFUN

	Tуристический портал Чешской Республики Познайте Чехию с CZeCOT!	расширенный поиск
Сотрудничество с нами План сайта

Результат запроса

всего найдено:, изображенный:1-

[/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='4') 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 ('18') ) OR firma.toblast_kod IN ( SELECT idr_uir_toblast FROM region WHERE id_region IN ('18') ) )) AND ((firma.ukaz_jazyk & '8')>'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='4'),'ru_RU.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='4') 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 ('18') ) OR firma.toblast_kod IN ( SELECT idr_uir_toblast FROM region WHERE id_region IN ('18') ) )) AND ((firma.ukaz_jazyk & '8')>'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='4'),'ru_RU.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='4') 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 ('18') ) OR firma.toblast_kod IN ( SELECT idr_uir_toblast FROM region WHERE id_region IN ('18') ) )) AND ((firma.ukaz_jazyk & '8')>'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='4'),'ru_RU.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:1383]