zhwiki active ec users

SQL

SELECT distinct actor_name FROM actor_recentchanges
join user
on user_id = actor_user
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 90 DAY)

AخA
 
SELECT distinct actor_name FROM actor_recentchangesjoin useron user_id = actor_userjoin recentchanges_userindexon recentchanges_userindex.rc_actor = actor_idleft join block_targeton block_target.bt_user = user.user_idleft join blockon block.bl_target = block_target.bt_idwhere 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 90 DAY)

SQL

Checking query status...