use hewiki_p;

select page_title, pp_propname from page_props inner join page

on page_id = pp_page

where (pp_propname in ('graph_specs', 'hiddencat', 'forcetoc', 'index', 'newsectionlink', 'noindex', 'noeditsection',

'nogallery', 'page_top_level_section_count', 'nonewsectionlink', 'staticredirect', 'templatedata')

or (pp_propname = 'disambiguation'

and not exists

(select * from templatelinks

 where tl_from = page_id

 and tl_title = 'פירושונים')))

and page_namespace = 0

limit 1000