[Error loading the control 'ADVTourBlock4', check event log for more details]

[DataConnection.HandleError]:

Query:
SELECT [Name], [DocumentName], [NodeAliasPath], [Image], [CropValues], [CropValuesMobile], [HeroImage], [Duration], [TravelDeal], [ShortDescription], [TravelDealHomepageText], [DealPrice], [Price], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [SiteName], [ClassName], [NodeLevel], [NodeOrder], [NodeParentID] FROM
(
SELECT [Name], [DocumentName], [NodeAliasPath], [Image], [CropValues], [CropValuesMobile], [HeroImage], [Duration...

... ROW_NUMBER() OVER (ORDER BY NodeOrder ASC) 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_Adv_Tour_Joined WHERE [NodeSiteID] = @NodeSiteID AND (NodeID in ()) AND ([Published] = @Published AND (NodeAliasPath LIKE N'/tours-and-destinations/%') AND [DocumentCulture] = @DocumentCulture)
)
AS SubData
WHERE [CMS_C] = @CMS_C ORDER BY CMS_ORN

Caused exception:
Incorrect syntax near ')'.