Nach dem verheerenden Erdbeben in Haiti stehen die SOS-Kinderdörfer betroffenen Kindern und Familien bei. Hier informieren wir Sie über unsere laufenden Hilfsaktionen und die aktuelle Lage.
Failed to load widget object.
[DataConnection.HandleError]:
Query:
WITH AllData AS
(
SELECT TOP 20 [NodeAliasPath], [DocumentUrlPath], [ListableDocumentImage], [BaseImage], [ListableDocumentTitle], [BaseHeadline], [ListableDocumentRollupText], [BaseIntroduction], [OccurrenceDate], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeOrder], [NodeParentID], ROW_NUMBER() OVER (ORDER BY [CMS_ORN]) AS [CMS_RN]
FROM (
SELECT [NodeAliasPath], [DocumentUrlPath], [ListableDocumentImage], [BaseImage], [ListableDocumentTitle], [BaseHeadline], [ListableDocumentRollupText], [BaseIntroduction], [OccurrenceDate], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeOrder], [NodeParentID], ROW_NUMBER() OVER (PARTITION BY DocumentNodeID, DocumentCulture ORDER BY CASE WHEN NodeLinkedNodeID IS NULL THEN 1 ELSE 2 END) AS [CMS_DUP], ROW_NUMBER() OVER (ORDER BY NewsOccurrenceDate DESC) AS [CMS_ORN]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN SOS_News AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[NewsID] AND V.ClassName = N'SOS.News' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (DocumentID IN (select DocumentID from CMS_DocumentCategory where CategoryID in (227)) AND DocumentID IN (select DocumentID from CMS_DocumentCategory where CategoryID in (216))) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
) AS SubData
WHERE [CMS_DUP] = @CMS_DUP
)
SELECT *, (SELECT COUNT(*) FROM AllData) AS [CMS_TOT]
FROM AllData
WHERE CMS_RN BETWEEN 1 AND 10
ORDER BY CMS_RN
Caused exception:
Invalid column name 'NewsOccurrenceDate'.