> explain select buildrequests.buildername, buildsets.results from changes, sourcestamp_changes, sourcestamps, buildsets, buildrequests where changes.revision=232184 and sourcestamp_changes.changeid = changes.changeid and sourcestamps.id=sourcestamp_changes.sourcestampid and buildsets.sourcestampid=sourcestamps.id and buildrequests.buildsetid=buildsets.id;
+----+-------------+---------------------+--------+---------------+---------+---------+--------------------------------------------+------+-------------------+
| id | select_type | table               | type   | possible_keys | key     | key_len | ref                                        | rows | Extra             |
+----+-------------+---------------------+--------+---------------+---------+---------+--------------------------------------------+------+-------------------+
|  1 | SIMPLE      | sourcestamp_changes | ALL    | NULL          | NULL    | NULL    | NULL                                       | 4492 |                   |
|  1 | SIMPLE      | buildrequests       | ALL    | NULL          | NULL    | NULL    | NULL                                       | 2466 | Using join buffer |
|  1 | SIMPLE      | buildsets           | eq_ref | PRIMARY       | PRIMARY | 4       | buildbot.buildrequests.buildsetid          |    1 | Using where       |
|  1 | SIMPLE      | changes             | eq_ref | PRIMARY       | PRIMARY | 4       | buildbot.sourcestamp_changes.changeid      |    1 | Using where       |
|  1 | SIMPLE      | sourcestamps        | eq_ref | PRIMARY       | PRIMARY | 4       | buildbot.sourcestamp_changes.sourcestampid |    1 | Using index       |
+----+-------------+---------------------+--------+---------------+---------+---------+--------------------------------------------+------+-------------------+
5 rows in set (0.00 sec)