stats on active users on commons (like fae/userlist)

SQL

use commonswiki_p;
select
  user_name,
  user_editcount,(
    SELECT
      MAX(rc_timestamp)
    from
      recentchanges_userindex
      inner join actor_recentchanges on rc_actor = actor_id
    WHERE
      actor_name = user_name
      and rc_type < 5
  ) 'last edit',
  groups,
  reg
from
  (
    select
      user_name,
      user_editcount,
      GROUP_CONCAT(ug1.ug_group SEPARATOR ", ") "groups",
      substr(user_registration, 1, 4) "reg"
    from
      user
      left join user_groups ug1 on ug1.ug_user = user_id
      left join user_groups ug2 on ug2.ug_user = user_id
      and ug2.ug_group = 'bot'
    where
      user_editcount >= 10000
      and ug2.ug_user is null
    group by
      1,
      2,
      4
    order by
      null
    limit
      3000
  ) t
WHERE
  EXISTS(
    select
      1
    from
      actor_recentchanges
    where
      user_name = actor_name
  )
order by
  user_editcount desc;
SQL

Checking query status...
