SQL
x
SELECT DISTINCT page_namespace, page_title
FROM page
JOIN revision ON rev_id = page_latest
WHERE page_namespace = 118
AND page_is_redirect = 0
AND rev_timestamp < DATE_FORMAT(UTC_DATE() - INTERVAL 6 MONTH + INTERVAL 1 DAY, '%Y%m%d%H%i%S')
UNION
SELECT DISTINCT page_namespace, page_title
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(UTC_DATE() - INTERVAL 6 MONTH + INTERVAL 1 DAY, '%Y%m%d%H%i%S')
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.