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 1

    FROM (SELECT page_title AS doc_page_title FROM page) AS doc_page

    WHERE

      page_namespace = 10

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

  )

LIMIT 100