Template redirects where the doc page doesn't redirect

SQL

USE enwiki_p;
SELECT page_title
FROM page
INNER JOIN (
  SELECT
    SUBSTR(page_title, 1, CHAR_LENGTH(page_title) - 4) AS doc_page_title,
    page_is_redirect AS doc_page_is_redirect
  FROM page
  WHERE
    page_namespace = 10
    AND page_title LIKE "%/doc"
) AS doc_page ON doc_page_title = page_title
WHERE
  page_namespace = 10
  AND page_title NOT LIKE "%/doc"
  AND page_title NOT LIKE "%/sandbox"
  AND page_title NOT LIKE "Did you know nominations/%"
  AND page_title NOT LIKE "Editnotice/%"
  AND page_is_redirect
LIMIT 100

SQL

Checking query status...