select t1.page_id, t1.page_title, count(*) No_active_editors

from (

  select t2.actor_id, t2.actor_user, t2.actor_name, p.page_id, p.page_title, count(*) No_revs

  from revision r, page p, (

     select actor_id, actor_user, actor_name, count(distinct(page_id))

     from revision, page, actor

     where page_id in (863, 6886, 49001) and actor_id=rev_actor and rev_page=page_id and rev_minor_edit=0

     group by actor_name

     having count(distinct(page_id))>=2 ) t2

  where p.page_id in (863, 6886, 49001) and t2.actor_id=r.rev_actor and r.rev_page=p.page_id and rev_minor_edit=0

  group by actor_name, page_id

  having No_revs>=5

  ) t1

group by page_id

limit 100