SQL
AخA
select CONCATE("[[User:",actor.actor_name,"|]]") As username, count(logging.log_id) AS actions
from logging
join actor on logging.log_actor = actor.actor_id
where actor.actor_user in (select ug_user from user_groups WHERE ug_group = 'sysop');
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.