FA Old - Quarry

SQL

select distinct CONCAT('https://en.wikipedia.org/wiki/Draft:',page_title) As page, DATEDIFF(R2.rev_timestamp,DATE_ADD(NOW(), INTERVAL -6 MONTH)) as days_left, page_len
from page
left join revision as R1 on R1.rev_page = page_id
left join actor on R1.rev_actor = actor_id
left join revision as R2 on R2.rev_id = page_latest
where (page_namespace = 118)
  and (page_is_redirect = 0)
  and actor_name = 'FloridaArmy'
  and (R1.rev_parent_id = 0)  
  and (R2.rev_timestamp < DATE_ADD( DATE_ADD(NOW(), INTERVAL -6 MONTH), INTERVAL 31 DAY))
order by R2.rev_timestamp asc;


select distinct CONCAT('https://en.wikipedia.org/wiki/Draft:',page_title) As page, DATEDIFF(DATE_ADD(NOW(), INTERVAL -5 MONTH), R2.rev_timestamp) as days_left, page_len
from page
left join revision as R1 on R1.rev_page = page_id
left join actor on R1.rev_actor = actor_id
left join revision as R2 on R2.rev_id = page_latest
where (page_namespace = 118)
  and (page_is_redirect = 0)
  and actor_name = 'FloridaArmy'
  and (R1.rev_parent_id = 0)
  and (R2.rev_timestamp <= DATE_ADD( DATE_ADD(NOW(), INTERVAL -5 MONTH), INTERVAL 7 DAY))
  and (R2.rev_timestamp >= DATE_ADD(NOW(), INTERVAL -5 MONTH))
order by R2.rev_timestamp asc;
SQL

Checking query status...
