SELECT A.ID
FROM SickBenefits A
WHERE
(A.WORKINGRELATION_ID=:WORKINGRELATION OR '0000000000'=:WORKINGRELATION)
AND
((SELECT Count(*) FROM SickBenefits2 SB2 WHERE A.ID=SB2.Parent_ID AND SB2.WagePeriod_ID=:WAGEPERIOD)>0
)
AND A.BaseSickType IN ({BASESICKTYPE})
ORDER BY A.DATEFROM$DATEGenerated by ABRA Software a.s. 27.10.2021 16:34:36