Sandbox2 - Quarry

SQL

With adt AS (
  SELECT
    log_timestamp,
    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 = "Novem Linguae"
)
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 = 'Novem Linguae'
  AND rev_timestamp > log_timestamp
SQL

Checking query status...
