بوت المساهمون في المشروع ويكي

SQL

/*
select page.page_title from  categorylinks 
inner join page on page.page_id = categorylinks.cl_from
where cl_to like "مقالات_مشروع_ويكي_العراق"
and cl_type like "page"
and page.page_namespace in (1)
limit 10
*/


/*
select actor.actor_id from pagelinks
 join actor on actor.actor_name = REPLACE(pagelinks.pl_title, "_", " ")
where pl_from in (7436093)
and pl_from_namespace in (4)
and pl_namespace in (2);
*/



select count(rev_id) as "count_number",rev_actor from revision
where rev_actor in (
  select actor.actor_id from pagelinks
  join actor on actor.actor_name = REPLACE(pagelinks.pl_title, "_", " ")
  where pl_from in (7436093)
  and pl_from_namespace in (4)
  and pl_namespace in (2)
)
and rev_timestamp >= NOW() - INTERVAL 3 MONTH
and rev_page in (
  select page.page_id from page 
  where page_title in (
  	select page.page_title from  categorylinks 
    inner join page on page.page_id = categorylinks.cl_from
    where cl_to like "مقالات_مشروع_ويكي_العراق"
    and cl_type like "page"
    and page.page_namespace in (1)
  ) and page.page_namespace in (0)
)
HAVING count_number >= 30 
GROUP BY  rev_actor
SQL

Checking query status...
