Untitled query #55413

SQL

SELECT DISTINCT page_namespace, page_title, rev_timestamp, page_latest
FROM page
JOIN revision ON rev_id = page_latest
WHERE page_namespace = 118
AND page_is_redirect = 0
AND rev_timestamp < (DATE_FORMAT((NOW() - INTERVAL 6 MONTH),'%Y%m%d%H%i%S'))
UNION
SELECT DISTINCT page_namespace, page_title, rev_timestamp, page_latest
FROM page
JOIN revision ON rev_id = page_latest
JOIN templatelinks ON tl_from = page_id 
WHERE page_namespace = 2
AND tl_title = "AFC_submission" 
AND tl_namespace = 10
AND page_is_redirect = 0
AND rev_timestamp < (DATE_FORMAT((NOW() - INTERVAL 6 MONTH),'%Y%m%d%H%i%S'))
SQL

Checking query status...
