+----+-------------+------------------+-------+---------------+---------+---------+------------------------+------+----------------------------------------------+
| id | select_type | table            | type  | possible_keys | key     | key_len | ref                    | rows | Extra                                        |
+----+-------------+------------------+-------+---------------+---------+---------+------------------------+------+----------------------------------------------+
|  1 | SIMPLE      | schedules        | ALL   | NULL          | NULL    |    NULL | NULL                   | 1587 | Using where; Using temporary; Using filesort |
|  1 | SIMPLE      | client_locations | ref   | PRIMARY       | PRIMARY |       4 | vli.schedules.LOCATION |    1 |                                              |
|  1 | SIMPLE      | s_client         | index | NULL          | PRIMARY |      12 | NULL                   | 1227 | Using index                                  |
|  1 | SIMPLE      | client_profile   | ALL   | NULL          | NULL    |    NULL | NULL                   |  405 |                                              |
+----+-------------+------------------+-------+---------------+---------+---------+------------------------+------+----------------------------------------------+
4 rows in set (0.00 sec)