Most active users on WP:KSA talk pages in 2020

Fork of Most active users on WP:KSA talk pages in 2020 by FShbib

This query is marked as a draft This query has been published by FShbib.

SQL

USE arwiki_p;
select actor_name as "المستخدم", count(rev_actor) as "عدد التعديلات"
from revision 
JOIN actor ON actor_id = rev_actor
where rev_timestamp between 20190101000000 AND 20191231235959
and rev_page IN (
    SELECT tl_from
    FROM templatelinks
    WHERE
      tl_from_namespace = 1
      AND tl_namespace = 10
      AND tl_title IN (
        "مشروع_ويكي_السعودية"
      )
)
    AND actor_name NOT IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
group by rev_actor
ORDER BY count(rev_actor) desc
limit 25;

SQL

Checking query status...