Most inactive admins @ zhwiki

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 * AS active_sysops FROM (SELECT log_actor FROM logging
                                       WHERE log_type IN ("block","delete","protect")
                                       AND log_timestamp > 20210711000000 GROUP BY log_actor) AS active_users
INNER JOIN actor ON active_users.log_actor = actor_id
INNER JOIN user_groups ON ug_user = actor_user WHERE ug_group = "sysop";

/*
USE zhwiki_p;
SELECT user_name, MAX(rev_timestamp), user_touched
FROM user
JOIN user_groups ON user_id = ug_user
JOIN actor ON user_id = actor_user
JOIN revision ON rev_actor = actor_id
WHERE ug_group = "sysop"
ORDER BY MAX(rev_timestamp)
*/
                                       
/*
user_touched: 用户上次重新登录/修改用户设定/权限被更改的时间
*/

SQL

Checking query status...