Publication Search
SELECT '
' + dbo.fn_cme_unescape(nvchTitle) + '' 'link', dtDate FROM ( SELECT DISTINCT(d.uidPublicationId), d.nvchTitle, d.dtDate FROM tblPublicationDoc d INNER JOIN tblPublicationDocCategorizationLookups dl ON d.uidPublicationId = dl.uidPublicationId INNER JOIN tblCategorizationCategories c ON c.intSchemeCategoryId = dl.intSchemeCategoryId WHERE c.intSchemeCategoryId IN ( SELECT intCrossRefNum AS 'intSchemeCategoryId' FROM tblContentLookups WHERE intPageID= '3005' UNION SELECT intSourceSchemeCategoryId AS 'intSchemeCategoryId' FROM vw_Categorization_Parents WHERE intSourceSchemeCategoryId IN (SELECT intCrossRefNum FROM tblContentLookups WHERE intPageID='3005' ) ) ) query
