Třídová akce

Kód:

5

Tělo:

select 
  ID 
from 
  CRMCampaignBlackList 
where
  (Firm_ID is null) and
  (Person_ID is null) and
  (Lower(EmailAddress) = Lower(:Email)) and
  (Hidden = 'N') and  
  ((:EMailChannel = 'X') or (:EMailChannel <> 'X' and EMail = :EMailChannel)) and
  ((:PostChannel = 'X') or (:PostChannel <> 'X' and Post = :PostChannel)) and
  ((:PersonalChannel = 'X') or (:PersonalChannel <> 'X' and Personal = :PersonalChannel)) and
  ((:PhoneChannel = 'X') or (:PhoneChannel <> 'X' and Phone = :PhoneChannel))

Generated by ABRA Software a.s. 27.10.2021 16:34:54