select p.page_id, p.page_title, count(distinct(a.actor_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

where a.actor_id = t1.actor_id and a.actor_id=r.rev_actor and r.rev_page=p.page_id and r.rev_minor_edit=0

group by p.page_id

order by count(distinct(a.actor_id)) desc