USP_DATALIST_LAYOUTSTYLESHEETSFORSITEDELIVERYCHANNEL

CREATE procedure dbo.USP_DATALIST_LAYOUTSTYLESHEETSFORSITEDELIVERYCHANNEL(@CMSDELIVERYCHANNELID uniqueidentifier, @SITEID int)
as
    set nocount on;

    select distinct(SiteStyleSheets.ID) from SiteStyleSheets
    join SiteLayouts on SiteLayouts.StyleSheetID = SiteStyleSheets.ID
    join CMSTEMPLATELAYOUT on CMSTEMPLATELAYOUT.SITELAYOUTSID = SiteLayouts.ID
    join SitePages on SitePages.ID = CMSTEMPLATELAYOUT.TEMPLATEID
    left outer join dbo.PAGEMODELITEM PMI on PMI.OBJECTGUID = SiteStyleSheets.Guid
    left outer join (select * from dbo.PAGEMODEL where LOCKARTIFACTS = 1) PM on PM.ID = PMI.PAGEMODELID
    where SitePages.ClientSitesID = @SITEID
    and CMSTEMPLATELAYOUT.CMSDELIVERYCHANNELID = @CMSDELIVERYCHANNELID
    and PM.LOCKARTIFACTS is null