Untitled query #69872

SQL

select p.page_id, 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

AخA
 
select p.page_id, a.actor_id, min(r.rev_timestamp) joinedfrom actor ajoin revision r on a.actor_id=r.rev_actorjoin page p on r.rev_page=p.page_idjoin (select cl_from    from categorylinks    where cl_to like 'Microwave_technology' and cl_type like 'page') t1 on p.page_id=t1.cl_fromwhere p.page_is_redirect=0 and r.rev_minor_edit=0 and p.page_namespace=0group by p.page_id, a.actor_idorder by p.page_id, a.actor_id

SQL

Checking query status...