use `enwiki_p`;

​

SELECT page_title, rd_namespace, rd_title

FROM (

  SELECT * FROM page p

  WHERE page_is_redirect = 1

  AND p.page_namespace = 0

  AND page_title NOT IN ("Longest_Wikipedia_Article","T:MP","CiteYourSourcesDebate","Rules_to_consider/Do_not_include_primary_sources_debate","MOS:FAQ","Rules_to_consier/Make_only_links_relevant_to_the_context_debate","AvoidBiasDebate","Define_and_Describe_Talk","RulesToConsider/Establish_Context","Rules_to_consider/Pay_attention_to_spelling_debate","T:TDYK","T:DYKT","T:tdyk")

  ) as p

INNER JOIN (

  SELECT * FROM redirect r

  WHERE r.rd_namespace NOT IN (0, 4, 10, 12, 14, 100)

  ) as r on r.rd_from = p.page_id;