CMS-MENU-ERROR(OPEN - ): SELECT TOP 1 Publish_AAP_Calais_Article_Subjects.ItemId,Publish_ItemVersion.Name,Publish_ItemVersion.Description,Publish_ItemVersion.StartDate,Publish_ItemVersion.MetaTitle,Publish_ItemVersion_1.Name,Publish_ItemVersion_1.ItemId FROM Publish_AAP_Calais_Subjects INNER JOIN Publish_AAP_Calais_Article_Subjects ON Publish_AAP_Calais_Subjects.subject_id = Publish_AAP_Calais_Article_Subjects.subject_id INNER JOIN Publish_Item ON (Publish_AAP_Calais_Article_Subjects.ItemId = Publish_Item.ItemId) AND (Publish_Item.ItemTypeId IN (1,12,13)) INNER JOIN Publish_ItemVersion ON (Publish_Item.ApprovedItemVersionId=Publish_ItemVersion.ItemVersionId) AND (Publish_ItemVersion.ApprovalStatusId=3) INNER JOIN Publish_ItemRelationship ON (Publish_ItemVersion.ItemVersionId=Publish_ItemRelationship.ChildItemVersionId) AND (Publish_ItemRelationship.RelationshipTypeId=28) AND (Publish_ItemRelationship.ParentItemId=20) 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) WHERE (REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LOWER(Publish_AAP_Calais_Subjects.subject_name),'|',''),')',''),'.',''),'/',''),'#',''),'&',''),'?',''),'"',''),'''',''),'`',''),',',''),'!',''),'@',''),'$',''),'%',''),':',''),'*',''),'<',''),'>',''),';',''),'\',''),'(',''),' ','-'),' ','-')='andy-samberg') AND (Publish_ItemVersion.DisplayTabId<>26) AND (Publish_ItemVersion.DisplayTabId<>76) AND (NOT (Publish_ItemVersion.ItemVersionId IN (SELECT ChildItemVersionId FROM AAP_DisabledArticles))) AND (Publish_ItemVersion.StartDate<=GETDATE()) AND (Publish_ItemVersion.EndDate>GETDATE()) ORDER BY Publish_AAP_Calais_Subjects.used_as_master_topic DESC,Publish_AAP_Calais_Article_Subjects.calculated_score DESC,Publish_ItemVersion.StartDate DESC