Hewiki wrong redirections

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

USE hewiki_p; SELECT CASE page_namespace WHEN -2 THEN "מדיה" WHEN -1 THEN "מיוחד" WHEN 0 THEN ":" WHEN 1 THEN "שיחה" WHEN 2 THEN "משתמש"
WHEN 3 THEN "שיחת משתמש" WHEN 4 THEN "ויקיפדיה" WHEN 5 THEN "שיחת ויקיפדיה" WHEN 6 THEN "קובץ" WHEN 7 THEN "שיחת קובץ" WHEN 8 THEN
"מדיה ויקי" WHEN 9 THEN "שיחת מדיה ויקי" WHEN 10 THEN "תבנית" WHEN 11 THEN "שיחת תבנית" WHEN 12 THEN "עזרה" WHEN 13 THEN "שיחת עזרה"
WHEN 14 THEN "קטגוריה" WHEN 15 THEN "שיחת קטגוריה" WHEN 100 THEN "פורטל" WHEN 101 THEN "שיחת פורטל" WHEN 108 THEN "ספר" WHEN 109 THEN
"שיחת ספר" WHEN 118 THEN "טיוטה" WHEN 119 THEN "שיחת טיוטה" WHEN 828 THEN "יחידה" WHEN 829 THEN "שיחת יחידה" ELSE page_namespace END AS
'מרחב ההפניה', page_title AS 'שם ההפניה', CASE rd_namespace WHEN -2 THEN "מדיה" WHEN -1 THEN "מיוחד" WHEN 0 THEN ":" WHEN 1 THEN "שיחה"
WHEN 2 THEN "משתמש" WHEN 3 THEN "שיחת משתמש" WHEN 4 THEN "ויקיפדיה" WHEN 5 THEN "שיחת ויקיפדיה" WHEN 6 THEN "קובץ" WHEN 7 THEN
"שיחת קובץ" WHEN 8 THEN "מדיה ויקי" WHEN 9 THEN "שיחת מדיה ויקי" WHEN 10 THEN "תבנית" WHEN 11 THEN "שיחת תבנית" WHEN 12 THEN "עזרה"
WHEN 13 THEN "שיחת עזרה" WHEN 14 THEN "קטגוריה" WHEN 15 THEN "שיחת קטגוריה" WHEN 100 THEN "פורטל" WHEN 101 THEN "שיחת פורטל" WHEN 108
THEN "ספר" WHEN 109 THEN "שיחת ספר" WHEN 118 THEN "טיוטה" WHEN 119 THEN "שיחת טיוטה" WHEN 828 THEN "יחידה" WHEN 829 THEN "שיחת יחידה"
ELSE rd_namespace END AS 'מרחב היעד', rd_title AS 'שם היעד' FROM page JOIN redirect ON rd_from = page_id WHERE page_namespace <>
rd_namespace AND NOT (((page_title LIKE "וק:%") OR (page_title LIKE "WP:%")) AND page_namespace = 0 AND (rd_namespace = 4 OR rd_namespace =
-1 OR rd_namespace = 8 OR rd_namespace = 12)) AND NOT (page_namespace = 0 AND page_title = 'Wikipedia_embassy') # shortcuts, 'embassy'
AND NOT (page_namespace = 4 AND (page_title LIKE 'מיזמי_ויקיפדיה/%') AND rd_namespace = 0) # wikipedia projects to articles
AND NOT (page_namespace = 0 AND rd_namespace = 100) AND NOT (page_namespace = 4 AND rd_namespace = 5) # articles to portal, wikipedia to
AND NOT (page_namespace = 4 AND rd_namespace = 12) AND NOT (page_namespace = 5 AND rd_namespace = 13) AND NOT (page_namespace = 4 AND
# wikipedia talk, wikipedia to help, wikipedia talk to help talk, wikipedia to portal, wikipedia talk to portal talk, from user and user talk
rd_namespace = 100) AND NOT (page_namespace = 5 AND rd_namespace = 101) AND NOT (page_namespace = 2 OR page_namespace = 3) AND NOT
(page_namespace = 12 AND rd_namespace = 4) AND NOT (page_namespace = 12 AND rd_namespace = 9) AND NOT (page_namespace = 100 AND
rd_namespace = 4) AND NOT (page_namespace = 4 AND rd_namespace = 8) AND NOT (page_namespace = 5 AND rd_namespace = 9) AND NOT
# help to wikipedia, help to media wiki talk, portal to wikipedia, wikipedia to media wiki, wikipedia talk to media wiki talk
(page_namespace = 9 AND rd_namespace = 12) AND NOT (page_namespace = 4 AND rd_namespace = -1) AND NOT (page_namespace = 0 AND rd_namespace =
14) AND NOT (page_namespace = 10 AND rd_namespace = 100) AND NOT (page_namespace = 11 AND rd_namespace = 101)
# media wiki talk to help, wikipedia to special, articles to category, template to portal, template talk to portal talk
AND NOT (page_namespace = 118 AND rd_namespace = 2) # from draft to user
AND NOT (page_namespace = 4 AND rd_namespace = 0) AND NOT (page_namespace = 4 AND rd_namespace = 10) AND NOT (page_namespace = 4 AND
rd_namespace = 14) AND NOT (page_namespace = 4 AND rd_namespace = 15) AND NOT (page_namespace = 4 AND rd_namespace = 108) AND NOT
(page_namespace = 10 AND rd_namespace = 8) AND NOT (page_namespace = 10 AND rd_namespace = 8) AND NOT (page_namespace = 12 AND rd_namespace =
10) AND NOT (page_namespace = 5 AND rd_namespace = 4) AND NOT (page_namespace = 15 AND rd_namespace = 5) AND NOT (page_namespace = 11 AND
rd_namespace = 5) AND NOT (page_namespace = 1 AND rd_namespace = 4) AND NOT (page_namespace = 1 AND rd_namespace = 5) AND NOT
(page_namespace = 1 AND rd_namespace = 101) AND NOT (page_namespace = 5 AND rd_namespace = 11) AND NOT (page_namespace = 10 AND rd_namespace
= 4) AND NOT (page_namespace = 11 AND rd_namespace = 4) AND NOT (page_namespace = 5 AND rd_namespace = 1) AND NOT (page_namespace = 7 AND
rd_namespace = 1) AND NOT (page_namespace = 100 AND rd_namespace = 10) AND NOT (page_namespace = 4 AND page_title = 'ועדת_בוררים/בקשות') AND
NOT (page_namespace = 4 AND page_title = 'ועדת_בוררים/ניווט') AND NOT (page_namespace = 4 AND page_title = 'מפגשים_ירושלמים') AND NOT
(page_namespace = 4 AND page_title = 'מזנון/דף_משתמש_של_חכם_חנוכה') AND NOT (page_namespace = 5 AND page_title =
'גבולות/פורנוגרפיה/פשרת_eman') AND NOT (page_namespace = 5 AND page_title = 'פרסונה_נון_גרטה/טיוטת_נוהל') AND NOT (page_namespace = 5
AND page_title = 'פרסונה_נון_גרטה') AND NOT (page_namespace = 10 AND page_title = 'תמונות_משתמש_MathKnight') AND NOT (page_namespace = 10
AND page_title = 'תמונות_משתמש_נחמיה_ג') AND NOT (page_namespace = 119 AND rd_namespace = 1 AND page_title = rd_title AND EXISTS (SELECT *
FROM page AS p1 WHERE p1.page_namespace = 118 AND p1.page_title = rd_title))
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...
