m-00kie

mysql> explain  select * from schedules LEFT JOIN client_locations ON client_locations.ID = schedules.LOCATION LEFT JOIN s_client ON s_client.SID = schedules.ID LEFT JOIN client_profile ON client_profile.UID = s_client.UID where schedules.START_DATE >= '2005-10-01 00:00:00' AND schedules.END_DATE <= '2005-10-31 23:59:59' ORDER BY START_DATE ASC;+----+-------------+------------------+-------+---------------+---------+---------+------------------------+------+----------------------------------------------+| id | select_type | table            | type  | possible_keys | key     | key_len | ref                    | rows | Extra                                        |+----+-------------+------------------+-------+---------------+---------+---------+------------------------+------+----------------------------------------------+|  1 | SIMPLE      | schedules        | ALL   | NULL          | NULL    |    NULL | NULL                   | 1313 | 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                   | 1256 | Using index                                  ||  1 | SIMPLE      | client_profile   | ALL   | NULL          | NULL    |    NULL | NULL                   |  442 |                                              |+----+-------------+------------------+-------+---------------+---------+---------+------------------------+------+----------------------------------------------+4 rows in set (0.00 sec)