Editcount of admins since becoming admins

SQL

WITH admin_time AS (SELECT log_timestamp, log_title from logging #NOTE: Timestamp may not be last time adminship granted
                    INNER JOIN actor ON logging.log_actor =actor.actor_id
                    INNER JOIN user ON user.user_name = logging.log_title
                    INNER JOIN user_groups ON user_groups.ug_user = user.user_id
  					WHERE logging.log_type="rights" AND logging.log_action="rights"
  					AND logging.log_params REGEXP 'newgroups".*"sysop"'
                    AND user_groups.ug_group = "sysop"
                    GROUP BY log_title
)
SELECT
  adt.log_title
FROM
  admin_time adt

SQL

Checking query status...