Test queries - Quarry

SQL

select distinct CONCAT("{{User:Aidan9382/templates/ArchiveDumpEntry|1=Talk:",page.page_title,"}}") as basepage_title
from page
where page.page_namespace = 1
and page.page_is_redirect = 0
and not page.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")
)
and exists (
	select 1
	from linktarget as lt
	join templatelinks as tl
		on tl.tl_target_id = lt.lt_id
	where tl.tl_from = page.page_id
	and lt.lt_title = "MiszaBot/config"
)
-- This lists all talk pages with no archives and some other stuff
-- Probably VERY inefficient, but <shrug>
-- order by basepage_title asc
limit 100;
SQL

Checking query status...
