Untitled query #69908

SQL

select a.actor_id, a.actor_name, p.page_id, p.page_title, count(*)
from actor a
join revision r on actor_id=rev_actor
join page p on rev_page=page_id
join (select distinct(rev_actor)
from categorylinks
join revision on cl_from=rev_page
      where cl_to like '1973_establishments_in_Manitoba' and cl_type like 'page') t1 on t1.rev_actor=r.rev_actor
where rev_minor_edit=0 and page_namespace=0 and page_is_redirect=0
group by a.actor_id, p.page_id
having count(*) > 100
order by a.actor_id, p.page_id, count(*) desc
SQL

Checking query status...
