*MEH* - Quarry

SQL

select 
  ar.actor_id, 
  ar.actor_name, 
  u.user_editcount, 
  -- 利用者グループ
  -- group_concat( distinct ug.ug_group separator '<br />') groups,
  ug.ug_group,
  min(rui.rev_timestamp) as first_edit,
  max(rui.rev_timestamp) as last_edit
from 
  `user` u, 
  `user_groups` ug,
  `revision_userindex` rui,
  `actor_revision` ar
where 
   1 = 1
-- フラグ付きbotでない
-- and ug.ug_group <> "bot"
and rui.rev_actor = ar.actor_id
and ar.actor_user = ug.ug_user
and ar.actor_user = u.user_id
group by ar.actor_id
order by u.user_editcount desc
limit 100

;

-- select distinct ug.ug_group
-- from `user_groups` ug;
SQL

Checking query status...
