SQL query can be modified
The goal of these employees can be described as enslavement or something like that, so it should not be like this.
NOT EXISTS ( SELECT 1 FROM tbl_absent WHERE tbl_clients.specialId = tbl_absent.specialId AND '$varCurDate' BETWEEN tbl_absent.startDate AND tbl_absent.endDate )