Untitled query #73657

SQL

/*
limit 10
*/

select 
rev_actor,
count(rev_actor) 
from revision 
#where rev_timestamp > DATE_SUB(NOW(), INTERVAL 3 MONTH)
where rev_timestamp > DATE_SUB(NOW(), INTERVAL 2 DAY)
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
limit 10
SQL

Checking query status...
