Fork of Untitled query #41063 by RoySmith
This query is marked as a draft This query has been published by Cryptic.

SQL

​x
 
SELECT * FROM actor_logging WHERE actor_name='RoySmith';
​
SELECT COUNT(DISTINCT lu.log_namespace, lu.log_title)
FROM logging_userindex lu
  JOIN logging_logindex ll ON lu.log_namespace = ll.log_namespace AND lu.log_title = ll.log_title
WHERE lu.log_actor = 27019
  AND lu.log_type = 'delete' AND lu.log_action = 'delete'
  AND ll.log_type = 'delete' AND ll.log_action = 'restore';
​
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...