Unstandardised archives

Archives which are a slight bit off of the normal variation of "Archive [1-9][0-9]*", such as "archive 1" or "archive1"

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 page_random < 0.05 -- for testing
and page_title rlike
"/(archive|ARCHIVE)_?/?[0-9]+$|/[Aa][Rr][Cc][Hh][Ii][Vv][Ee](/?[0-9]+$|_?/?0[0-9]+$)"
-- page_title rlike full-lowercase or full-uppercase archive in any capacity
-- OR rlike any-case archive with a slash or nothing as the number seperator
-- OR rlike any-case archive beginning with a 0 in any capacity
order by basepage_title asc;

SQL

Checking query status...