List of every enwiki administrator ever, detailed

SQL

# log_actor contains the actor_id of the person adding/removing the perms
# log_title contains a string of the recipient's name (the person whose perms are getting tweaked)
# only 52,655 non-automatic user rights changes. should be small enough to do slow stuff on like LIKE and RLIKE

SELECT user_name AS promoter, log_title AS promotee, log_params
FROM logging
JOIN actor ON actor_id = log_actor
JOIN user ON user_id = actor_user
WHERE log_type = 'rights'
	AND log_action = 'rights'
    AND log_params RLIKE 'newgroups[^\}]*sysop'
ORDER BY log_id DESC

SQL

Checking query status...