Replicas browser and optimizer
This query is marked as a draft
This query has been published
USE mediawikiwiki_p; SET @rank=0; select @rank:=@rank+1 as Rank, concat('# [[User:', user_name, ']]') as Name, user_editcount from user where user_id not in (select ug_user from user_groups join user_former_groups on ug_user = ufg_user where ug_group = 'bot' or ufg_group = 'bot') order by user_editcount desc limit 200;
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