USP_DATALIST_FAFTHEME

        CREATE procedure dbo.USP_DATALIST_FAFTHEME(@EVENTID uniqueidentifier ) with execute as owner
        as
          set nocount on;

        select SSS.CUSTOMCSS from SiteStyleSheets SSS where ID in (
              SELECT   TSS.STYLESHEETID 
                  FROM EVENTEXTENSION EE  
                  LEFT OUTER JOIN dbo.CMSSITESETTING CMS on EE.CLIENTSITESID = cms.CLIENTSITESID and cms.SETTING = 'defaulttheme'  
                  LEFT OUTER JOIN dbo.THEMESTYLESHEET TSS on CMS.VALUE = TSS.themeid  
                  where EVENTID = @EVENTID

                  union

                  select SL.StyleSheetID  FROM EVENTEXTENSION EE  
                  LEFT OUTER JOIN dbo.CMSSITESETTING CMS on EE.CLIENTSITESID = cms.CLIENTSITESID and cms.SETTING = 'defaulttheme'  
                  LEFT OUTER JOIN dbo.THEMELAYOUT TL on CMS.VALUE = TL.THEMEID     
                  left join dbo.SiteLayouts SL on TL.LAYOUTID = SL.ID
                  where EVENTID = @EVENTID
                  group by SL.StyleSheetID
                  )