Meta administrator removal

SQL

/**
 * Admin name
 * Timestamp of their 10th most recent edit
 * Timestamp of their 10th most recent **log entry** that requires admin rights, does not account for other admin actions
 *
 * Log entries that count:
 * - abusefilter/*
 * - block/*
 * - delete/delete, /revision, /restore, /event
 * - import/*
 * - rights/rights
 *
 * Not sure about
 * - massmessage
 * - pagetranslation
 * - pagelang
 * - patrol
 */

USE metawiki_p;

SELECT
	a.actor_name,
/*
	rev.rev_id,
	rev.rev_timestamp */
	log.*
FROM actor_user a
/*
JOIN revision_userindex rev
	ON rev.rev_id = (
		SELECT rev_id
		FROM revision_userindex rev2
		WHERE rev2.rev_actor = a.actor_id
		ORDER BY rev2.rev_timestamp DESC
		LIMIT 1
		OFFSET 9
    )
*/
/*
JOIN logging_userindex log
	ON log.log_id = (
		SELECT log_id
		FROM logging_userindex log2
		WHERE log2.log_actor = a.actor_id
		AND (
			log2.log_type IN (
				'abusefilter',
				'block',
				'import'
			)
			OR
			CONCAT(
				log2.log_type,
				'/',
				log2.log_action
			) IN (
				'delete/delete',
				'delete/revision',
				'delete/restore',
				'delete/event',
				'rights/rights'
			)
		)
		ORDER BY log2.log_timestamp DESC
		LIMIT 1
		OFFSET 9
    )
*/
JOIN logging_userindex log
	ON log.log_actor = a.actor_id
WHERE log.log_type NOT IN (
	'abusefilter', 'block', 'create', 'delete', 'import', 'move', 'massmessage', 'pagetranslation', 'pagelang', 'patrol'
)
AND a.actor_user IN (
	SELECT ug_user
	FROM user_groups ug
	WHERE ug.ug_group = 'sysop'
)
AND a.actor_name = 'DannyS712'
AND log_action = 'rights'
LIMIT 100;
SQL

Checking query status...
