Untitled query #5265

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

Hello to Ukrainian Wikipedia Con 2015

SQL

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 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
(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 ('ארגז_חול_לתבניות', 'ערכים_לא_קיימים_ומוגנים')))

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...