Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
IKhitron
.
Toggle Highlighting
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')) and not (page_namespace = 4 and (page_title like 'מיזמי_ויקיפדיה/%') and rd_namespace = 0) and not page_namespace in (2, 3) and not (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)) 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 = 4 AND page_title like "מסדר_ניקיון/%") AND NOT (rd_namespace = 2 AND rd_title = "Deror_avi/טיוטה") 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
.
Checking query status...