Untitled query #66093

SQL

select t1.actor_id, t1.actor_user, t1.actor_name, t1.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
where t1.actor_id = r.rev_actor and t1.page_id = r.rev_page and rev_minor_edit=0
order by actor_id
limit 100
SQL

Checking query status...
