Fork of
Wiedergänger ff
by Count Count
This query is marked as a draft
This query has been published
by Count Count.
SQL
AخA
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 Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.