spSitePagesByContentType

    CREATE PROCEDURE [dbo].[spSitePagesByContentType]
    (
        @ClientSitesID INT,
        @ContentTypesID INT
    )
    AS
    BEGIN
        SELECT
            DISTINCT vPC.PAGENAME, vPC.PAGEID
          FROM
            vwPageContent vPC
            INNER JOIN dbo.vwSitePages vSP ON vSP.ID = vPC.PageID
            AND vSP.DELETED=0
        WHERE
            vSP.CLIENTSITESID = @ClientSitesID
            AND vPC.ISTEMPLATEPAGE = 0
            AND vPC.CONTENTTYPESID = @ContentTypesID
            AND vSP.LOCKED = 0
        ORDER BY PAGENAME          
    END