spGetPageIdForContentType

        CREATE procedure dbo.spGetPageIdForContentType(@ContentTypesID int)
        as

        select top 1
        SitePages.[ID]
        From dbo.SitePages
        inner join dbo.PageContent on PageContent.SitePagesId = SitePages.ID
        where PageContent.SiteContentId = @ContentTypesID
        and SitePages.Deleted = 0 and SitePages.IsTemplatePage = 0