Hewiki pages counter

SQL

use hewiki_p;
select rev_user_text, count(*) from revision r0 join page
on rev_page = page_id
where rev_parent_id = 0
#and rev_user_text in ("בורה בורה", "IKhitron", "דוד שי", "Gilgamesh", "ערן")
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 exists
(select * from revision r1
 where r1.rev_user_text = r0.rev_user_text
 and rev_timestamp like "2016%")
and not exists
(select * from user_groups
 where ug_user = rev_user
 and ug_group = "bot")
group by rev_user_text
order by count(*) desc
limit 200
SQL

Checking query status...
