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.05 -- for testing
and page_title rlike
"/(archive|ARCHIVE)_?/?[0-9]+$|/[Aa][Rr][Cc][Hh][Ii][Vv][Ee](/?[0-9]+|_?/?0[0-9]*)$|/[Aa][Rr][Cc][Hh][Ii][Vv][Ee][a-zA-Z0-9_]*/[Aa][Rr][Cc][Hh][Ii][Vv][Ee]|/[Aa][Rr][Cc][Hh][Ii][Vv][Ee]$"
-- 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
-- OR rlike a double occurance of /Archive
-- OR rlike /Archive with nothing after it
order by basepage_title asc;
SQL

Checking query status...
