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, replace(page_title, "_", " ") as "ערך", left(page_title, locate("/", page_title) - 1) as "שם" from page as p1 where not page_namespace in (2, 3) and page_title like "%/%" and exists (select * from user where user_name = left(page_title, locate("/", page_title) - 1)) and not (page_title in ("7/11", "GNU/Linux", "גנו/לינוקס", "גנו/לינוקס_כנרת", "ו/או", "ויקטור/ויקטוריה", "ישראלים/פעולה/סקס", "לנון/מקרטני", "פרוסט/ניקסון") and page_namespace in (0, 1)) and not (page_title like "%הצעת_הוספה_למומלצים" and page_namespace = 1) and not (exists (select * from page as p3 where (p3.page_namespace = p1.page_namespace) and p3.page_title = left(p1.page_title, locate("/", p1.page_title) - 1))) and not (exists (select * from page as p3 where p3.page_namespace = 10 and p1.page_namespace = 11 and p3.page_title = left(p1.page_title, locate("/", p1.page_title) - 1))) and not (page_namespace = 828 and left(page_title, locate("/", page_title) - 1) = "Kotz") and not (page_namespace = 4 and page_title = "נתונים/WorldMap-json") and not (page_namespace in (4, 12, 13) and left(page_title, locate("/", page_title) - 1) = "ספרים") and not (page_namespace in (4, 5) and left(page_title, locate("/", page_title) - 1) in ("בודק", "ויקיגמד")); select count(*) from page as p1 where page_namespace in (100, 101) and page_title like "%/%" and not exists (select * from page as p3 where p3.page_title = left(p1.page_title, locate("/", p1.page_title) - 1) and p3.page_namespace in (p1.page_namespace, 100))
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...