Untitled query #6504

SQL

use hewiki_p;
select pp_propname, page_title from page_props inner join page
on page_id = pp_page
where (not pp_propname in ('defaultsort', 'disambiguation', 'displaytitle', 'page_image', 'score', 'wikibase-badge-Q17437796',
'wikibase-badge-Q17559452', 'wikibase-badge-Q17580674', 'wikibase_item', 'forcetoc', 'notoc')#,
#'forcetoc', 'notoc')# temporary
#'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
and not (pp_propname = 'noeditsection'
and page_title = 'עמוד_ראשי')
SQL

Checking query status...
