SET @startTs = DATE_FORMAT(UTC_DATE() - INTERVAL 6 MONTH + INTERVAL 7 DAY, '%Y%m%d%H%i%S');

SET @endTs = DATE_FORMAT(UTC_DATE() - INTERVAL 6 MONTH + INTERVAL 6 DAY, '%Y%m%d%H%i%S');

SELECT DISTINCT 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 < @startTs

  AND rev_timestamp > @endTs

​

UNION

​

SELECT DISTINCT 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 < @startTs

  AND rev_timestamp > @endTs

​