SELECT /* SpecialRecentChanges::doMainQuery */ 
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, 
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`, 
actor_rc_user.actor_user             AS `rc_user`, 
actor_rc_user.actor_name             AS `rc_user_text`, 
rc_actor, 
wl_user, 
wl_notificationtimestamp, 
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`, 
ores_damaging_cls.oresc_probability  AS `ores_damaging_score`, 
ores_goodfaith_cls.oresc_probability AS `ores_goodfaith_score` 
FROM   `recentchanges` 
       JOIN `comment` `comment_rc_comment` 
         ON (( comment_rc_comment.comment_id = rc_comment_id )) 
       JOIN `actor` `actor_rc_user` 
         ON (( actor_rc_user.actor_id = rc_actor )) 
       LEFT JOIN `watchlist` 
              ON ( wl_user = 28859 
                   AND ( wl_title = rc_title ) 
                   AND ( wl_namespace = rc_namespace ) ) 
       LEFT JOIN `page` 
              ON (( rc_cur_id = page_id )) 
       LEFT JOIN `ores_classification` `ores_damaging_cls` 
              ON ( ores_damaging_cls.oresc_model = 11 
                   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 = 12 
                   AND ( ores_goodfaith_cls.oresc_rev = rc_this_oldid ) 
                   AND ores_goodfaith_cls.oresc_class = 1 ) 
WHERE  rc_bot = 0 
       AND ( ( rc_this_oldid = page_latest ) 
              OR rc_type IN ( 3, 142 ) ) 
       AND ( rc_type != 6 ) 
       AND rc_patrolled = 0 
       AND ( rc_namespace IN ( '12', '120', '146', '640', '828' ) ) 
       AND ( rc_timestamp >= '20191216180112' ) 
       AND ( rc_source != 'wb' ) 
       AND rc_new IN ( 0, 1 ) 
ORDER  BY rc_timestamp DESC 
LIMIT  500;