SQL
AخA
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 left join redirect on rd_from=rc_cur_id
where
rc_new=1
and rc_namespace=0
and log_type='delete'
and log_action='delete'
and log_namespace='0'
and log_timestamp > 20130000000000
and log_comment like '%Wikipedia:Articles for deletion%'
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.