enwiki: Orphaned templates

SQL

select	page_namespace, page_title
from	page p
where	page_namespace = 10
and		page_is_redirect = 0
and		page_title not rlike '(\\/sandbox|\\/doc|\\/testcases|stub)$'
and		page_title not like 'Attached_KML%'
and		not exists (select 1 from templatelinks where tl_namespace = 10 and tl_title = p.page_title)
and		not exists (select 1 from page_props where p.page_id = pp_page and pp_propname = 'disambiguation')
and		not exists (select 1 from templatelinks where tl_from = p.page_id and tl_namespace = 10 and tl_title in ('Require_subst', 'Subst_only'))
;
SQL

Checking query status...
