SELECT bd.*,e.No AS "EmpNo",e.Type,IFNULL(e.NameID,e.Name,e.NameID) AS "EmpName",
e.DepartmentNo,e.Placing,es.TradeGroup AS "EmpGroup",es.TradeLevel AS "EmpLevel",c.FromTime,c.ToTime
FROM BookDetailsTEST bd, Employes e
LEFT OUTER JOIN EmpBookSetups es ON es.EmpNo=e.No
AND (bd.TradeGroup IS NULL OR bd.TradeGroup=es.TradeGroup) AND (bd.TradeLevel IS NULL OR bd.TradeLevel<=es.TradeLevel)
LEFT OUTER JOIN Calendar c ON c.EmpNo=e.No AND c."Date"=:TestDate AND c.DepartmentNo=1 AND c.Status=0
AND c.Online=TRUE
WHERE IFNULL(bd.FixedEmpNo,TRUE,e.No=bd.FixedEmpNo) AND e.Active=TRUE
AND e.Online=TRUE
GROUP BY Step,Priority,RefRecID,EmpLevel,EmpNo,FromTime
HAVING FromTime IS NOT NULL OR (Type=2 AND (DepartmentNo IS NULL OR DepartmentNo=1))