Orphaned subpages [notdone]

Based off of query/69309 but extended to include more than just archives
very shaky since my sql skill is non-existant
Surprisingly good at finding nonsensical pages, which makes sense when coming from such a nonsensical query

SQL

select distinct CONCAT("{{User:Aidan9382/templates/ArchiveDumpEntry|1=Talk:",page_title,"}}") as basepage_title
from page
where page_namespace = 1
and page_is_redirect = 0
-- and page_random < 0.05 -- Reduce calculation time when testing
and page_title like "%/_" -- I assume this is fine
and not exists (
  select 1
  from page as basepage
  where basepage.page_namespace = 1
  and basepage.page_is_redirect = 0 
  -- This below check is stupid - does it even work?? I think it is but god knows
  and basepage.page_title = SUBSTR(TRIM(trailing "/" from page.page_title),1,LENGTH(TRIM(trailing "/" from page.page_title)-1))
)
and not exists (
  select 1
  from page as basepage
  where basepage.page_namespace = 0
  -- and basepage.page_is_redirect = 0
  and basepage.page_title = page.page_title
)
order by basepage_title asc;

SQL

Checking query status...