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'
			)
			OR
			CONCAT(
				log2.log_type,
				'/',
				log2.log_action
			) IN (
				'delete/delete',
				'delete/revision',
				'delete/restore',
			)
		)
		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'
AND log_type = 'delete'
LIMIT 1000;
SQL

Checking query status...
