Untitled query #73657

SQL

/*
limit 10
*/

select  actor_name, count(rev_actor)  from revision 
JOIN actor ON actor_id = rev_actor
#where rev_timestamp > DATE_SUB(NOW(), INTERVAL 3 MONTH)
where rev_timestamp > DATE_SUB(NOW(), INTERVAL 2 DAY)
AND actor_name NOT IN (SELECT user_name FROM user_groups JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
and rev_page in (

  select page.page_id from page where page.page_namespace in (0)
    and page.page_title in (
         select p0.page_title from categorylinks
         inner join page p0 on p0.page_id = categorylinks.cl_from
         where categorylinks.cl_to like "مقالات_مشروع_ويكي_العراق" and categorylinks.cl_type = "page" and p0.page_namespace in (1) 
    ) 
)
GROUP BY rev_actor
ORDER BY COUNT(rev_actor) DESC
HAVING count(rev_actor) > 30
SQL

Checking query status...
