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])([A-Z])_\\(\\1.+?\\2.+?\\)"
  or page_title regexp "(?:^|[^A-Z])([A-Z])([A-Z])([A-Z])_\\(\\1.+?\\2.+?\\3.+?\\)"
  or page_title regexp "(?:^|[^A-Z])([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])([A-Z])_\\(\\1.+?\\2.+?\\3.+?\\4.+?\\5.+?\\)"
  or page_title regexp "(?:^|[^A-Z])([A-Z])([A-Z])([A-Z])([A-Z])([A-Z])([A-Z])_\\(\\1.+?\\2.+?\\3.+?\\4.+?\\5.+?\\6.+?\\)"
)
and not exists (select 1 from templatelinks join linktarget on lt_id=tl_target_id where tl_from=page_id and lt_namespace=10 
                and lt_title in ("Title_notice","infobox song","infobox album"))
 
order by page_title limit 10000;
SQL

Checking query status...
