zhwiki active ec users

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

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)

SQL

Checking query status...