Prague

Prague, City of a Hundred Spires, a UNESCO monument and one of the most beautiful cities in the world. Get to know it in person!

The Old Town Hall with the famous Prague Astronomical Clock. The winding lanes of the Jewish Quarter, which you know from the novels of Franz Kafka, steeped in the legend of the Golem. Cafes enticing you to come and have a seat, boutiques and sight-seeing cruises on the Vltava. The Gothic Charles Bridge and Church of St. Nicholas in the Lesser Town, the most beautiful Baroque church in Prague. The Palace Gardens set away from the bustle of the city, Petřín with a lookout tower reminiscent of a small Eiffel Tower and Prague Castle … Each of Prague’s districts has its own characteristic atmosphere and unique charm. Prague presents itself to you as a changeable city, which likes to alternate styles: it is romantic and successful, ancient and modern, but above all it is a city that is cosmopolitan through and through, and is used to welcoming foreigners. It is time to get acquainted.

Download guides and brochure
 

Events Nearby

    No data found
[Error loading the control 'Events', check event log for more details]

[DataConnection.HandleError]:

Query:
SELECT [NodeId], [DocumentId], [DocumentCulture], [NodeAliasPath], [DateFrom], [DateTo], [Title], [Perex], [Published], [Location], [NodeLinkedNodeID], [DocumentMenuCaption], [PriorityInFulltext], [EventTypeNew], [Region], [SiteName], [ClassName], [NodeLevel], [NodeOrder], [NodeParentID] FROM
(
SELECT [NodeId], [DocumentId], [DocumentCulture], [NodeAliasPath], [DateFrom], [DateTo], [Title], [Perex], [Published], [Location...

...AS [CMS_ORN], ROW_NUMBER() OVER (PARTITION BY NodeID ORDER BY CASE WHEN [DocumentCulture] = @DocumentCulture THEN 1 ELSE 2 END) AS [CMS_C] FROM View_CzT_Events_Joined WHERE [NodeSiteID] = @NodeSiteID AND (Region= AND DateTo >= GETDATE()) AND ([Published] = @Published AND (NodeAliasPath LIKE N'/Tourists/events/%') AND [DocumentCulture] = @DocumentCulture)
)
AS SubData
WHERE [CMS_C] = @CMS_C ORDER BY CMS_ORN

Caused exception:
Incorrect syntax near the keyword 'AND'.