Test queries - Quarry

SQL

select distinct CONCAT("{{User:Aidan9382/templates/ArchiveDumpEntry|1=Talk:",SUBSTR(page_title,1,LENGTH(page_title)-10),"}}") as basepage_title
from page
where page_namespace = 1
and page_is_redirect = 0
and not page_title like "%/Archive%" -- Good enough
and not exists (
  select 1
  from page as basepage
  where basepage.page_namespace = 1
  and basepage.page_is_redirect = 1
  and basepage.page_title = CONCAT(page.page_title,"/Archive_1")
)
-- This lists all talk pages with no archives for now cause I'm not done
-- order by basepage_title asc
limit 100;
SQL

Checking query status...
