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;