use hewiki_p; select page_namespace, page_title, rd_namespace, rd_title from page join redirect on rd_from = page_id where ((page_namespace

<> rd_namespace or page_namespace = 14) and not ((((page_title LIKE "וק:%") or (page_title like "WP:%")) and page_namespace = 0 and

rd_namespace in (4, -1, 8, 12)) or (page_namespace = 0 and page_title = 'Wikipedia_embassy') or (page_namespace = 4 and page_title like

'מיזמי_ויקיפדיה/%' and rd_namespace = 0) or page_namespace in (2, 3) or (page_namespace, rd_namespace) in ((0, 100), (4, 5), (4, 12), (5,

13), (4, 100), (5, 101), (2, 3), (12, 4), (12, 9), (100, 4), (4, 8), (5, 9), (9, 12), (4, -1), (0, 14), (10, 100), (11, 101), (118, 2), (10,

828), (4, 0), (4, 10), (4, 14), (4, 15), (4, 108), (10, 8), (10, 8), (12, 10), (5, 4), (15, 5), (11, 5), (1, 4), (1, 5), (1, 101), (5, 11),

(10, 4), (11, 4), (5, 1), (7, 1), (100, 10), (829, 11), (119, 1)) or (page_namespace = 4 AND page_title = 'ועדת_בוררים/בקשות') or

(page_namespace = 4 AND page_title = 'ועדת_בוררים/ניווט') or (page_namespace = 4 AND page_title = 'מפגשים_ירושלמים') or (page_namespace =

4 AND page_title = 'מזנון/דף_משתמש_של_חכם_חנוכה') or (page_namespace = 5 AND page_title = 'גבולות/פורנוגרפיה/פשרת_eman') or

(page_namespace = 5 AND page_title = 'פרסונה_נון_גרטה/טיוטת_נוהל') or (page_namespace = 5 AND page_title = 'פרסונה_נון_גרטה') or

(page_namespace = 10 AND page_title = 'תמונות_משתמש_MathKnight') or (page_namespace = 10 AND page_title = 'תמונות_משתמש_נחמיה_ג') or

(page_namespace = 4 AND page_title like "מסדר_ניקיון/%") or (rd_namespace = 2 AND rd_title = "Deror_avi/טיוטה") or (page_namespace = 119

AND rd_namespace = 1 AND page_title = rd_title AND EXISTS (SELECT * FROM page AS p1 WHERE page_namespace = 118 AND page_title = rd_title)) or

(page_namespace = 118 and page_title = "ללי_ציפי_מיכאלי") or (page_namespace = 14 and page_title = "User_languages"))) or

(not exists (select * from page as p1 where p1.page_title = rd_title  and p1.page_namespace = rd_namespace) and not (page_namespace = 0 and

page_title= 'וק:חס') and not (page_namespace = 0 and page_title = 'וק:יומן_ש') and not ((page_namespace = 2 and (rd_namespace = 0 and

(rd_title like "user:%" or rd_title like "User:%" or rd_title like "en:user:%" or rd_title like "Användare:%" or rd_title like "Uzanto:%" or

rd_title like "User_talk:%") or (rd_namespace = 2 and exists (select * from metawiki_p.page where rd_title = page_title and page_namespace =

2))) or (page_namespace = 3 and rd_namespace = 0 and (rd_title like "User_talk:%" or rd_title like "Usuario_Discusión:%" or rd_title like

"nl:Overleg_gebruiker:%")))) and not (page_namespace = 4 and page_title in ('ארגז_חול_לתבניות', 'ערכים_לא_קיימים_ומוגנים')))

#(((page_namespace <> rd_namespace) or page_namespace = 1)