Meta administrator removal

SQL

/**
 * Admin name
 * Count of edits
 *
 * Does not include log actions yet
 * 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
	ug.ug_user,
    a.actor_id,
    a.actor_name,
    COUNT(rev.rev_id)
FROM
	user_groups ug
JOIN
	actor_user a
    ON a.actor_user = ug.ug_user
LEFT JOIN
	revision_userindex rev
    ON rev.rev_actor = a.actor_id
WHERE
	ug.ug_group = 'sysop'
    AND rev.rev_timestamp > @start
    AND rev.rev_timestamp <= @end
GROUP BY
	a.actor_id;
*/
SELECT
	ug.ug_user,
    a.actor_id,
    a.actor_name,
    edits.editCount
FROM
	user_groups ug
JOIN
	actor_user a
    ON a.actor_user = ug.ug_user
LEFT JOIN
	(
		SELECT rev.rev_actor AS editActor, COUNT(rev.rev_id) AS editCount
		FROM revision_userindex rev
		WHERE rev.rev_timestamp > @start
		AND rev.rev_timestamp <= @end
		GROUP BY rev.rev_actor
    ) AS edits
	ON edits.editActor = a.actor_id
WHERE
	ug.ug_group = 'sysop'
SQL

Checking query status...
