Page MenuHomePhabricator
Paste P10177

(An Untitled Masterwork)
ActivePublic

Authored by Addshore on Jan 16 2020, 12:55 PM.
Tags
None
Referenced Files
F31514312: raw.txt
Jan 16 2020, 12:55 PM
Subscribers
None
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;