Created and deleted pages in Nov 2018

SQL

use eswiki_p;
select page_namespace as ns, page_title as title, rev_timestamp as create_date, null as deleted_date, 0 as is_deleted, null seconds_alive
from revision, page where page_id = rev_page and page_namespace = 0
	and rev_timestamp between '20181101000000' and '2018113235959' 
	and rev_parent_id = 0
union(
select log_namespace, log_title, au.ar_timestamp, log_timestamp, 1, log_timestamp - au.ar_timestamp 
 from logging_userindex lu, archive_userindex au
 where log_namespace = 0 
 and log_type = 'delete' 
 and log_timestamp  between '20181101000000' and '2018113235959'
 and au.ar_timestamp between '20181101000000' and '2018113235959'
 and au.ar_namespace = lu.log_namespace
 and au.ar_title = lu.log_title
 and au.ar_timestamp < log_timestamp
 and au.ar_parent_id = 0 
)
SQL

Checking query status...
