Name (Acronym)

SQL

select page_title from page where page_namespace=0 and page_is_redirect=0 and
(    page_title regexp "([A-Z]).+_([A-Z]).+\\(\\1.*\\2.*\\)"
  or page_title regexp "([A-Z]).+?_([A-Z]).+?_([A-Z]).+?\\(\\1.*\\2.*\\3.*\\)"
  or page_title regexp "([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?\\(\\1.*\\2.*\\3.*\\4.*\\)"
  or page_title regexp "([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?\\(\\1.*\\2.*\\3.*\\4.*\\5.*\\)"
  or page_title regexp "([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?\\(\\1.*\\2.*\\3.*\\4.*\\5.*\\6.*\\)"
  or page_title regexp "([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?\\(\\1.*\\2.*\\3.*\\4.*\\5.*\\6.*\\7.*\\)"
  or page_title regexp "([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?\\(\\1.*\\2.*\\3.*\\4.*\\5.*\\6.*\\7.*\\8.*\\)"
)
and not exists (select 1 from pagelinks where pl_from=74115810 and pl_namespace=0 and pl_title=page_title)
order by page_title limit 10000;
SQL

Checking query status...
