10 000 editors

Users excluding anonims, usernames ended with "Bot[digit]" and whose username was not deleted, having at least 100 edits in articles from 10000 necessary list got from User:SergoBot/Stat10000/* statistics pages.

SQL

use ukwiki_p;

select convert (r.rev_user_text using utf8), count(*)
from page p
join pagelinks pl on p.page_id = pl.pl_from
left join page pp on pl.pl_title = pp.page_title and pp.page_namespace = 0
left join revision r on r.rev_page = pp.page_id
where convert (p.page_title USING utf8) like 'SergoBot/Stat10000/%'
and p.page_namespace = 2 and pl.pl_namespace = 0
and r.rev_user_text is not null
and convert (r.rev_user_text using utf8) not rlike 'Bot[0-9]?$|[0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}'
group by r.rev_user_text
having count(*) >= 100
order by 2 desc

SQL

Checking query status...