Untitled query #69808

SQL

select t2.page_id, t2.page_title, t2.actor_id, t2.actor_name, r_out.rev_page, count(r_out.rev_id)
from revision r_out 
join (select p.page_id, p.page_title, a.actor_id, a.actor_name, 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
group by p.page_id, a.actor_id
order by p.page_id, a.actor_id) t2 on t2.actor_id=r_out.rev_actor
join page p_out on r_out.rev_page=p_out.page_id
where p_out.page_namespace=0 and p_out.page_is_redirect=0 and r_out.rev_minor_edit=0 and r_out.rev_timestamp<t2.joined
group by t2.page_id, t2.actor_id, r_out.rev_page
order by t2.page_id, t2.actor_id, r_out.rev_page
SQL

Checking query status...
