Untitled query #48287

SQL

use fawiki_p;
select
  actor_name,
  count(*) as cnt
from actor_revision
join revision_userindex
  on rev_actor = actor_id
  and rev_timestamp > '20200315221100' -- six months before start date
  and rev_timestamp < '20200915221100' -- start date
join page
  on rev_page = page_id
  and page_namespace = 0
where
  actor_id in (
    select rev_actor
    from revision_userindex
    where rev_page = 5381554 -- ویکی‌پدیا:درخواست برای دسترسی/ویکی‌بان/Luckie Luke
group by actor_name
order by cnt
SQL

Checking query status...
