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