SELECT SB2.ID FROM SickBenefits2 SB2 LEFT JOIN SickBenefits SB ON (SB.ID = SB2.Parent_ID) WHERE SB.ShortenHolidayClaim=:AShortenClaim AND SB.WorkingRelation_ID=:AWorkingRelationID AND SB2.AbsentFrom$DATE>=:ADateFrom AND SB2.AbsentTo$DATE<=:ADateTo
Generated by ABRA Software a.s. 27.10.2021 16:34:36