Sandbox2 - Quarry

SQL

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
SQL

Checking query status...
