This query is marked as a draft This query has been published by لوقا.

SQL

x
 
/*
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...