Untitled query #69867

SQL

select a2.actor_id, a2.actor_user, a2.actor_name, p2.page_title, p2.page_id, count(*)
from actor a2
join revision r2 on a2.actor_id=r2.rev_actor
join page p2 on r2.rev_page=p2.page_id
join (
  a.actor_id, min(r.rev_timestamp) joined
  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 'Microwave_technology' 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 on t2.actor_id=r2.rev_actor
where r2.rev_minor_edit=0 and p2.page_namespace=0 and p2.page_is_redirect=0 and r2.rev_timestamp < t2.joined
group by a2.actor_id, p2.page_id
having count(*) >= 5
order by a2.actor_id, count(*) desc
SQL

Checking query status...
