"___ <sport> Team" redirects (enwiki)

SQL

SELECT page_title, rd_title
FROM page
    RIGHT JOIN redirect ON page_id = rd_from
WHERE page_namespace = 0
    AND page_is_redirect = 1
    AND page_title RLIKE "^(?!.*([Nn]ational|[Cc]ollege|[Uu]niversity|[Ss](chool|tate)))(The )?\\D.*(([Bb]as(e|ket)|[Ff]oot)ball|[Hh]ockey|[Ss]occer)_([Tt]eam)$"
    /* only needs to match a sport OR "team" synonym, not both. Excludes if sport comes right after a ( */
    AND rd_title NOT RLIKE "((?<!\\()(([Bb]as(e|ket)|[Ff]oot)ball|[Hh]ockey|[Ss]occer))|[Tt]eam|[Cc]lub|[FS]\\.?C"
    AND NOT REGEXP_REPLACE(page_title, "_(([Bb]as(e|ket)|[Ff]oot)ball|[Hh]ockey|[Ss]occer)_([Tt]eam)", "") = rd_title
LIMIT 20
SQL

Checking query status...
