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

SQL

​x
 
use hewiki_p;
select case when exists (select * from categorylinks where cl_from = page_id) then "cat" else "no" end as cat, page_title from page
where page_namespace = 10
and page_is_redirect = 0
and page_title like "%/%"
and not
   (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 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 not page_title like "נתוני_מדינות/%"
and not page_title like "ציטוט_DOI/%"
and not page_title like "ציר_זמן/%"
and not page_title like "שחמט/%"
and not page_title like "שקיעה/%"
and not page_title like "Coord/%"
and not page_title like "גלאם/%"
and not page_title like "GLAM/%"
and not page_title like "MGH_/%"
and not page_title like "Huggle/%"
and not page_title like "תא_יסוד/%")
and not exists (select * from categorylinks where cl_from = page_id);
select case when exists (select * from categorylinks where cl_from = page_id) then "cat" else "no" end as cat, page_title from page
where page_namespace = 10
and page_is_redirect = 0
and 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 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 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 "ציטוט_DOI/%"
and not page_title like "ציר_זמן/%"
and not page_title like "שחמט/%"
and not page_title like "שקיעה/%"
and not page_title like "Coord/%"
and not page_title like "גלאם/%"
and not page_title like "GLAM/%"
and not page_title like "MGH_/%"
and not page_title like "Huggle/%"
and not page_title like "תא_יסוד/%"
and not exists
(select * from categorylinks
 where cl_from = page_id
 and cl_to = "תבניות_עזר_לתבניות")
​
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
All SQL code is licensed under CC0 License.

Checking query status...