Untitled query #56333

SQL

	SELECT page_namespace, page_title, rev_timestamp
	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, '%Y%m%d%H%i%S')
	
	UNION
	
	SELECT page_namespace, page_title, rev_timestamp
	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, '%Y%m%d%H%i%S')
SQL

Checking query status...
