Pages deleted in drafts namespace in 30 day period

This query is marked as a draft This query has been published by Jtmorgan.

Last run October 16, 2016

Pages deleted in the "Drafts" namespace from September 16, 2016 through October 16, 2016. Includes page title and date/time of deleting edit.

SQL

select ar_title, ar_timestamp from (select ar_title, ar_timestamp
from archive 
where ar_namespace = 118 and ar_timestamp > 20160916000000 order by ar_timestamp desc) tmp group by ar_title order by ar_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.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...