spGetSiteStyleSheets

CREATE procedure dbo.spGetSiteStyleSheets
(
       @ClientSitesID int
)
as
begin

    select 
        SiteStyleSheets.ID,
        SiteStyleSheets.[Name],
        SiteStyleSheets.[ClientSitesID],
        SiteStyleSheets.[Description],
        SiteStyleSheets.[CustomCSS],
        SiteStyleSheets.[Guid],
        SiteStyleSheets.[OwnerID],
        SiteStyleSheets.[Deleted],
        SiteStyleSheets.[CustomCssXml],
        SiteStyleSheets.[CreateDate],
        SiteStyleSheets.[CopySourceID],
        SiteStyleSheets.[CopyBatchGUID],
        SiteStyleSheets.MediaType,
        SiteStyleSheets.BrowserType,
        COALESCE(PM.LOCKARTIFACTS,0) as Locked
    from SiteStyleSheets
       left outer join (select PAGEMODELITEM.OBJECTGUID, PAGEMODEL.LOCKARTIFACTS from dbo.pagemodel inner join dbo.PAGEMODELITEM on PAGEMODEL.ID = PAGEMODELITEM.PAGEMODELID) PM on PM.OBJECTGUID = SiteStyleSheets.Guid 
    where 
        clientsitesid = @ClientSitesID 
        and deleted = 0
    order by 
        [name]

end