XNRs (all but main and project space), not rcatted

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
And page_id not in (Select cl_from from categorylinks where cl_to = "Redirects_to_category_space"); #category space
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 118 and rd_namespace = 118
And page_id not in (Select cl_from from categorylinks where cl_to = "Redirects_to_draft_namespace"); #draft space
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 12 and rd_namespace = 12
And page_id not in (Select cl_from from categorylinks where cl_to = "Redirects_to_help_namespace"); #help space
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 100 and rd_namespace = 100
And page_id not in (Select cl_from from categorylinks where cl_to = "Redirects_to_portal_space"); #portal space
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 10 and rd_namespace = 10
And page_id not in (Select cl_from from categorylinks where cl_to = "Redirects_to_template_namespace"); #template space
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace != 2 and rd_namespace = 2
And page_id not in (Select cl_from from categorylinks where cl_to = "Redirects_to_user_namespace"); #user space
SQL

Checking query status...
