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,
log_comment as DeletionComment
from recentchanges inner join logging on log_title=rc_title
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 log_comment not like '%SLA%'
and log_timestamp > 20130000000000
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.