Orphaned template documentation pages

SQL

select
	doc.page_title as doc, doc.page_is_redirect as doc_is_redirect,
    replace(doc.page_title, '/documentation', '') as non_transcluder,
    ifnull(template.page_is_redirect, 0) as non_transcluder_is_redirect,
    doc.page_id is NULL as non_transcluder_exists
from page as doc
left join page as template
on template.page_namespace = doc.page_namespace and replace(doc.page_title, '/documentation', '') = template.page_title
left join templatelinks on tl_from = template.page_id and tl_namespace = doc.page_namespace and tl_title = doc.page_title
where doc.page_namespace = 10 and doc.page_title like '%/documentation' and (template.page_id is null or tl_from is null) limit 100;
SQL

Checking query status...
