SQL
AخA
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 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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.