User:Certes/Reports/Talk with missing parent ns
Possibly orphaned talk subpages: parent missing, in non-article namespaces, from quarry:query/62347. (In complex cases like Talk:a/b/c/d, neither Talk:a nor Talk:a/b/c exists.) Excludes User_talk:123.45.67.89/Subpage and User_talk:Foo/Subpage, as it's common (6000+ cases) to create subpages without a main user talk page.
{{Database report
|sql=
SELECT page_namespace AS CSns, page_title AS CurrentSubpage
FROM page Ps
WHERE page_namespace>4 AND page_namespace%2=1 AND page_title LIKE "%/%" 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
|wikilinks= 2:c1
|excerpts=
|comments=
|interval=
|table_style=
|pagination=
|max_pages=
}}
| class="wikitable sortable" style="overflow-wrap: anywhere" |
| scope="col" | CSns
! scope="col" | CurrentSubpage |
|---|
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 7 |
| 7 |
| 7 |
| 7 |
| 7 |
| 7 |
| 7 |
| 7 |
| 9 |
| 9 |
| 9 |
| 9 |
| 11 |
| 11 |
| 11 |
| 11 |
| 11 |
| 11 |
| 11 |
| 11 |
| 11 |
| 15 |
| 15 |
| 15 |
| 15 |
| 15 |
| 119 |
| 119 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
| 829 |
----
{{Database report/footer|count=59|query_runtime=33.11|last_updated=00:02, 23 October 2024 (UTC)}}