Replicas browser and optimizer
Untitled query #41110
This query is marked as a draft
This query has been published
Pages I've deleted which were restored.
select * from logging_userindex lu join actor_logging on lu.log_actor = actor_id where actor_name = 'RoySmith' and lu.log_type = 'delete' and lu.log_action = 'delete' and exists ( select * from logging_logindex ll where lu.log_namespace = ll.log_namespace and lu.log_title = ll.log_title and ll.log_type = 'delete' and ll.log_action = 'restore' ) ;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in