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_title from page as p0 where page_namespace = 10 and page_is_redirect = 0 and not page_title like "היום_בהיסטוריה_%" and not page_title like "הידעת?_%" and not page_title like "ערך_מומלץ_%" and not page_title like "תמונה_מומלצת_%" and not page_title like "מועד_עברי_%" and not page_title like "ציטוט_יומי_%" and not page_title like "%/%" and ((page_restrictions like "%edit=sysop%") or (page_restrictions like "%edit=templateeditor%") or exists (select * from page_restrictions where page_id = pr_page and pr_type = "edit" and (pr_level = "sysop" or pr_level = "templateeditor"))) and not page_title in ("ברוך_בואך", "ניווט", "הערה", "Citation", "Cite_news", "צ-מאמר", "צ-ספר", "קישור_כללי") and not replace(page_title, "_", " ") in ("Coord", "ניווט קבוצות", "הערות שוליים") and not page_title in ("כ", "-", "CSS", "D", "ה", "ו", "ש", "אומת", "מידע", "קיים") and not replace(page_title, "_", " ") in ("גיל לערכי אישים", "דף מתחלף", "דף מתחלף שלב ב", "מיזמים פעילים", "מרחב שם עם דפי משנה") and not replace(page_title, "_", " ") in ("סוג דגל", "פורטל מומלץ", "פרמטר יום בשנה", "קוד הודעת עריכה", "רווח קשיח") and not replace(page_title, "_", " ") in ("שם דף הבסיס המלא", "שם הודעת עריכה", "מדינה", "עיר", "ויקינתונים") and not replace(page_title, "_", " ") in ("ויקיפדיה - כלים לתרומות אלמוני", "הוספת שטויות לדפים") #check
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...