Replicas browser and optimizer
This query is marked as a draft
This query has been published
use hewiki_p; select user_id, user_name, count(*) as editCount, if(ipb_user,1, 0) as blocked from user left join revision_userindex on rev_user=user_id left join ipblocks on user_id=ipb_user where user_name rlike '(.)\\1\\1\\1\\1\\1\\1\\1\\1' group by user_id order by count(*) desc;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in