- Quarry

SQL

SELECT 
  a.actor_name, 
  ug.ug_group AS role,
  COUNT(log.log_id) AS num_actions, 
  MAX(log.log_timestamp) AS last_action
FROM 
  user_groups ug
  JOIN actor_user a ON a.actor_user = ug.ug_user
  LEFT JOIN logging_userindex log ON log.log_actor = a.actor_id AND log.log_type = 'renameuser'
WHERE 
  ug.ug_group IN ('global-renamer', 'steward', 'bot')
GROUP BY 
  a.actor_name, ug.ug_group
HAVING 
  COUNT(log.log_id) > 0 OR ug.ug_group NOT IN ('bot', 'steward')
UNION ALL
SELECT 
  a.actor_name, 
  'service account' AS role,
  COUNT(log.log_id) AS num_actions, 
  MAX(log.log_timestamp) AS last_action
FROM 
  actor_user a
  LEFT JOIN logging_userindex log ON log.log_actor = a.actor_id AND log.log_type = 'renameuser'
WHERE 
  a.actor_name = 'AccountVanishRequests'
ORDER BY 
  last_action DESC;
SQL

Checking query status...
