Recently active mw crats

SQL

# USE mediawikiwiki_p;

SELECT
	a.actor_name,
    e.edits,
    e.last_edit,
    l.logs,
    l.last_log
FROM actor_user 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 > 0 OR l.logs > 0) /**/
ORDER BY (e.edits + l.logs) DESC
SQL

Checking query status...
