Untitled query #69874

SQL

select p.page_id, p.page_title, a.actor_id, a.actor_name, r.rev_id, r.rev_timestamp
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 'Oracle_Cloud_Services' 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
order by p.page_id, r.rev_timestamp

AخA
 
select p.page_id, p.page_title, a.actor_id, a.actor_name, r.rev_id, r.rev_timestampfrom actor ajoin revision r on a.actor_id=r.rev_actorjoin page p on r.rev_page=p.page_idjoin (select cl_fromfrom categorylinks where cl_to like 'Oracle_Cloud_Services' 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=0order by p.page_id, r.rev_timestamp

SQL

Checking query status...