USP_DATALIST_THEMES_IN_MODEL

CREATE procedure dbo.USP_DATALIST_THEMES_IN_MODEL(@MODELID uniqueidentifier)
as
    set nocount on;

    select 
      t.ID, 
      t.NAME, 
      t.DESCRIPTION, 
      t.LAYOUTID, 
      t.TEMPLATEID, 
      t.CLIENTSITESID
  from dbo.THEME t
    inner join dbo.PAGEMODELITEM pmi
    on t.ID=pmi.OBJECTGUID
    where pmi.MODELID=@MODELID