Active users list at commons

SQL

Use commonswiki_p;
select  user_name, user_editcount, CAST(max(revactor_timestamp) AS DATETIME) '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) t left join actor on actor_name = t.user_name left join revision_actor_temp on revactor_actor = actor_id group by 1,2,4,5 order by user_editcount desc;
SQL

Checking query status...
