Untitled query #70634

This query is marked as a draft This query has been published by لوقا.

SQL

SELECT 
  actor_name, 
  log_timestamp 
FROM 
  actor
  INNER JOIN logging ON actor_id = log_actor
WHERE 
  actor_name IN (
    SELECT user_name FROM user_groups 
    INNER JOIN user ON user_id = ug_user 
    WHERE ug_group = 'sysop'
  )
  AND 
  log_type = 'rights' 
  AND 
  log_action = 'rights' 
  AND 
  log_params LIKE '%sysop%'

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...