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...
