SELECT A.ID FROM WageListPartial A
JOIN WorkingRelations B ON A.WorkingRelation_ID = B.ID
JOIN WagePeriods WP ON A.WagePeriod_ID = WP.ID
WHERE ((B.Employee_ID = :EmployeeID) or (:EmployeeID = '0000000000')) AND
IB_DecodeDate_Year(WP.DateFrom$DATE) = :YearNumber Generated by ABRA Software a.s. 27.10.2021 16:34:36