"___ <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
    /* Goal is to match things along the lines of "San Francisco Basketball Team". Excludes prefixes that often come before
    teams that *do* have "team" in the name, as well as anything starting with a digit (since sometimes "YYYY Football Team"
    points to "YYYY Football Season" */
    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"
    /* excludes Foo City Baseball Team -> Foo City */
    AND NOT REGEXP_REPLACE(page_title, "_(([Bb]as(e|ket)|[Ff]oot)ball|[Hh]ockey|[Ss]occer)_([Tt]eam)", "") = rd_title
SQL

Checking query status...
