Untitled query #67365

SQL

select p.page_id, p.page_title, p.page_namespace, 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=r.rev_actor and r.rev_page=p.page_id and r.rev_minor_edit=0
	/*and p.page_id in (63465223, 5137507, 62750956)*/ #and p.page_namespace in (0, 4)
group by p.page_id
having a.actor_id = t1.actor_id and count(distinct(a.actor_id)) > 30 and page_id in (63465223, 5137507, 62750956)
order by count(distinct(a.actor_id)) desc
SQL

Checking query status...
