spGetSiteLayouts

CREATE PROCEDURE [dbo].[spGetSiteLayouts] (
    @ClientSitesID  int
)
AS

    select
        SiteLayouts.ClientSitesID,
        SiteLayouts.Name,
        SiteLayouts.Description,
        SiteLayouts.ID,
        SiteLayouts.Content,
        SiteLayouts.Guid,
        SiteLayouts.OwnerID,
        SiteLayouts.Deleted,
        SiteLayouts.Stylesheet,
        SiteLayouts.StyleSheetID,
        SiteLayouts.DocType,
        SiteLayouts.CreateDate,
        SiteLayouts.CopySourceID,
        SiteLayouts.CopyBatchGUID,
        COALESCE(PM.LOCKARTIFACTS,0) as Locked
    from
        dbo.SiteLayouts
        left outer join (select PAGEMODELITEM.OBJECTGUID, PAGEMODEL.LOCKARTIFACTS from dbo.pagemodel inner join dbo.PAGEMODELITEM on PAGEMODEL.ID = PAGEMODELITEM.PAGEMODELID) PM on PM.OBJECTGUID = SiteLayouts.Guid 
    where 
        ClientSitesID = @ClientSitesID 
        and Deleted = 0
    order by
        Name