Fork of
revert classifer sample
by Xiplus
This query is marked as a draft
This query has been published
by Xiplus.
SQL
x
SELECT rc_this_oldid, user_name, rc_new_len - rc_old_len, user_registration, user_editcount
FROM recentchanges
LEFT JOIN actor ON rc_actor = actor_id
LEFT JOIN user ON actor_user = user_id
WHERE
rc_timestamp < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 2 DAY), "%Y%m%d%H%I%S") AND
rc_type = 0 AND
rc_bot = 0 AND
rc_namespace = 0 AND
rc_new_len - rc_old_len < 200 AND
rc_new_len - rc_old_len > -200 AND
actor_user IS NOT NULL AND
user_editcount > 2000 AND
user_registration < 20210101000000
ORDER BY RAND()
LIMIT 1000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.