SELECT /*! STRAIGHT_JOIN */ rc_id,rc_timestamp,rc_namespace,rc_title,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type,rc_source,rc_patrolled,rc_ip,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,rc_actor,r [TRX#328c5e]

SELECT /* SpecialRecentChanges::doMainQuery */ /*! STRAIGHT_JOIN */ rc_id, rc_timestamp, rc_namespace, rc_title, rc_minor, rc_bot, rc_new, rc_cur_id, rc_this_oldid, rc_last_oldid, rc_type, rc_source, rc_patrolled, rc_ip, rc_old_len, rc_new_len, rc_deleted, rc_logid, rc_log_type, rc_log_action, rc_params, rc_actor, recentchanges_actor.actor_user AS `rc_user`, recentchanges_actor.actor_name AS `rc_user_text`, comment_rc_comment.comment_text AS `rc_comment_text`, comment_rc_comment.comment_data AS `rc_comment_data`, comment_rc_comment.comment_id AS `rc_comment_cid`, wl_user, wl_notificationtimestamp, we_expiry, page_latest, (SELECT GROUP_CONCAT(ctd_name SEPARATOR ', ') FROM `change_tag` JOIN `change_tag_def` ON ((ct_tag_id=ctd_id)) WHERE ct_rc_id=rc_id ) AS `ts_tags`, fp_stable, fp_pending_since, ores_damaging_cls.oresc_probability AS `ores_damaging_score`, ores_goodfaith_cls.oresc_probability AS `ores_goodfaith_score` FROM `recentchanges` JOIN `actor` `recentchanges_actor` ON ((actor_id=rc_actor)) JOIN `comment` `comment_rc_comment` ON ((comment_rc_comment.comment_id = rc_comment_id)) LEFT JOIN `user` ON ((actor_user=user_id)) LEFT JOIN `watchlist` ON (wl_user = 20093189 AND (wl_title=rc_title) AND (wl_namespace=rc_namespace)) LEFT JOIN `watchlist_expiry` ON ((wl_id = we_item)) LEFT JOIN `page` ON ((rc_cur_id=page_id)) LEFT JOIN `flaggedpages` ON ((fp_page_id = rc_cur_id)) LEFT JOIN `ores_classification` `ores_damaging_cls` ON (ores_damaging_cls.oresc_model = 59 AND (ores_damaging_cls.oresc_rev=rc_this_oldid) AND ores_damaging_cls.oresc_class = 1) LEFT JOIN `ores_classification` `ores_goodfaith_cls` ON (ores_goodfaith_cls.oresc_model = 60 AND (ores_goodfaith_cls.oresc_rev=rc_this_oldid) AND ores_goodfaith_cls.oresc_class = 1) WHERE (actor_user IS NULL OR (NOT ( (user_editcount >= 500) AND ((user_registration IS NULL) OR (user_registration <= '20210816052016')) ))) AND (actor_name<>'Tgr (WMF)') AND ((rc_this_oldid = page_latest) OR rc_type = 3) AND (rc_type != 3) AND (rc_source != 'wb') AND ((ores_damaging_cls.oresc_probability BETWEEN 0.944 AND 1)) AND (rc_type NOT IN (3, 5)) AND ((ores_goodfaith_cls.oresc_probability BETWEEN 0 AND 0.353)) AND (rc_type NOT IN (3, 5)) AND (rc_timestamp >= '20210816052016') AND rc_new IN (0, 1) ORDER BY rc_timestamp DESC LIMIT 1000 /* f1fb32849e5be6a218f195e9644c63bb db1099:3311 enwiki 67s */

+------+--------------------+---------------------+--------+-----------------------------------------------------------+-----------------------+---------+-----------------------------------------------------------------------+---------+-------------+
| id   | select_type        | table               | type   | possible_keys                                             | key                   | key_len | ref                                                                   | rows    | Extra       |
+------+--------------------+---------------------+--------+-----------------------------------------------------------+-----------------------+---------+-----------------------------------------------------------------------+---------+-------------+
|    1 | PRIMARY            | recentchanges       | range  | rc_timestamp,rc_actor,rc_this_oldid,rc_new_name_timestamp | rc_timestamp          | 14      | NULL                                                                  | 4266373 | Using where |
|    1 | PRIMARY            | recentchanges_actor | eq_ref | PRIMARY,actor_name,actor_user                             | PRIMARY               | 8       | enwiki.recentchanges.rc_actor                                         | 1       | Using where |
|    1 | PRIMARY            | comment_rc_comment  | eq_ref | PRIMARY                                                   | PRIMARY               | 8       | enwiki.recentchanges.rc_comment_id                                    | 1       |             |
|    1 | PRIMARY            | user                | eq_ref | PRIMARY                                                   | PRIMARY               | 4       | enwiki.recentchanges_actor.actor_user                                 | 1       | Using where |
|    1 | PRIMARY            | watchlist           | eq_ref | wl_user,wl_user_notificationtimestamp,wl_namespace_title  | wl_user               | 265     | const,enwiki.recentchanges.rc_namespace,enwiki.recentchanges.rc_title | 1       |             |
|    1 | PRIMARY            | watchlist_expiry    | eq_ref | PRIMARY                                                   | PRIMARY               | 4       | enwiki.watchlist.wl_id                                                | 1       | Using where |
|    1 | PRIMARY            | page                | eq_ref | PRIMARY                                                   | PRIMARY               | 4       | enwiki.recentchanges.rc_cur_id                                        | 1       | Using where |
|    1 | PRIMARY            | flaggedpages        | eq_ref | PRIMARY                                                   | PRIMARY               | 4       | enwiki.recentchanges.rc_cur_id                                        | 1       |             |
|    1 | PRIMARY            | ores_damaging_cls   | eq_ref | oresc_rev_model_class                                     | oresc_rev_model_class | 7       | enwiki.recentchanges.rc_this_oldid,const,const                        | 1       | Using where |
|    1 | PRIMARY            | ores_goodfaith_cls  | eq_ref | oresc_rev_model_class                                     | oresc_rev_model_class | 7       | enwiki.recentchanges.rc_this_oldid,const,const                        | 1       | Using where |
|    2 | DEPENDENT SUBQUERY | change_tag          | ref    | ct_rc_tag_id,ct_tag_id_id                                 | ct_rc_tag_id          | 5       | enwiki.recentchanges.rc_id                                            | 1       | Using index |
|    2 | DEPENDENT SUBQUERY | change_tag_def      | eq_ref | PRIMARY                                                   | PRIMARY               | 4       | enwiki.change_tag.ct_tag_id                                           | 1       |             |
+------+--------------------+---------------------+--------+-----------------------------------------------------------+-----------------------+---------+-----------------------------------------------------------------------+---------+-------------+