Unstandardised archives

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.01
-- "/archive_?/?[0-9]+$|/ARCHIVE_?/?[0-9]+$|/[Aa][Rr][Cc][Hh][Ii][Vv][Ee]/?[0-9]+$|/[Aa][Rr][Cc][Hh][Ii][Vv][Ee]_?/?0[0-9]+$"
and page_title rlike
"/(archive_?/?[0-9]+$|ARCHIVE_?/?[0-9]+$|[Aa][Rr][Cc][Hh][Ii][Vv][Ee]/?[0-9]+$|[Aa][Rr][Cc][Hh][Ii][Vv][Ee]_?/?0[0-9]+$)"
-- page_title rlike full-lowercase archive (space and slash as optional seperators)
-- OR rlike full-uppercase archive (space and slash as optional seperators)
-- OR rlike any-case archive with a slash as a number seperator
-- OR rlike any-case archive beginning with a 0
order by basepage_title asc;
SQL

Checking query status...
