This query is marked as a draft This query has been published by Delta-light.

SQL

​x
 
SELECT
  user.user_name AS admin_name,
  COUNT(logging.log_id) AS total_protect_actions
FROM
  logging
JOIN actor
  ON logging.log_actor = actor.actor_id
JOIN user
  ON actor.actor_user = user.user_id
JOIN user_groups
  ON user.user_id = user_groups.ug_user
WHERE
  logging.log_type = 'protect'
  AND logging.log_timestamp >= '20250101000000'
  AND logging.log_timestamp <= '20251231235959'
  AND user_groups.ug_group = 'sysop'
GROUP BY
  user.user_name
ORDER BY
  total_protect_actions DESC
LIMIT 5;
​
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...