Test queries - Quarry

SQL

select distinct CONCAT("{{User:Aidan9382/templates/ArchiveDumpEntry|1=Talk:",page.page_title,"}}") as basepage_title
from page
join templatelinks as tl
	on tl.tl_from = page.page_id
join linktarget as lt
	on lt.lt_id = tl.tl_target_id
where page.page_namespace = 1
and page.page_is_redirect = 0
and not page.page_title like "%/Archive%" -- Good enough
and lt.lt_title = "MiszaBot/config"
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 an auto-arhiving template but with no archives
-- Probably VERY inefficient, but <shrug>
-- order by basepage_title asc
-- limit 100
;
SQL

Checking query status...
