Most active users on WP:KSA talk pages

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, count(rev_actor)
from revision 
JOIN actor ON actor_id = rev_actor
where rev_timestamp between 20200101000000 AND 20201231235959
and rev_page AND page_id IN (
    SELECT tl_from
    FROM templatelinks
    WHERE
      tl_from_namespace = 1
      AND tl_namespace = 10
      AND tl_title IN (
        "مشروع_ويكي_سينما"
      )

#in (select cl_from from categorylinks where cl_from = rev_page and cl_to = "مقالات_مشروع_ويكي_مأكولات_ومشروبات") 
    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...