Mikey draft - 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_namespace = 1 AND rd_namespace = 3) OR (page_namespace = 3 AND rd_namespace = 1) OR (page_namespace = 0 AND rd_namespace = 2) OR (page_namespace = 2 AND rd_namespace = 0)
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...
