Notice: Undefined offset: 2 in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 735
SELECT rv.Date ,rv.id_employees ,r.name ,rv.id_department ,o.id_office ,o.startTime FROM tbl_schedule as rv INNER JOIN tbl_employees as r ON rv.id_employees=r.id_employees INNER JOIN tbl_calendar as k ON k.date=rv.date INNER JOIN tbl_citydepartmentoffice as o ON o.Id_cityDeparmentOffice=k.id_cityDepartmentOffice AND rv.id_department=o.id_department WHERE CONCAT(o.id_office,rv.Date) IN (SELECT CONCAT(o.id_office,rv.Date) as kljuc FROM tbl_sched