USP_DATALIST_THEME_LAYOUT

CREATE procedure dbo.USP_DATALIST_THEME_LAYOUT (@THEMEID uniqueidentifier)
as
    set nocount on;
    select 
        THEMELAYOUT.[ID],
        THEMELAYOUT.[THEMEID],
        THEMELAYOUT.[LAYOUTID],
        THEMELAYOUT.[SEQUENCE],
        SiteLayouts.Name
    from 
        dbo.THEMELAYOUT inner join dbo.SiteLayouts
        on THEMELAYOUT.LAYOUTID = SiteLayouts.id
  where 
        THEMELAYOUT.[THEMEID] = @THEMEID
  order by THEMELAYOUT.[SEQUENCE]