Namespaces - Quarry

SQL

USE hewiki_p;
SELECT rd_namespace AS 'מרחב השם', rd_title AS 'שם הדף', page_namespace as 'מרחב ההפניה', page_title AS 'שם ההפניה'
FROM page
JOIN redirect ON redirect.rd_from = page.page_id
WHERE page.page_namespace <> 0
AND NOT page_namespace = rd_namespace
AND NOT (page_namespace = 2 AND rd_namespace = 0)
AND NOT (page_namespace = 4 AND rd_namespace = 0)
AND NOT (page_namespace = 12 AND rd_namespace = 0)
AND NOT (page_namespace = 1 AND rd_namespace = 1)
AND NOT (page_namespace = 14 AND rd_namespace = 0)
AND NOT page_namespace = 3
AND NOT page_namespace = 2
AND NOT (rd_title LIKE "User:%" AND page_namespace = 2)
AND NOT (rd_title LIKE "user:%" AND page_namespace = 2)
AND NOT (rd_title LIKE "en:user:%" AND page_namespace = 2)
AND NOT (rd_title LIKE "User_talk:%" AND page_namespace = 3)
AND NOT (rd_title LIKE "User_talk:%" AND page_namespace = 2)
SQL

Checking query status...
