Most inactive admins @ zhwiki

Fork of Most inactive admins @ zhwiki by WhitePhosphorus

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

Admins with no edits or log actions for six months will be removed after a 1-month notification period.
Note: deleted edits are NOT considered by this query.

SQL

SELECT user_name, MAX(rev_timestamp) as last_edit_time
FROM user, user_groups, actor, revision_userindex
WHERE user_id = ug_user
AND user_id = actor_user
AND rev_actor = actor_id
AND ug_group = "sysop"
GROUP BY user_name
ORDER BY last_edit_time ASC;

SELECT user_name, MAX(log_timestamp) as last_log_time
FROM user, user_groups, actor, logging_userindex
WHERE user_id = ug_user
AND user_id = actor_user
AND log_actor = actor_id
AND ug_group = "sysop"
GROUP BY user_name
ORDER BY last_log_time ASC;

SQL

Checking query status...