Untitled query #58105

SQL

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
SQL

Checking query status...
