Fork of
Most inactive admins @ zhwiki
by WhitePhosphorus
This query is marked as a draft
This query has been published
by WhitePhosphorus.
SQL
x
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;
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.
Query status: complete
Executed in 154.40 seconds as of Sat, 08 Jan 2022 09:53:40 UTC.