Untitled query #66134

SQL

select t1.page_id, t1.page_title, count(distinct(t1.actor_id)) 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_id
     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_id, page_id
  having No_revs>=5
  ) t1
group by page_id
SQL

Checking query status...
