Untitled query #66093

SQL

select t1.actor_id, t1.actor_user, t1.actor_name, p.page_title, r.rev_page, r.rev_id, r.rev_timestamp
from (
  select actor_id, actor_user, actor_name, page_id, page_title, 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
      #and actor_user IS NOT NULL
  group by actor_name
  having count(distinct(page_id))>=2
  ) t1, revision r, page p
where t1.actor_id=r.rev_actor and r.rev_page in (863, 6886, 49001) and r.rev_page=p.page_id and rev_minor_edit=0 
	#and t1.actor_user=9719271
order by actor_id, rev_timestamp
limit 1000
SQL

Checking query status...
