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;