Untitled query #86058

SQL

SELECT
  CONCAT('Draft:', page_title) AS page_title,
  rev_timestamp,
  (
    SELECT
      actor_name
    FROM
      actor
    WHERE
      actor_id = (
        SELECT
          rev_actor
        FROM
          revision
        WHERE
          rev_page = p.page_id
        ORDER BY
          rev_timestamp ASC
        LIMIT 1
      )
  ) AS actor_name_
FROM
  page p
  LEFT JOIN revision r ON p.page_latest = r.rev_id
WHERE
  page_namespace = 118
  AND 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 rev_timestamp < DATE_FORMAT(NOW() - INTERVAL 153 DAY, '%Y%m%d%H%i%S')

UNION

SELECT
  CONCAT('User:', page_title) AS page_title,
  rev_timestamp,
  (
    SELECT
      actor_name
    FROM
      actor
    WHERE
      actor_id = (
        SELECT
          rev_actor
        FROM
          revision
        WHERE
          rev_page = p.page_id
        ORDER BY
          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_from_namespace = 2
  AND tl_target_id = (
    SELECT
      lt_id
    FROM
      linktarget
    WHERE
      lt_namespace = 10
      AND lt_title IN ('AFC_submission', 'AfC_submission')
  )
  AND 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 rev_timestamp < DATE_FORMAT(NOW() - INTERVAL 153 DAY, '%Y%m%d%H%i%S')
ORDER BY
  rev_timestamp;
SQL

Checking query status...
