use hewiki_p;

select * from page

where page_namespace = 10

and not page_title like "היום_בהיסטוריה_%"

and not page_title like "הידעת?_%"

and not page_title like "ערך_מומלץ_%"

and page_restrictions <> "";

select * from page_restrictions join page

on page_namespace = 10

and not page_title like "היום_בהיסטוריה_%"

and not page_title like "הידעת?_%"

and not page_title like "ערך_מומלץ_%"

and page_id = pr_page

group by pr_page;

select * from page join page_restrictions on page_title = "כ" and page_namespace = 10 and page_id = pr_page;

select * from page join page_restrictions on page_title = "טווח_שנים" and page_namespace = 10 and page_id = pr_page;

select distinct(pr_level) from page_restrictions