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,

    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