Hewiki pages counter

SQL

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
SQL

Checking query status...
