(Mezinárodní den památek a sídel na hradě Bítov 2009)

[/home/projects/czecot.com/web/redesign/lib/ostatni/AkceBase.php,1365] Chyba pri provadeni dotazu " SELECT id_ac_opakovana_udalost, nazev, ( SELECT b.nazev FROM ac_opakovana_udalost_jazyk b WHERE b.id_ac_opakovana_udalost = ac_opakovana_udalost_jazyk.id_ac_opakovana_udalost AND b.id_jazyk = '1' ) as "nazev_cz", ARRAY_TO_STRING( ARRAY( SELECT id_ac_konani::text || '^' || nazev || '^' || (SELECT b.nazev FROM ac_konani_jazyk b WHERE b.id_ac_konani = ac_konani_jazyk.id_ac_konani AND b.id_jazyk = '1') || '^' || ARRAY_TO_STRING( ARRAY( SELECT CASE WHEN timestamp_start::text IS NOT NULL THEN timestamp_start::text || '#' || COALESCE(timestamp_end::text,'') WHEN date_start::text IS NOT NULL THEN date_start::text || '#' || COALESCE(date_end::text,'') ELSE SUBSTR(month_start::text,1,7) || '#' || SUBSTR(COALESCE(month_end::text,''),1,7) END FROM ac_konani_cas WHERE id_ac_konani=ac_konani_jazyk.id_ac_konani AND (timestamp_start IS NOT NULL OR date_start IS NOT NULL OR month_start IS NOT NULL) ), '|' ) FROM ac_konani_jazyk WHERE id_ac_konani IN ( SELECT id_ac_konani FROM ac_opakovana_udalost_ac_konani WHERE id_ac_opakovana_udalost=ac_opakovana_udalost_jazyk.id_ac_opakovana_udalost EXCEPT SELECT '29330' ) AND id_jazyk='3' ORDER BY ( SELECT COALESCE(timestamp_start,date_start,month_start) FROM ac_konani_cas WHERE id_ac_konani = ac_konani_jazyk.id_ac_konani ) desc ), '|*|' ) AS "konani", ARRAY_TO_STRING( ARRAY( SELECT id_ac_festival::text || '^' || nazev || '^' || (SELECT b.nazev FROM ac_festival_jazyk b WHERE b.id_ac_festival = ac_festival_jazyk.id_ac_festival AND b.id_jazyk = '1') FROM ac_festival_jazyk WHERE id_ac_festival IN ( SELECT id_ac_festival FROM ac_opakovana_udalost_ac_festival WHERE id_ac_opakovana_udalost=ac_opakovana_udalost_jazyk.id_ac_opakovana_udalost EXCEPT SELECT id_ac_festival FROM ac_festival_ac_konani WHERE id_ac_konani = '29330' ) AND id_jazyk='3' ORDER BY nazev DESC ), '|' ) AS "festival" FROM ac_opakovana_udalost_jazyk WHERE id_ac_opakovana_udalost IN ( SELECT id_ac_opakovana_udalost FROM ac_opakovana_udalost_ac_konani WHERE id_ac_konani='29330' UNION SELECT id_ac_opakovana_udalost FROM ac_opakovana_udalost_ac_festival WHERE id_ac_festival IN ( SELECT id_ac_festival FROM ac_festival_ac_konani WHERE id_ac_konani='29330' ) ) AND id_jazyk='3' ORDER BY id_ac_opakovana_udalost DESC ", posledni chyba:"ERROR: more than one row returned by a subquery used as an expression"

Wie kommt man mit dem Auto aus:	Albanien Andorra Belgien Bosnien und Hercegovina Bulgarien Dänemark Deutschland die Niederlande die Schweiz die Slowakei die Tschechische Republik Estland Finnland Frankreich Griechenland Groβbritannien Irland Italien Kosovo Kroatien Lettland Liechtenstein Litauen Luxemburg Makedonien Moldawien Monakko Montenegro Norwegen Österreich Polen Portugal Rumänien San Marino Schweden Serbien Slowenien Spanien Ungarn Vatikan Weiβruβland
Wegbeschreibung Zug/Autobus:	Abfahrtsort: Zielort: Abfahrt/Ankunft: Abfahrt Ankunft Nur Direktverbindungen: Fahrplan: Züge+Busse+Öffentliche Verkehrsmittel Züge Busse Öffentliche Verkehrsmittel Prag Bietet:
Die nächsten Eisenbahnstationen:	Rácovice 9 km , Třebelovice 9 km , Dědice 10 km ,
Busbahnhof:	Bítov 2 km
Flughafen:	Intrernationaler: Brno Tuřany 76 km , Wien 112 km , Pardubice 119 km Inland: Jihlava 53 km , Křižanov 56 km , Jindřichův Hradec 58 km Fläche für Sportflugzeuge: Dačice 23 km , Třebíč 32 km , Miroslav 44 km
Entfernung zum Parkplatz:	600 m (Kapazität - PkW: 100, Preis: 20 CZK /Tag Busse: 6, Preis: gratis)

Die angeführten Werte entsprechen der Luftlinie.

Ihre E-Mail:*
Durchführungsdatum:	Fr 18.4.2008
Datum:*