spGetPagesForContentType

CREATE procedure [dbo].[spGetPagesForContentType] (@ClientSitesID int, @ContentTypesID int) as
select distinct 
sp.ID PageID, 
sp.PageName, 
COALESCE(PM.LOCKARTIFACTS,0) as Locked
from dbo.SitePages sp
inner join dbo.PageContent pc on pc.SitePagesId = sp.ID
inner join dbo.SiteContent sc on sc.ID = pc.SiteContentID
left outer join (select PAGEMODELITEM.OBJECTGUID, PAGEMODEL.LOCKARTIFACTS from dbo.pagemodel inner join dbo.PAGEMODELITEM on PAGEMODEL.ID = PAGEMODELITEM.PAGEMODELID) PM on PM.OBJECTGUID = sp.Guid 
where sp.Deleted = 0 and sp.IsTemplatePage = 0 and sp.ClientSitesID = @ClientSitesID and sc.ContentTypesID = @ContentTypesID and sc.Deleted = 0
order by sp.PageName;