SQL
x
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: 用户上次重新登录/修改用户设定/权限被更改的时间
*/
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.