Untitled query #48285

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

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...