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.