With adt AS (

  SELECT

    min(log_timestamp) as time_of_first_adminship,

    log_title

  from

    logging

    INNER JOIN actor ON actor_name = log_title

  WHERE

    logging.log_type = "rights"

    AND logging.log_action = "rights"

    /* AND log_timestamp > 20180000000000 */

    AND logging.log_params REGEXP 'newgroups".*"sysop"'

    and logging.log_title = "28bytes" #this line gets removed in iterating version

)

SELECT

  COUNT(*)

FROM

  revision

  JOIN actor ON rev_actor = actor_id

  JOIN user ON actor_user = user_id

  JOIN adt ON log_title = actor_name

WHERE

  user_name = '28bytes'  #this line gets removed in iterating version

  AND rev_timestamp > time_of_first_adminship