spSitePages

    CREATE PROCEDURE [dbo].[spSitePages]
    (
        @ClientSitesID INT,
        @PageTypeFilter INT
    )
    AS
    BEGIN
    IF @PageTypeFilter = 0 
        SELECT ID,CLIENTSITESID,PAGENAME,DISPLAYNAME,ISADMIN,BASEURL,EXPIREDATE,PUBLISHDATE,GUID,OWNERID,DELETED,TEMPLATEPAGEID,ISTEMPLATEPAGE,CATEGORY,LAYOUTNAME,TEMPLATEPAGENAME,LAYOUTID,TEMPLATELAYOUTNAME,TEMPLATELAYOUTID,TEMPLATEGUID,FOLDERID,PAGELAYOUTSTYLESHEET,TEMPLATELAYOUTSTYLESHEET,STYLESHEETID,DESCRIPTION,PAGEKEYWORDS,TEMPLATEKEYWORDS,USETEMPLATEKEYWORDS,TEMPLATEDESCRIPTION,UPDATEDATE,ISPAGEMODEL,FROMMODELID,LOCKED,ISTHEMED,THEMELAYOUTNUMBER,URL 
        , 0 as TemplateUsage 
        FROM vwSitePages
        WHERE
            CLIENTSITESID = @ClientSitesID
            AND LOCKED=0
            AND DELETED=0
          ORDER BY PAGENAME
      ELSE IF @PageTypeFilter = 1
          SELECT ID,CLIENTSITESID,PAGENAME,DISPLAYNAME,ISADMIN,BASEURL,EXPIREDATE,PUBLISHDATE,GUID,OWNERID,DELETED,TEMPLATEPAGEID,ISTEMPLATEPAGE,CATEGORY,LAYOUTNAME,TEMPLATEPAGENAME,LAYOUTID,TEMPLATELAYOUTNAME,TEMPLATELAYOUTID,TEMPLATEGUID,FOLDERID,PAGELAYOUTSTYLESHEET,TEMPLATELAYOUTSTYLESHEET,STYLESHEETID,DESCRIPTION,PAGEKEYWORDS,TEMPLATEKEYWORDS,USETEMPLATEKEYWORDS,TEMPLATEDESCRIPTION,UPDATEDATE,ISPAGEMODEL,FROMMODELID,LOCKED,ISTHEMED,THEMELAYOUTNUMBER,URL 
          , 0 as TemplateUsage
          FROM vwSitePages
      WHERE
        CLIENTSITESID = @ClientSitesID
        AND ISTEMPLATEPAGE = 0
        AND LOCKED=0
            AND DELETED=0
            ORDER BY PAGENAME
      ELSE IF @PageTypeFilter = 2
      SELECT ID,CLIENTSITESID,PAGENAME,DISPLAYNAME,ISADMIN,BASEURL,EXPIREDATE,PUBLISHDATE,GUID,OWNERID,DELETED,TEMPLATEPAGEID,ISTEMPLATEPAGE,CATEGORY,LAYOUTNAME,TEMPLATEPAGENAME,LAYOUTID,TEMPLATELAYOUTNAME,TEMPLATELAYOUTID,TEMPLATEGUID,FOLDERID,PAGELAYOUTSTYLESHEET,TEMPLATELAYOUTSTYLESHEET,STYLESHEETID,DESCRIPTION,PAGEKEYWORDS,TEMPLATEKEYWORDS,USETEMPLATEKEYWORDS,TEMPLATEDESCRIPTION,UPDATEDATE,ISPAGEMODEL,FROMMODELID,LOCKED,ISTHEMED,THEMELAYOUTNUMBER,URL 
      , CASE WHEN EXISTS (SELECT 1 FROM SitePages SP WHERE SP.TemplatePageID = vwSitePages.ID AND SP.DELETED = 0) THEN 1 ELSE 0 END AS TemplateUsage
      FROM vwSitePages
      WHERE
        CLIENTSITESID = @ClientSitesID
        AND ISTEMPLATEPAGE = 1
        AND LOCKED=0
            AND DELETED=0
        ORDER BY PAGENAME
END