<br />
<b>Notice</b>:  Undefined offset: 2 in <b>/home2/icentarb/public_html/icentar/classes/class.permissions.php</b> on line <b>735</b><br />
SELECT r1.date, e1.id_employees, r1.id_department, s1.id_office, s1.startTime
FROM tbl_schedule as r1
INNER JOIN tbl_calendar AS k1 ON r1.date = k1.date
INNER JOIN tbl_citydepartmentoffice AS s1
    ON (k1.id_cityDepartmentOffice = s1.Id_cityDeparmentOffice AND r1.id_department = s1.id_department)
INNER JOIN tbl_employees AS e1 ON r1.id_employees=e1.id_employees
WHERE r1.date = DATE('2020-06-01')
        AND s1.id_office =(
                                    SELECT s2.id_office
                                    FROM tbl_schedule as r2
                                    INNER JOIN tbl_calendar AS k2 ON r2.date = k2.date
                                    INNER JOIN tbl_citydepartmentoffice AS s2 
                                            ON (k2.id_cityDepartmentOffice = s2.Id_cityDeparmentOffice
                                                  AND r2.id_department = s2.id_department)
                                    INNER JOIN tbl_emplo