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

SQL

AخA
 
use hewiki_p; select concat((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 "שיחת קטגוריה" else page_namespace end), ':', page_title) as
result from page join redirect on rd_from = page_id where ((page_namespace #, page_namespace, page_title, rd_namespace, rd_title
<> rd_namespace or page_namespace in (14, 15)) 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, rd_namespace) in ((0, 100), (4, 5), (4, 8), (4, 12), (5, 13), (5, 101), (12, 4), (12, 9),
(100, 4), (5, 9), (9, 12), (4, -1), (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), (1, 5), (1, 101), (5, 11), (10, 4), (11, 4), (5, 1), (7, 1), (100, 10), (829, 11), (119, 1), (4, 100)) 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 = 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 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 ('ארגז_חול_לתבניות', 'ערכים_לא_קיימים_ומוגנים'))) #(((page_namespace <> rd_namespace) or page_namespace = 1)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Query status: superseded