User:Arnomane/Admins

From Wikimedia Commons, the free media repository
Jump to: navigation, 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