Untitled query #69873

SQL

select t3.actor_id, p2.page_id, count(*)
from page p2
join revision r2 on r2.rev_page=p2.page_id
join (select t2.actor_id, max(t2.last_edit) last_edit_overall
from (select p.page_id, a.actor_id, max(r.rev_timestamp) last_edit
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
group by p.page_id, a.actor_id
      order by p.page_id, a.actor_id) t2
      group by t2.actor_id) t3 on t3.actor_id=r2.rev_actor
where p2.page_is_redirect=0 and r2.rev_minor_edit=0 and p2.page_namespace=0 and r2.rev_timestamp<t3.last_edit_overall
group by t3.actor_id, p2.page_id
order by t3.actor_id, p2.page_id, count(*) desc
SQL

Checking query status...
