```
mysql> explain select page_id, page_title, page_touched, rev_id from page left join revision on rev_page = page_id where page_latest = 0;
+----+-------------+----------+------+------------------------+---------+---------+---------------------+--------+-------------+
| id | select_type | table    | type | possible_keys          | key     | key_len | ref                 | rows   | Extra       |
+----+-------------+----------+------+------------------------+---------+---------+---------------------+--------+-------------+
|  1 | SIMPLE      | page     | ALL  | NULL                   | NULL    | NULL    | NULL                | 144350 | Using where |
|  1 | SIMPLE      | revision | ref  | PRIMARY,page_timestamp | PRIMARY | 4       | muppet.page.page_id |      2 | Using index |
+----+-------------+----------+------+------------------------+---------+---------+---------------------+--------+-------------+
```