SQL
AخA
SELECT DISTINCT
u.user_name,
u.user_editcount
FROM
revision_userindex rev
INNER JOIN actor a
ON rev.rev_actor = a.actor_id
INNER JOIN user u
ON a.actor_user = u.user_id
WHERE
rev.rev_timestamp >= (DATE_FORMAT(DATE_ADD(SYSDATE(), INTERVAL -5 DAY), '%Y%m%d')) * 1000000
AND u.user_editcount >= 500
AND NOT EXISTS
(SELECT 1 FROM user_groups ug
WHERE ug.ug_user = u.user_id
AND ug.ug_group IN ('autopatrolled', 'autoreviewer', 'bot', 'sysop') )
ORDER BY user_editcount desc
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.