cumin2024@db1192.eqiad.wmnet[wikidatawiki]> explain SELECT  rev_id,rev_page,rev_actor,actor_rev_user.actor_user AS `rev_user`,actor_rev_user.actor_name AS `rev_user_text`,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`,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name,page_is_new,(SELECT  GROUP_CONCAT(ctd_name SEPARATOR ',')  FROM `change_tag` JOIN `change_tag_def` ON ((ct_tag_id=ctd_id))   WHERE (ct_rev_id=rev_id)  ) AS `ts_tags`,ores_damaging_cls.oresc_probability AS `ores_damaging_score`,0.385 AS `ores_damaging_threshold`  FROM `revision` FORCE INDEX (rev_actor_timestamp) JOIN `actor` `actor_rev_user` ON ((actor_rev_user.actor_id = rev_actor)) JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = rev_comment_id)) JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) LEFT JOIN `ores_classification` `ores_damaging_cls` ON (ores_damaging_cls.oresc_model = 11 AND (ores_damaging_cls.oresc_rev=rev_id) AND ores_damaging_cls.oresc_class = 1)   WHERE actor_name = 'Jarekt' AND (page_namespace = 1) AND ((rev_deleted & 4) = 0)  ORDER BY rev_timestamp DESC,rev_id DESC LIMIT 51 ;
+------+--------------------+---------------------+--------+----------------------------+-----------------------+---------+------------------------------------------+---------+-------------+
| id   | select_type        | table               | type   | possible_keys              | key                   | key_len | ref                                      | rows    | Extra       |
+------+--------------------+---------------------+--------+----------------------------+-----------------------+---------+------------------------------------------+---------+-------------+
|    1 | PRIMARY            | actor_rev_user      | const  | PRIMARY,actor_name         | actor_name            | 257     | const                                    | 1       |             |
|    1 | PRIMARY            | user                | const  | PRIMARY                    | PRIMARY               | 4       | const                                    | 1       |             |
|    1 | PRIMARY            | revision            | ref    | rev_actor_timestamp        | rev_actor_timestamp   | 8       | const                                    | 2300078 | Using where |
|    1 | PRIMARY            | page                | eq_ref | PRIMARY,page_name_title    | PRIMARY               | 4       | wikidatawiki.revision.rev_page           | 1       | Using where |
|    1 | PRIMARY            | ores_damaging_cls   | eq_ref | oresc_rev_model_class      | oresc_rev_model_class | 7       | wikidatawiki.revision.rev_id,const,const | 1       |             |
|    1 | PRIMARY            | comment_rev_comment | eq_ref | PRIMARY                    | PRIMARY               | 8       | wikidatawiki.revision.rev_comment_id     | 1       |             |
|    2 | DEPENDENT SUBQUERY | change_tag          | ref    | ct_rev_tag_id,ct_tag_id_id | ct_rev_tag_id         | 5       | wikidatawiki.revision.rev_id             | 1       | Using index |
|    2 | DEPENDENT SUBQUERY | change_tag_def      | eq_ref | PRIMARY                    | PRIMARY               | 4       | wikidatawiki.change_tag.ct_tag_id        | 1       |             |
+------+--------------------+---------------------+--------+----------------------------+-----------------------+---------+------------------------------------------+---------+-------------+
8 rows in set (0.002 sec)