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.comment_text as DeletionComment from recentchanges inner join logging on log_title=rc_title inner join comment as log_comment on log_comment_id = log_comment.comment_id inner join page on page_title = rc_title inner join comment as rc_comment on rc_comment_id = rc_comment.comment_id left outer join redirect on rd_from = page_id where rc_new = 1 and rc_namespace = 0 and rc_comment.comment_text not like '%Weiterleitung%' and log_type = 'delete' and log_action = 'delete' and log_namespace = '0' and (log_comment.comment_text like '%kandidaten%' or log_comment.comment_text like '%inks%' or log_comment.comment_text like '%rüfung%' or log_comment.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