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.