Orphaned template documentation pages

SQL

select
	concat('Template:', doc.page_title) as doc, doc.page_is_redirect as doc_is_redirect,
    concat('Template:', 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);
SQL

Checking query status...
