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

​