Hewiki wrong redirections

This query is marked as a draft This query has been published by IKhitron.
SQL

use hewiki_p; select #concat('http://he.wikipedia.org/wiki/', (case page_namespace when 0 then "" when 4 then "ויקיפדיה" when 14 then
#":קטגוריה" when 118 then "טיוטה" when 1 then "שיחה" when 2 then "משתמש" when 5 then "שיחת ויקיפדיה" when 15 then "שיחת קטגוריה" when 8
#then "מדיה ויקי" else page_namespace end), ':', page_title, '?redirect=no') as result,#page_namespace, page_title, rd_namespace, rd_title
page_namespace, page_title,
case when exists (select * from page where page_namespace = rd_namespace and page_title = rd_title) then "blue" else "red" end as red
from page join redirect on rd_from = page_id where # not page_namespace in (4, 100, 104) and
(((page_namespace <> rd_namespace or page_namespace in (14, 15)) and not (((page_title LIKE "וק:%") or (page_title like "WP:%")) or
(page_namespace, rd_namespace) in ((0, 100), (4, 5), (4, 8), (4, 12), (5, 13), (5, 101), (12, 4), (12, 9),(100, 4), (9, 12), (119, 3),
(0, 14), (10, 100), (11, 101), (118, 2), (10, 828), (4, 10), (4, 14), (4, 108), (10, 8), (10, 8), (1, 4),(12, 10), (5, 4), (15, 5), (11, 5),
(5, 9), (1, 5), (1, 101), (5, 11), (10, 4), (11, 4), (5, 1), (7, 1), (100, 10), (829, 11), (119, 1), (4, 100), (119, 11)) or page_namespace
in (2, 3) or (page_namespace = 0 and page_title = 'Wikipedia_embassy') or (page_namespace = 4 AND (page_title in ('עמוד_ראשי',
'ועדת_בוררים/בקשות' ,'ועדת_בוררים/ניווט' ,'מזנון/דף_משתמש_של_חכם_חנוכה', 'דף_בוררות/תוכן_לוחות_שנה_בערכי_שנים_לועזיות',
'מפגשים_ירושלמים')) or (rd_namespace = 0 and page_title like "מיזמי_ויקיפדיה/%")) or (page_namespace = 5 AND page_title =
'גבולות/פורנוגרפיה/פשרת_eman') or (page_namespace = 5 AND page_title in ('עורך_חזותי/nowiki' ,'פרסונה_נון_גרטה', 
'פרסונה_נון_גרטה/טיוטת_נוהל')) or (page_namespace=12 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 (page_namespace = 8 and page_title like "סקריפטים/%.js/מידע") or (page_namespace = 11 and page_title =
'Coord/בדיקה_בתבנית/תוצאות'))) or (not exists (select * from page as p1 where p1.page_title = rd_title  and p1.page_namespace =
rd_namespace) and not ((page_namespace in (2, 3) 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 ('ארגז_חול_לתבניות', 'ערכים_לא_קיימים_ומוגנים')))) and not (rd_namespace = -1 and page_namespace = 4)
order by red, page_namespace
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
