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\\)"

)
order by page_title limit 10000;
SQL

Checking query status...
