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[^A-Z_]*\\2[^A-Z_]*\\)"
  or page_title regexp "([A-Z]).+?_([A-Z]).+?_([A-Z]).+?\\(\\1[^A-Z_]*\\2[^A-Z_]*\\3[^A-Z_]*\\)"
  or page_title regexp "([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?\\(\\1[^A-Z_]*\\2[^A-Z_]*\\3[^A-Z_]*\\4[^A-Z_]*\\)"
  or page_title regexp "([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?\\(\\1[^A-Z_]*\\2[^A-Z_]*\\3[^A-Z_]*\\4[^A-Z_]*\\5[^A-Z_]*\\)"
  or page_title regexp "([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?\\(\\1[^A-Z_]*\\2[^A-Z_]*\\3[^A-Z_]*\\4[^A-Z_]*\\5[^A-Z_]*\\6[^A-Z_]*\\)"
  or page_title regexp "([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?\\(\\1[^A-Z_]*\\2[^A-Z_]*\\3[^A-Z_]*\\4[^A-Z_]*\\5[^A-Z_]*\\6[^A-Z_]*\\7[^A-Z_]*\\)"
  or page_title regexp "([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?_([A-Z]).+?\\(\\1[^A-Z_]*\\2[^A-Z_]*\\3[^A-Z_]*\\4[^A-Z_]*\\5[^A-Z_]*\\6[^A-Z_]*\\7[^A-Z_]*\\8[^A-Z_]*\\)"
)
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...
