Třídová akce

Kód:

1

Tělo:

select 
  ID 
from 
  CRMCampaignBlackList 
where
  (Firm_ID in (select ID from Firms where ID=:Firm OR Firm_ID=:Firm)) and
  (FirmOffice_ID is null) and
  (Person_ID is null) and
  (
    (Lower(EmailAddress) = Lower(:Email)) or
    (EmailAddress = ' ')
  ) 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