Třídová akce

Kód:

2

Tělo:

Select
  (DQ.Code || '-' || CAST(A.OrdNumber AS VARCHAR(10)) || '/' ||  P.Code) as DisplayName,
  CT.Name as Description,
  A.DocDate$Date as Date$Date,
  a.ID as ID,
  CCA.FirmID as FirmID
from CRMCampaignes A
  left join DocQueues DQ on (A.DocQueue_ID = DQ.ID)
  left join Periods P on (A.Period_ID = P.ID)
  left join CRMCampaignTypes CT on (A.CampaignType_ID = CT.ID)
  join (Select CA.Parent_ID as ID, CA.Firm_ID as FirmID from CRMCampaignAudiences CA where CA.Firm_ID IN
  (Select F.ID from Firms F where F.ID = :ID or (F.Firm_ID = :ID)) group by CA.Parent_ID, CA.Firm_ID) CCA on (A.ID = CCA.ID) and
  (a.DocDate$DATE >= :DateFrom) and (a.DocDate$DATE < :DateTo + 1)

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