select distinct CONCAT("{{User:Aidan9382//adle|1=Talk:",SUBSTR(page_title,1,LENGTH(page_title)-11),"}}") as basepage_title

from page

where page_namespace = 1

and page_is_redirect = 0

and page_title rlike "/Archive_[1-9][0-9]$" -- Covers enough cases

and not exists (

  select 1

  from page as basepage

  where basepage.page_namespace = 1

  and basepage.page_title = CONCAT(SUBSTR(page.page_title,1,LENGTH(page.page_title)-11),"/Archive_1")

)

order by basepage_title asc;