Replicas browser and optimizer
This query is marked as a draft
This query has been published
USE dewiki_p; select rc_timestamp as CreationTime, rc_title as Title, log_timestamp as DeletionTime, log_comment as DeletionComment from recentchanges inner join logging on log_title=rc_title where rc_new=1 and rc_namespace=0 -- and rc_comment not like '%Weiterleitung%' -- and log_type='delete' -- and log_action='delete' -- and log_namespace='0' -- and (log_comment like '%kandidaten%' or log_comment like '%inks%' or log_comment like '%fung%') -- and log_timestamp > 20130000000000 order by rc_timestamp desc, log_timestamp desc;
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