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.*
FROM
	actor a
JOIN
	user_groups ug
    ON ug.ug_user = a.actor_user
    AND ug.ug_group = 'sysop'
    
LIMIT 100;
SQL

Checking query status...
