Wiedergänger - Quarry

SQL

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;
SQL

Checking query status...
