Unstandardised archives

SQL

select distinct CONCAT("{{User:Aidan9382//adle|1=Talk:",page_title,"}}") as basepage_title
from page
where page_namespace = 1
and page_is_redirect = 0
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]$|/[Aa][Rr][Cc][Hh][Ii][Vv][Ee]_?/?[^1-9s]$|/[Aa][Rr][Cc][Hh][Ii][Vv][Ee][Ss]/_[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
-- OR rlike a double occurance of /Archive
-- OR rlike /Archive with nothing after it
-- OR rlike /Archive with a not-number after it (excluding /Archives)
-- OR rlike /Archives/_[0-9]+ (A common ClueBot III failure)
order by basepage_title asc;
SQL

Checking query status...
