Objektová akce

Kód:

3

Tělo:

SELECT A.ID FROM CRMCampaignAudiences A
left join Firms F on (F.ID=A.Firm_ID) 
WHERE A.Parent_ID =:OBJID and (A.AudienceState in (0, 2))
and not (A.ID in (select CCP.Audience_ID from CRMCampaignProcesses CCP where CCP.Campaign_ID = :OBJID)) order by F.Name 

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