SELECT A.ID
FROM WorkingRelations A
WHERE
(A.Employee_ID = :EMPLOYEE) and
((' ' = :Hidden) or (A.Hidden = :Hidden)) and
(A.DateOfBegin$DATE <= :DATEFROM) and
((A.DateOfEnd$DATE = 0) or (A.DateOfEnd$DATE >= :DATEFROM))
ORDER BY A.TypeOfActivity, A.DateOfBegin$DATE Generated by ABRA Software a.s. 27.10.2021 16:34:36