Non-existant titles with archive subpages

SQL

-- Notes: Theres ~55k Archive pages under the format Archive %(counter)d and having Archive 1, so ~55k pages get checked here
select CONCAT("[[Talk:",SUBSTR(page_title,1,LENGTH(page_title)-10),"]]") 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 rlike "/Archive_[0-9]+$"
and not exists (
  select 1
  from page as basepage
  where basepage.page_namespace = 1
  and basepage.page_title = SUBSTR(page.page_title,1,LENGTH(page.page_title)-10)
)
order by basepage_title asc;

SQL

Checking query status...