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'.
[Error loading the control 'Accomodation', check event log for more details]

[DataConnection.HandleError]:

Query:
SELECT TOP 4 * FROM
(
SELECT *, ROW_NUMBER() OVER (ORDER BY PriorityInFulltext, DocumentLastPublished DESC, NodeOrder) AS [CMS_ORN], ROW_NUMBER() OVER (PARTITION BY DocumentNodeID ORDER BY CASE WHEN NodeLinkedNodeID IS NULL THEN 1 ELSE 2 END) AS [CMS_DUP] FROM View_CzT_Place_Joined WHERE [NodeSiteID] = @NodeSiteID AND (Region = AND NodeLinkedNodeId IS NULL AND '|' + Category + '|' Like '%|10|%'

) AND ([Published] = @Published AND [DocumentCulture] = @DocumentCulture)
)
AS SubData
WHERE [CMS_DUP] = @CMS_DUP ORDER BY CMS_ORN

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