FA Old - Quarry

SQL

select page_title, DATEDIFF(NOW(), page_touched) as days_old, page_len , actor_name
from page
left join revision on rev_page = page_id
left join actor on rev_actor = actor_id
where (page_namespace = 118)
  and (page_is_redirect = 0)
  and (rev_parent_id = 0)
  /*and actor_name = 'FloridaArmy'*/
  and (page_touched < DATE_ADD(NOW(), INTERVAL -4 MONTH) )
  
order by page_touched asc;



select *
from page
left join revision on rev_page = page_id
left join actor on rev_actor = actor_id
where (page_namespace = 118)
  and (page_is_redirect = 0)
  and (rev_parent_id = 0)
  and page_title = 'Betty_Morrison'
SQL

Checking query status...
