Untitled query #67367

SQL

select p.page_id, p.page_title, p.page_namespace, a.actor_id, a.actor_name, count(distinct(p.page_id))
from page p, revision r, actor a, (
  	select actor_id
	from actor, page, revision
	where page_id=63465223 and actor_id=rev_actor and rev_page=page_id and rev_minor_edit=0
	group by actor_id
	) t1,
    (
      select actor_id
		from actor, page, revision
		where page_id=62750956 and actor_id=rev_actor and rev_page=page_id and rev_minor_edit=0
		group by actor_id
    ) t2
where t1.actor_id = t2.actor_id and t1.actor_id = a.actor_id and a.actor_id=r.rev_actor and r.rev_page=p.page_id and r.rev_minor_edit=0
group by a.actor_id
SQL

Checking query status...
