Most active users on WP:KSA talk pages in 2020

SQL

USE arwiki_p;
select actor_name, count(rev_actor)
from revision 
JOIN actor ON actor_id = rev_actor
where rev_timestamp between 20200101000000 AND 20201231235959
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 100;

SQL

Checking query status...