Recently active mw crats

SQL

use mediawikiwiki_p;
SELECT
	COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp) AS 'last edit',
    actor.actor_name
FROM actor
	JOIN recentchanges_userindex AS rc ON actor_id = rc_actor
WHERE actor_user IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bureaucrat' )
GROUP BY actor_name
ORDER BY COUNT(*) DESC;

use mediawikiwiki_p;
SELECT
	a.actor_name,
    e.*,
    l.*
FROM actor
	JOIN (
      SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp) AS 'last edit', rc_actor
      FROM recentchanges_userindex rc
      WHERE rc_type = 0
      GROUP BY rc_actor
    ) AS e ON e.rc_actor = a.actor_id
WHERE actor_user IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bureaucrat' )
GROUP BY actor_name
ORDER BY COUNT(*) DESC;
SQL

Checking query status...
