Untitled query #55413

SQL

WITH (
	SELECT user_id
	FROM user
	JOIN user_groups ON user_id = ug_user
	WHERE ug_group = 'bot'
) AS bots

SELECT page_namespace, page_title, MAX(rev_timestamp) AS rev_timestamp
FROM page
LEFT JOIN revision ON rev_page = page_id
LEFT JOIN actor_revision ON actor_id = rev_actor
WHERE page_namespace = 118
AND page_is_redirect = 0
AND (actor_user IS NULL OR actor_user NOT IN (SELECT user_id FROM bots))
GROUP BY page_id
HAVING MAX(rev_timestamp) < DATE_FORMAT(UTC_DATE() - INTERVAL 6 MONTH + INTERVAL 1 DAY, '%Y%m%d%H%i%S')

UNION

SELECT page_namespace, page_title, MAX(rev_timestamp) AS rev_timestamp
FROM page
LEFT JOIN revision ON rev_page = page_id
LEFT JOIN actor_revision ON actor_id = rev_actor
JOIN templatelinks ON tl_from = page_id AND tl_namespace = 10 AND tl_title = 'AfC_submission'
WHERE page_namespace = 2
  AND page_is_redirect = 0
  AND (actor_user IS NULL OR actor_user NOT IN (SELECT user_id FROM bots))
GROUP BY page_id
HAVING MAX(rev_timestamp) < DATE_FORMAT(UTC_DATE() - INTERVAL 6 MONTH + INTERVAL 1 DAY, '%Y%m%d%H%i%S')
SQL

Checking query status...
