Editcount of admins since becoming admins

SQL

WITH admin_time AS (
  SELECT
    l.log_timestamp,
    l.log_title
  from
    logging_userindex l
    INNER JOIN actor ON l.log_actor = actor.actor_id
  WHERE
    l.log_type = "rights"
    AND l.log_action = "rights"
    /* AND log_timestamp > 20180000000000 */
    AND l.log_params REGEXP 'newgroups".*"sysop"'
)
SELECT
  adt.log_title,
  COUNT (*) OVER (PARTITION BY r.rev_actor)
FROM
  revision r
  INNER JOIN actor_revision a ON r.rev_actor = a.actor_id
  INNER JOIN admin_time adt ON adt.log_title = a.actor_name
WHERE
  r.rev_timestamp > adt.log_timestamp

SQL

Checking query status...