Hewiki pages counter

SQL

use hewiki_p;
select rev_user_text, count(*) from revision 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
where exists
(select * from user_groups
 where ug_user = rev_user
 and ug_group = "bot")
group by rev_user_text
order by count(*) desc
limit 100;
select * from user_groups
where ug_group = "bot" limit 10
SQL

Checking query status...
