SELECT em.ID
FROM
Employees em
LEFT JOIN WorkingRelations wr ON em.ID = wr.Employee_ID
LEFT JOIN WageListPartial wlp ON wr.id = wlp.WorkingRelation_ID
WHERE
(em.Hidden='N') and (wlp.WagePeriod_ID = :WagePeriod_ID)
GROUP BY
em.ID
ORDER BY
em.IDGenerated by ABRA Software a.s. 27.10.2021 16:34:35