SELECT A.ID FROM Holidays A, WagePeriods B WHERE (A.WorkingRelation_ID = :WR) AND (B.ID = :WP) AND ((A.ValidFrom$DATE<=B.DateTo$DATE) AND (A.ValidTo$DATE>=B.DateFrom$DATE)) ORDER BY A.Priority
Generated by ABRA Software a.s. 27.10.2021 16:34:35