User:Arnomane/Admins

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

by last edit

[edit]
select user_name, (select rev_timestamp 
                   from revision 
                   where rev_user = user_id 
                   order by rev_timestamp desc limit 1) as last_edit 
from user_ids 
join user_groups on ug_user = user_id and ug_group = "sysop"
order by last_edit desc

by last action

[edit]
select user_name, (select log_timestamp 
                   from logging 
                   where log_user = user_id 
                   order by log_timestamp desc limit 1) as last_action 
from user_ids 
join user_groups on ug_user = user_id and ug_group = "sysop" 
order by last_action desc
Retrieved from "https://commons.wikimedia.org/w/index.php?title=User:Arnomane/Admins&oldid=2075866"