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

SQL

AخA
 
select t3.actor_id, p2.page_id, count(*)
from page p2
join revision r2 on r2.rev_page=p2.page_id
join (select t2.actor_id, max(t2.last_edit) last_edit_overall
from (select p.page_id, a.actor_id, max(r.rev_timestamp) last_edit
from actor a
join revision r on a.actor_id=r.rev_actor
join page p on r.rev_page=p.page_id
join (select cl_from
    from categorylinks
    where cl_to like '1973_establishments_in_Manitoba' and cl_type like 'page') t1 on p.page_id=t1.cl_from
where p.page_is_redirect=0 and r.rev_minor_edit=0 and p.page_namespace=0
group by p.page_id, a.actor_id
      order by p.page_id, a.actor_id) t2
      group by t2.actor_id) t3 on t3.actor_id=r2.rev_actor
where p2.page_is_redirect=0 and r2.rev_minor_edit=0 and p2.page_namespace=0 and r2.rev_timestamp<t3.last_edit_overall
group by t3.actor_id, p2.page_id
order by t3.actor_id, p2.page_id, count(*) desc
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...