Notice: Undefined offset: 2 in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 735
SELECT rv.id_employees ,r.name ,rv.Date ,rv.id_department ,o.id_office ,CONCAT(k.id_cityDepartmentOffice,rv.id_department) as kljuc 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 o.id_office IN (SELECT o.id_office FROM tbl_sched