CNRD Complete 2

SQL

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;
SQL

Checking query status...
