Untitled query #47134

SQL

USE enwiki_p;
SELECT actor_name, user_editcount, user_registration, (user_editcount > 500 AND user_registration < 20200627000000) as `30/500`, COUNT(*) as `RedWarn edits`, COUNT(*)/user_editcount*100 as `RedWarn %`
FROM revision_userindex
JOIN change_tag ON ct_rev_id = rev_id
JOIN actor_revision ON rev_actor = actor_id
JOIN `user` ON actor_user = user_id
INNER JOIN user_groups ON (ug_user = actor_id)
LEFT JOIN ipblocks ON user_id = ipb_user
WHERE ct_tag_id = 577 -- RedWarn
AND user_groups.ug_group = 'rollbacker'
GROUP BY actor_name
ORDER BY COUNT(*) DESC
LIMIT 10
SQL

Checking query status...
