*MEH* - Quarry

SQL

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

;

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

Checking query status...
