SQL
x
use hewiki_p;
select page_title from page
where page_namespace = 10
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%";
select page_title from page
on page_namespace = 10
and not page_title like "היום_בהיסטוריה_%"
and not page_title like "הידעת?_%"
and not page_title like "ערך_מומלץ_%"
and not page_title like "מועד_עברי_%"
and page_restrictions = ""
and exists
(select * from page_restrictions
where page_id = pr_page
and pr_type = "edit"
and pr_level = "sysop")
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.