UFN_FAFWEBSITE_ISIMPORTED

CREATE function dbo.UFN_FAFWEBSITE_ISIMPORTED(@EVENTID uniqueidentifier)
returns bit
with execute as caller
as begin
    declare @ISIMPORTED bit

  select 
    @ISIMPORTED = case when (CMS2.value = '0' or CMS3.value = '0') then 0 else 1 end
  from dbo.EVENTEXTENSION EX 
  join dbo.ClientSites CS on EX.CLIENTSITESID = CS.ID 
  left join dbo.PAGEMODEL PM on CS.ID = PM.CLIENTSITESID
  left join dbo.CMSSITESETTING CMS2 on CS.ID = CMS2.CLIENTSITESID and CMS2.ENUMID = 2
  left join dbo.CMSSITESETTING CMS3 on CS.ID = CMS3.CLIENTSITESID and CMS3.ENUMID = 3
  where EX.EVENTID = @EVENTID

    return @ISIMPORTED
end