Acronym (name)

SQL

select page_title from page where page_namespace=0 and page_is_redirect=0 and
(    page_title regexp "([A-Z])(?:.|\\W*)([A-Z])(?:.|\\W*)([A-Z])(?:.|\\W*)(?:(?:[A-Z])(?:.|\\W*))*(\\W+_|_\\W+).*\\1.*\\3.*\\)?" or
 	 page_title regexp "([A-Z])(?:.|\\W*)([A-Z])(?:.|\\W*)([A-Z])(?:.|\\W*)(?:(?:[A-Z])(?:.|\\W*))*(\\W+_|_\\W+).*\\1.*\\2.*\\)?" or
 (page_title regexp "([A-Z])(?:.|\\W*)([A-Z])(?:.|\\W*)([A-Z])(?:.|\\W*)(?:(?:[A-Z])(?:.|\\W*))*(\\W+_|_\\W+).*\\2.*\\3.*\\)?"
       and page_title not regexp "\\(.*TV_(station|network|channel)\\)"
     )
)
and page_title not like "%CSI:_Crime_Scene_Investigation%"
and page_title not like "%TLC:_Tables,_Ladders_&_Chairs%"
and not exists (select 1 from pagelinks join linktarget on pl_target_id=lt_id where pl_from=74115810 and lt_namespace=0 and lt_title=page_title)
order by page_title limit 10000;
SQL

Checking query status...
