Untitled

SELECT DISTINCT cms.ID

FROM dt_cms_schema.CMSStory cms, dbo.AdDbPageInfo adbpi, dbo.StoryPageElements spe, dbo.Story s, dbo.SubCategory sc, dbo.status st, dbo.Desk d

WHERE (adbpi.runDate BETWEEN '2011-04-27' AND '2011-08-05')

AND cms.story->storyId = s.storyId

AND sc.subCategoryId = 191173

AND s.storyId = spe.storyId

AND spe.logicalPagesId = adbpi.logicalPageId

AND s.subCategoryId = sc.subCategoryId

AND s.StatusId = st.StatusId

AND s.deskId = d.deskId

AND s.words > 10

AND d.deskName <> 'trash'

AND st.statusName IN ('ready', 'output', 'web')

AND NOT (s.subCategoryId in (0, 2, 51, 52, 54, 101, 200, 300, 1000, 1023, 176447, 330788, 1905902))

AND NOT (s.storyname LIKE '%ol.wed%' OR s.storyname LIKE '%ol.gold%')

AND NOT (s.origin LIKE '%Wire%' OR s.origin LIKE '%NYT')

ORDER BY adbpi.runDate DESC, adbpi.letter ASC, adbpi.pagenum ASC, s.words DESC