Untitled query #86058

SQL

SELECT
  CONCAT('Draft:', p.page_title) AS page_title,
  r.rev_timestamp,
  (
    SELECT
      a.actor_name
    FROM
      actor a
      JOIN revision rev ON rev.rev_actor = a.actor_id
    WHERE
      rev.rev_page = p.page_id
    ORDER BY
      rev.rev_timestamp ASC
    LIMIT 1
  ) AS actor_name_
FROM
  page p
  LEFT JOIN revision r ON p.page_latest = r.rev_id
WHERE
  p.page_namespace = 118
  AND p.page_is_redirect = 0
  AND NOT EXISTS (
    SELECT
      1
    FROM
      page
    WHERE
      page_namespace = 4
      AND page_title = CONCAT('Miscellany_for_deletion/Draft:', p.page_title)
  )
  AND r.rev_timestamp < DATE_FORMAT(NOW() - INTERVAL 153 DAY, '%Y%m%d%H%i%S')

UNION

SELECT
  CONCAT('User:', p.page_title) AS page_title,
  r.rev_timestamp,
  (
    SELECT
      a.actor_name
    FROM
      actor a
      JOIN revision rev ON rev.rev_actor = a.actor_id
    WHERE
      rev.rev_page = p.page_id
    ORDER BY
      rev.rev_timestamp ASC
    LIMIT 1
  ) AS actor_name_
FROM
  templatelinks tl
  LEFT JOIN page p ON tl.tl_from = p.page_id
  LEFT JOIN revision r ON p.page_latest = r.rev_id
WHERE
  tl.tl_from_namespace = 2
  AND tl.tl_target_id IN (
    SELECT
      lt_id
    FROM
      linktarget
    WHERE
      lt_namespace = 10
      AND lt_title IN ('AFC_submission', 'AfC_submission')
  )
  AND p.page_is_redirect = 0
  AND NOT EXISTS (
    SELECT
      1
    FROM
      page
    WHERE
      page_namespace = 4
      AND page_title = CONCAT('Miscellany_for_deletion/User:', p.page_title)
  )
  AND r.rev_timestamp < DATE_FORMAT(NOW() - INTERVAL 153 DAY, '%Y%m%d%H%i%S')
ORDER BY
  r.rev_timestamp;
SQL

Checking query status...
