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
 */

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'
		)
		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' )
AND a.actor_user IN (
	SELECT ug_user
	FROM user_groups ug
	WHERE ug.ug_group = 'sysop'
)
AND a.actor_name = 'DannyS712'
LIMIT 10;
SQL

Checking query status...
