Hewiki magic words

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', 'notoc', 'graph_specs', 'index', 'kartographer')#,
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 = 'עמוד_ראשי');

select page_namespace, page_title from page_props inner join page
on page_id = pp_page
where pp_propname = 'displaytitle'
and not page_namespace in (2, 3)
and not (page_namespace = 4
         and page_title in ("סדנה_לגרפיקה", "ארגז_חול"))
and not exists
(select * from templatelinks
 where tl_from = page_id
 and tl_title = "שם_שגוי")
SQL

Checking query status...
