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' )
AND rc_type = 0
GROUP BY actor_name
ORDER BY COUNT(*) DESC;

use mediawikiwiki_p;
SELECT
	a.actor_name,
    e.edits,
    e.last_edit,
    l.logs,
    l.last_log
FROM actor a
	LEFT JOIN (
      SELECT COUNT(rc_id) AS 'edits', MAX(rc.rc_timestamp) AS 'last_edit', rc_actor AS 'editor'
      FROM recentchanges_userindex rc
      WHERE rc_type = 0
      GROUP BY rc_actor
    ) AS e ON e.editor = a.actor_id
	LEFT JOIN (
      SELECT COUNT(rc_id) AS 'logs', MAX(rc.rc_timestamp) AS 'last_log', rc_actor AS 'logger'
      FROM recentchanges_userindex rc
      WHERE rc_type = 3
      GROUP BY rc_actor
    ) AS l ON l.logger = a.actor_id
WHERE actor_user IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bureaucrat' )
AND (e.edits NOT NULL OR l.logs NOT NULL)
SQL

Checking query status...
