Untitled query #68929

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=31653 and actor_id=rev_actor and rev_page=page_id and rev_minor_edit=0 and rev_timestamp < 20090407000000
  group by actor_id) t1
on t1.actor_id = a.actor_id
where rev_minor_edit=0 and page_namespace = 0 and rev_timestamp < 20010206182027
group by a.actor_id, page_id
having count(*) >= 5
order by a.actor_id, count(*) desc

AخA
 
select a.actor_id, a.actor_user, a.actor_name, p.page_title, p.page_id, count(*)from actor ajoin revision r on a.actor_id=r.rev_actorjoin page p on r.rev_page=p.page_idinner join (  select actor_id, count(*)from actor, page, revisionwhere page_id=31653 and actor_id=rev_actor and rev_page=page_id and rev_minor_edit=0 and rev_timestamp < 20090407000000  group by actor_id) t1on t1.actor_id = a.actor_idwhere rev_minor_edit=0 and page_namespace = 0 and rev_timestamp < 20010206182027group by a.actor_id, page_idhaving count(*) >= 5order by a.actor_id, count(*) desc

SQL

Checking query status...