Editcount of admins since becoming admins

SQL

WITH adt as (
  SELECT
    log_timestamp,log_title
  from
    logging
  WHERE
    logging.log_type = "rights"
    AND logging.log_action = "rights"
    /* AND log_timestamp > 20180000000000 */
    AND logging.log_params REGEXP 'newgroups".*"sysop"'
  GROUP BY
    log_title
),
adt_with_revs as (
  SELECT
    rev_timestamp,
    log_timestamp,
    log_title
  from
    adt
    INNER JOIN actor ON actor_name = log_title
    INNER JOIN revision_userindex ON rev_actor = actor_id
)
SELECT log_title, COUNT(rev_timestamp) OVER(PARTITION BY log_title WHERE rev_timestamp > log_timestamp) AS edit_count
FROM adt_with_revs;

SQL

Checking query status...