SELECT A.ID
FROM SickBenefits2 A
JOIN SickBenefits SB ON A.Parent_ID = SB.ID
WHERE (SB.WorkingRelation_ID = :WR) and
(SB.ID <> :SBID) and
(
((A.PaidFrom$DATE <= :PAIDTO) and (A.PaidFrom$DATE >= :PAIDFROM))
or
((A.PaidTo$DATE <= :PAIDTO) and (A.PaidTo$DATE >= :PAIDFROM))
)Generated by ABRA Software a.s. 27.10.2021 16:34:36