Untitled query #68930

SQL

select a.actor_id, a.actor_user, a.actor_name, p.page_title, p.page_id, count(*)
from actor a
join revision r on a.actor_id=r.rev_actor
join page p on r.rev_page=p.page_id
inner join (
  select actor_id, count(*)
from actor, page, revision
where page_id=22418955 and actor_id=rev_actor and rev_page=page_id and rev_minor_edit=0 and rev_timestamp < 20061125000000  group by actor_id) t1
on t1.actor_id = a.actor_id
where rev_minor_edit=0 and page_namespace = 0 and rev_timestamp < 20060924225006 group by a.actor_id, page_id
having count(*) >= 5
order by a.actor_id, count(*) desc
SQL

Checking query status...
