CNRD Complete 2

SQL

use `enwiki_p`;

SELECT page_title, rd_namespace, rd_title
FROM " . $wpDbTablePrefix . "page p
INNER JOIN " . $wpDbTablePrefix . "redirect r on r.rd_from = p.page_id
WHERE r.rd_namespace NOT IN ( 0, 4, 10, 12, 14, 100 )
AND   p.page_namespace = 0
AND rd_title NOT  IN ('Did_you_know','Main_Page','WikiProject_Transport/Maritime_transport_task_force','Requests_for_adminship','WikiProject_Jennifer_Lopez','Cite_your_sources_debate','Neutral_point_of_view','Contents','Longpages','Do_not_include_the_full_text_of_lengthy_primary_sources','Manual_of_Style/Linking','Writing_better_articles/Define_and_describe','Writing_better_articles/Establish_context','Writing_better_articles/Pay_attention_to_spelling');
SQL

Checking query status...
