Edit counts of admins at time of successful RFA

Fork of Edit counts of admins at time of successful RFA by Novem Linguae

This query is marked as a draft This query has been published by Ixtal.

SQL

SELECT log_timestamp,
log_title,
(
  SELECT COUNT(*)
  FROM revision
  JOIN actor ON rev_actor = actor_id
  #JOIN archive_userindex ON ar_actor = actor_id
  JOIN user ON actor_user = user_id
  WHERE user_name = REPLACE(log_title, '_', ' ')
  AND rev_timestamp > log_timestamp #OR ar_timestamp > log_timestamp
) AS edit_count
from logging #NOTE: Timestamp may not be last time adminship granted
WHERE logging.log_type="rights" AND logging.log_action="rights"
AND logging.log_params REGEXP 'newgroups".*"sysop"'
GROUP BY log_title

SQL

Checking query status...