Template redirects where the doc page doesn't redirect

Fork of Template redirects where the doc page doesn't redirect by Retro

This query is marked as a draft This query has been published by Estopedist1.

SQL

USE etwiki_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,
    page_len AS doc_page_len
  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
  AND NOT doc_page_is_redirect
ORDER BY doc_page_len
LIMIT 10;

SQL

Checking query status...