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, comment_text as DeletionComment from recentchanges inner join logging on log_title=rc_title inner join comment on log_comment_id=comment_id inner join page on page_title = rc_title left outer join redirect on rd_from = page_id 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 (comment_text like '%kandidaten%' or comment_text like '%inks%' or comment_text like '%rüfung%' or comment_text like '%LP%') and page_namespace = 0 and log_timestamp > 20130000000000 and rd_from is null 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