USE enwiki_p;

SELECT *

FROM page

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 EXISTS(

    SELECT *

    FROM (

      SELECT

        page_title AS doc_page_title,

        page_is_redirect AS doc_page_is_redirect

      FROM page

    ) AS doc_page

    WHERE

      page_namespace = 10

      AND doc_page_title = CONCAT(page_title, "/doc")

      AND NOT doc_page_is_redirect

    LIMIT 1

  )

LIMIT 100