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 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 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 FROM vwSitePages
      WHERE
        CLIENTSITESID = @ClientSitesID
        AND ISTEMPLATEPAGE = 1
        AND LOCKED=0
            AND DELETED=0
        ORDER BY PAGENAME
END