SELECT  rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,
  comment_rev_comment.comment_text AS `rev_comment_text`,
  comment_rev_comment.comment_data AS `rev_comment_data`,
  comment_rev_comment.comment_id AS `rev_comment_cid`,
  actor_rev_user.actor_user AS `rev_user`,
  actor_rev_user.actor_name AS `rev_user_text`,
  temp_rev_user.revactor_actor AS `rev_actor`
FROM `revision`
JOIN `revision_comment_temp` `temp_rev_comment`
  ON ((temp_rev_comment.revcomment_rev = rev_id))
JOIN `comment` `comment_rev_comment`
  ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id))
JOIN `revision_actor_temp` `temp_rev_user`
  ON ((temp_rev_user.revactor_rev = rev_id AND revactor_page = rev_page))
JOIN `actor` `actor_rev_user`
  ON ((actor_rev_user.actor_id = temp_rev_user.revactor_actor))
WHERE rev_page = ?
  AND (rev_minor_edit != 0)
ORDER BY rev_timestamp DESC, rev_id DESC
LIMIT 21;

21 rows in set (0.00 sec)

+------+-------------+---------------------+--------+-----------------------------------------------------------+----------------+---------+-----------------------------------------------+-------+-------------+
| id   | select_type | table               | type   | possible_keys                                             | key            | key_len | ref                                           | rows  | Extra       |
+------+-------------+---------------------+--------+-----------------------------------------------------------+----------------+---------+-----------------------------------------------+-------+-------------+
|    1 | SIMPLE      | revision            | ref    | PRIMARY,page_timestamp,page_user_timestamp,rev_page_id    | page_timestamp | 4       | const                                         | 50390 | Using where |
|    1 | SIMPLE      | temp_rev_comment    | ref    | PRIMARY,revcomment_rev                                    | PRIMARY        | 4       | enwiki.revision.rev_id                        |     1 | Using index |
|    1 | SIMPLE      | comment_rev_comment | eq_ref | PRIMARY                                                   | PRIMARY        | 8       | enwiki.temp_rev_comment.revcomment_comment_id |     1 |             |
|    1 | SIMPLE      | temp_rev_user       | eq_ref | PRIMARY,revactor_rev,actor_timestamp,page_actor_timestamp | revactor_rev   | 4       | enwiki.revision.rev_id                        |     1 | Using where |
|    1 | SIMPLE      | actor_rev_user      | eq_ref | PRIMARY                                                   | PRIMARY        | 8       | enwiki.temp_rev_user.revactor_actor           |     1 |             |
+------+-------------+---------------------+--------+-----------------------------------------------------------+----------------+---------+-----------------------------------------------+-------+-------------+