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 a
JOIN
	user_groups ug
    ON ug.ug_user = a.actor_user
    AND ug.ug_group = 'sysop'
JOIN
	(
		SELECT rev.rev_actor, COUNT(rev.rev_id)
		FROM revision_userindex rev
		WHERE rev.rev_timestamp > @start
		AND rev.rev_timestamp < @end
    ) as editCounts
    ON editCounts.rev_actor = a.actor_id
LIMIT 100;
SQL

Checking query status...
