Třídová akce

Kód:

2

Tělo:

SELECT
  PP.ID
FROM
  GDPRProcessingPermits PP
  JOIN Firms F ON F.ID = PP.Firm_ID
WHERE
  PP.Source_ID in {Source_IDs} AND
  PP.Rule_ID = :Rule_ID AND
  (F.Firm_ID = (SELECT COALESCE(F2.Firm_ID, F2.ID) FROM Firms F2 WHERE F2.ID = :Firm_ID)
     OR F.ID = (SELECT COALESCE(F2.Firm_ID, F2.ID) FROM Firms F2 WHERE F2.ID = :Firm_ID)) AND
  PP.ValidToDate$DATE >= :MinValidToDate
ORDER BY
  PP.CreatedAt$DATE DESC

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