+----+-------------+------------+--------+-----------------------------------+------------------+---------+-------------------------------------+------+---------------------------------------------+
| id | select_type | table      | type   | possible_keys                     | key              | key_len | ref                                 | rows | Extra                                       |
+----+-------------+------------+--------+-----------------------------------+------------------+---------+-------------------------------------+------+---------------------------------------------+
|  1 | PRIMARY     | <derived2> | ALL    | NULL                              | NULL             | NULL    | NULL                                |  103 | Using temporary; Using filesort             |
|  1 | PRIMARY     | pm         | ref    | post_id,meta_key                  | post_id          | 8       | p.ID                                |    4 | Using where                                 |
|  1 | PRIMARY     | ctt        | range  | PRIMARY,term_id_taxonomy,taxonomy | term_id_taxonomy | 106     | NULL                                |    3 | Using where; Using index; Using join buffer |
|  1 | PRIMARY     | ctr        | eq_ref | PRIMARY,term_taxonomy_id          | PRIMARY          | 16      | p.ID,voxcharta.ctt.term_taxonomy_id |    1 | Using index                                 |
|  1 | PRIMARY     | tr         | ref    | PRIMARY,term_taxonomy_id          | PRIMARY          | 8       | voxcharta.pm.post_id                |   14 | Using where; Using index                    |
|  1 | PRIMARY     | tt         | eq_ref | PRIMARY,taxonomy                  | PRIMARY          | 8       | voxcharta.tr.term_taxonomy_id       |    1 | Using where                                 |
|  2 | DERIVED     | wp_posts   | range  | type_status_date,post_date        | type_status_date | 132     | NULL                                |  102 | Using where                                 |
+----+-------------+------------+--------+-----------------------------------+------------------+---------+-------------------------------------+------+---------------------------------------------+
7 rows in set (0.05 sec)