List of every enwiki administrator ever, based on meta logs

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
# administrators promoted 2005 or earlier do not appear to be in the log.
# there are two parameter formats: old format that looks like "rollbacker sysop", and new format that looks like
    # a:4:{s:12:"4::oldgroups";a:2:{i:0;s:12:"autoreviewer";i:1;s:5:"sysop";}s:12:"5::newgroups";a:1:{i:0;s:12:"autoreviewer";}s:11:"oldmetadata";a:2:{i:0;a:1:{s:6:"expiry";N;}i:1;a:1:{s:6:"expiry";N;}}s:11:"newmetadata";a:1:{i:0;a:1:{s:6:"expiry";N;}}}
# for our purposes, we will just look for the word "sysop". if sysop was removed, then that implies they already had sysop.

SELECT DISTINCT REPLACE(REPLACE(log_title, '_', ' '), '@enwiki', '') AS promoted_to_admin
FROM logging_logindex
WHERE log_type = 'rights'
	AND log_action = 'rights'
    AND log_title LIKE '%@enwiki'
    AND log_params LIKE '%sysop%'
ORDER BY log_title ASC
SQL

Checking query status...
