Untitled query #60727

SQL

-- actor_id = 2012535
-- user_id = 966838
select
  rev_actor,
  actor_name,
  user_editcount,
  count(distinct rev_page) as cnt,
  count(distinct rev_page) * 100 / user_editcount as pct
from revision_userindex
join page
  on rev_page = page_id
  and page_namespace = 0
  and page_is_redirect = 0
join actor
  on rev_actor = actor_id
  and actor_user <> 0
join user
  on actor_user = user_id
where
  rev_page in (
    select rev_page
    from revision_userindex
    join page
      on rev_page = page_id
      and page_namespace = 0
      and page_is_redirect = 0
    where rev_actor = 2012535
  )
  and actor_user not in (
    select ug_user
    from user_groups
    where ug_group = 'bot'
  )
group by
  rev_actor,
  actor_name,
  user_editcount
having cnt > 5
order by cnt desc
SQL

Checking query status...
