Poorly ordered archives

Missing Archive 1 but has Archive [02-9] or double-digit archives (In a seperate query due to laziness) (basically anything thats not archive 1), normally indicates poor copying of a template without fixing parameters or poor post-move archive management

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 not page_title like "%/Archive%" -- Covers enough cases
and not exists (
  select 1
  from page as subpage
  where subpage.page_namespace = 1
  and subpage.page_title = CONCAT(page.page_title,"/Archive_1")
)
and exists (
  select 1
  from page as subpage
  where subpage.page_namespace = 1
  and subpage.page_title like page.page_title
  and subpage.page_title rlike "/Archive_([02-9]|[0-9]{2,})$"
)
limit 10;

SQL

Checking query status...