RedWarn edits - Quarry

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 %`, ipb_sitewide
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
LEFT JOIN ipblocks ON user_id = ipb_user
WHERE ct_tag_id = 577 -- RedWarn
GROUP BY actor_name
ORDER BY user_registration DESC

AخA
 
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 %`, ipb_sitewideFROM revision_userindexJOIN change_tag ON ct_rev_id = rev_idJOIN actor_revision ON rev_actor = actor_idJOIN `user` ON actor_user = user_idLEFT JOIN ipblocks ON user_id = ipb_userWHERE ct_tag_id = 577 -- RedWarnGROUP BY actor_nameORDER BY user_registration DESC

SQL

Checking query status...