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