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 

)