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
 * DOES NOT ACCOUNT FOR STEWARD ACTIONS BEING LOGGED AS ADMIN ACTIONS
 *
 * Log entries that count:
 * - abusefilter/*
 * - block/*
 * - delete/delete, /revision, /restore, /event
 * - import/*
 * - rights/rights
 * - protect/protect, /modify
 *
 * Not sure about
 * - massmessage
 * - pagetranslation
 * - pagelang
 * - patrol
 */

USE metawiki_p;

set @start = '20200401000000';
set @end = '20201001000000';

SELECT
	a.*,
    ug.*,
    editCounts.* /**/
FROM
	actor_user a
JOIN
	user_groups ug
    ON ug.ug_user = a.actor_user
    AND ug.ug_group = 'sysop'
LEFT JOIN
	(
		SELECT editor.ug_user, editorActor.*, COUNT(rev.rev_id)
		FROM user_groups editor
		LEFT JOIN actor editorActor
			ON editorActor.actor_user = editor.ug_user
		JOIN revision_userindex rev
			ON rev.rev_actor = editorActor.actor_id
		WHERE editor.ug_group = 'sysop'
		AND rev.rev_timestamp > @start
		AND rev.rev_timestamp < @end
		GROUP BY rev.rev_actor
    ) as editCounts
    ON editCounts.actor_id = a.actor_id/**/
LIMIT 100;
SQL

Checking query status...
