CMS-MENU-ERROR(OPEN - ): SELECT TOP 8 Publish_ItemVersion.ItemId,Publish_ItemVersion.Name,Publish_ItemVersion.Description,Publish_ItemVersion.StartDate,Publish_ItemVersion.MetaTitle,SUM(Publish_AAP_Calais_Article_Subjects.calculated_score) AS tot_score,Publish_ItemVersion_1.ItemId,Publish_ItemVersion_1.Name FROM Publish_ItemVersion LEFT OUTER JOIN Publish_ItemRelationship AS Publish_ItemRelationship1 ON (Publish_ItemRelationship1.ChildItemVersionId=Publish_ItemVersion.ItemVersionId) AND (Publish_ItemRelationship1.RelationshipTypeId=24) LEFT OUTER JOIN Publish_ItemVersion AS Publish_ItemVersion_1 ON (Publish_ItemRelationship1.ParentItemId=Publish_ItemVersion_1.ItemId) AND (Publish_ItemVersion_1.ApprovalStatusId=3) INNER JOIN Publish_Item ON Publish_ItemVersion.ItemVersionId = Publish_Item.ApprovedItemVersionId INNER JOIN Publish_ItemRelationship ON (Publish_ItemVersion.ItemVersionId=Publish_ItemRelationship.ChildItemVersionId) AND (Publish_ItemRelationship.RelationshipTypeId=28) AND (Publish_ItemRelationship.ParentItemId=20) INNER JOIN Publish_AAP_Calais_Article_Subjects ON (Publish_Item.ItemId=Publish_AAP_Calais_Article_Subjects.ItemId) AND (Publish_AAP_Calais_Article_Subjects.subject_id IN (SELECT TOP 3 Publish_AAP_Calais_Article_Subjects.subject_id FROM Publish_AAP_Calais_Article_Subjects WHERE (Publish_ItemVersion.DisplayTabId<>26) AND (Publish_AAP_Calais_Article_Subjects.ItemId=19749) AND (Publish_AAP_Calais_Article_Subjects.calculated_score>0) ORDER BY Publish_AAP_Calais_Article_Subjects.calculated_score DESC)) WHERE (NOT (Publish_ItemVersion.ItemVersionId IN (SELECT ChildItemVersionId FROM Publish_ItemRelationship WHERE (ParentItemId=19662) AND (RelationshipTypeId=29)))) AND (Publish_ItemVersion.ItemId IN (SELECT ItemId FROM Publish_AAP_Calais_Article_Subjects AS Publish_AAP_Calais_Article_Subjects_2 WHERE (subject_id IN (SELECT TOP 3 subject_id FROM Publish_AAP_Calais_Article_Subjects AS Publish_AAP_Calais_Article_Subjects_1 WHERE (ItemId=19749) AND (used_in_article_title=1) ORDER BY calculated_score DESC)))) GROUP BY Publish_ItemVersion.Name,Publish_ItemVersion.Description,Publish_ItemVersion.StartDate,Publish_ItemVersion.MetaTitle,Publish_ItemVersion.ItemId,Publish_ItemVersion_1.ItemId,Publish_ItemVersion_1.Name ORDER BY tot_score DESC