XNRs (all but main and project space)

SQL

Use enwiki_p;
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 14 and rd_namespace = 14; #category space
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 118 and rd_namespace = 118; #draft space
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 12 and rd_namespace 2 #help space
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 0 and rd_namespace 0 #help space
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 100 and rd_namespace 100 #help space
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 4 and rd_namespace = 4; #project space
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 10 and rd_namespace = 10; #template space
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 2 and rd_namespace = 2; #user space
SQL

Checking query status...
