use hewiki_p;

select rev_user_text, count(*) from revision_userindex r0 join page

on rev_page = page_id

where rev_parent_id = 0

and page_namespace in (0, 4, 6, 8, 10, 12, 14, 100, 446, 828)

and page_is_redirect = 0

and not rev_user_text in ("Costello-bot", "Rotemliss-bot", "Yonidebot")

and not exists

(select * from user_groups

 where ug_user = rev_user

 and ug_group = "bot")

and (select count(*) from revision_userindex r1

 where r1.rev_user_text = r0.rev_user_text

 and (rev_timestamp like "201604%" or

      rev_timestamp like "201605%" or

      rev_timestamp like "201606%" or

      rev_timestamp like "201607%")) > 99

group by rev_user_text

order by count(*) desc

limit 100

​