Untitled query #69889

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' and rev_actor<300) t1 on t1.rev_actor=r.rev_actor
where r.rev_minor_edit=0 and p.page_namespace=0 and p.page_is_redirect=0 and r.rev_timestamp<20070101000000
group by a.actor_id, p.page_id
having count(*) < 10
order by a.actor_id, p.page_id, count(*) desc
#limit 10000

AخA
 
select a.actor_id, a.actor_name, p.page_id, p.page_title, count(*)from actor ajoin revision r on actor_id=rev_actorjoin page p on rev_page=page_idjoin (select distinct(rev_actor)from categorylinksjoin revision on cl_from=rev_page      where cl_to like '1973_establishments_in_Manitoba' and cl_type like 'page' and rev_actor<300) t1 on t1.rev_actor=r.rev_actorwhere r.rev_minor_edit=0 and p.page_namespace=0 and p.page_is_redirect=0 and r.rev_timestamp<20070101000000group by a.actor_id, p.page_idhaving count(*) < 10order by a.actor_id, p.page_id, count(*) desc#limit 10000

SQL

Checking query status...