USP_DATALIST_MICROSITE_PAGEMODEL_PAGES

create procedure dbo.USP_DATALIST_MICROSITE_PAGEMODEL_PAGES(
    @CONTENTTYPESID int = null
)
as
    set nocount on;


SELECT 
    SitePages.[Guid] as ID
    ,SitePages.ID As PAGEID
    ,SiteContent.ContentTypesID AS CTID
    ,SiteContent.ID AS CID
    ,PageContent.PaneName AS PANENAME
FROM dbo.PageContent
inner join dbo.SiteContent 
    on PageContent.SiteContentID = SiteContent.ID 
inner join dbo.SitePages
    on SitePagesID = SitePages.ID 
where 
    (SitePagesID = (select cast(value as int) from micrositesetting where micrositesetting=2) and ContentTypesID = @ContentTypesID)
    --and PaneName = 'well-known main microsite content pane'