Possibly orphaned template subpages (parent missing)

Fork of Possibly orphaned talk subpages (parent missing) by Certes

This query is marked as a draft This query has been published by Jonesey95.

SQL

SELECT page_namespace AS CSns, page_title AS CurrentSubpage
FROM page Ps
WHERE page_namespace=10 AND page_title LIKE "%/testcases" AND page_is_redirect=0
AND NOT EXISTS (SELECT 1 FROM page WHERE page_namespace=Ps.page_namespace AND page_title=REGEXP_SUBSTR(Ps.page_title, ".*(?=\/)"))
AND NOT EXISTS (SELECT 1 FROM page WHERE page_namespace=Ps.page_namespace AND page_title=REGEXP_SUBSTR(Ps.page_title, ".*?(?=\/)"))
AND NOT EXISTS (SELECT 1 FROM page WHERE page_namespace=Ps.page_namespace-1 AND page_title=Ps.page_title)
ORDER BY page_namespace, page_title

SQL

Checking query status...