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

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.

Checking query status...