Untitled query #66103

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, 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=7131173 or t1.actor_user=9719271)
order by actor_id, rev_timestamp

# 5837 rows
SQL

Checking query status...
