Fork of Admins by edit count by Hey man im josh
This query is marked as a draft This query has been published by 0xDeadbeef.

SQL

AخA
 
SELECT user_name FROM user
join actor
on actor_user = user_id
join recentchanges_userindex
on recentchanges_userindex.rc_actor = actor_id
left join block_target
on block_target.bt_user = user.user_id
left join block
on block.bl_target = block_target.bt_id
where
 user_editcount >= 500
 AND user_registration <= DATE_SUB(NOW(), INTERVAL 90 DAY)
 AND not (bl_sitewide is not null and bl_sitewide=1 and bl_expiry is not null and bl_expiry='infinity')
 and rc_timestamp > DATE_SUB(NOW(), INTERVAL 30 DAY)
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.

Checking query status...