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

SQL

x
 
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 "שיחת קטגוריה" when 8 then "מדיה ויקי" else page_namespace end)
, ':', page_title) as result,
page_namespace, page_title, rd_namespace, rd_title
from page join redirect on rd_from = page_id where ((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:%")) 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 (page_namespace = 8 and page_title like "סקריפטים/%.js/מידע"))) 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 ('ארגז_חול_לתבניות', 'ערכים_לא_קיימים_ומוגנים')))
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.

Checking query status...