spSitePagesByContentRealmType

create PROCEDURE [dbo].[spSitePagesByContentRealmType]
(
    @ClientSitesID int,
    @ContentRealmTypeID int
)
AS

    SELECT
        DISTINCT PageName, PageID
    FROM
        vwPageContent

    WHERE
        ClientSitesID = @ClientSitesID
        and IsTemplatePage = 0
        and RealmTypeId = @ContentRealmTypeID

    Order by PageName