Meta administrator removal

This query is marked as a draft This query has been published by DannyS712.

SQL

/**
* Only looks at the last 183 days, which might not be exactly 6 months
*/

USE metawiki_p;

SELECT
	a.actor_name,
	rev.*
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
    )
WHERE a.actor_user IN (
	SELECT ug_user
	FROM user_groups ug
	WHERE ug.ug_group = 'sysop'
)
AND a.actor_name = 'DannyS712'

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...