USP_DATALIST_PAGEMODELS_CONTAINING_ARTIFACT

create procedure dbo.USP_DATALIST_PAGEMODELS_CONTAINING_ARTIFACT(@OBJECTGUID uniqueidentifier)
as
    set nocount on;

    select 
        pm.[ID],
        pm.[MODELNAME],
        pm.[MODELID],
        pm.[CLIENTSITESID],
        pm.[DATELASTIMPORT],
        pm.[LOCKARTIFACTS],
        pmi.[OBJECTTYPEID]
    from 
        dbo.PAGEMODEL pm inner join dbo.PAGEMODELITEM pmi
        on pm.ID = pmi.PAGEMODELID
    where 
        pmi.OBJECTGUID=@OBJECTGUID