USP_DATALIST_STYLESHEET_BY_THEME

CREATE procedure dbo.USP_DATALIST_STYLESHEET_BY_THEME
as
      set nocount on;

  select 
    ss.ID,
    t.NAME as 'Theme',
    t.ID as 'ThemeID',
    ss.Name,
    ss.Description,
    tss.Sequence,
    ss.ClientSitesID,
    cs.Name 'Site',
    pmi.MODELID,
    pm.MODELNAME,
    pm.LOCKARTIFACTS
    from 
    SiteStyleSheets ss left outer join THEMESTYLESHEET tss on ss.ID = tss.STYLESHEETID
    left outer join THEME t on tss.THEMEID=t.ID
    inner join ClientSites cs on cs.ID = ss.ClientSitesID
    left outer join PAGEMODELITEM pmi on pmi.OBJECTGUID=ss.Guid
    left outer join PAGEMODEL pm on pm.ID=pmi.PAGEMODELID
    where ss.Deleted=0
    order by ss.ClientSitesID, t.NAME, tss.SEQUENCE, ss.Name