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]+_([A-Z])[a-z]+_\\(\\1\\2\\)"
or page_title regexp "([A-Z])[a-z]+_([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])[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]+_([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])[a-z]+_([A-Z])[a-z]+_([A-Z])[a-z]+_\\(\\1\\2\\3\\4\\5\\6\\)"
)
-- and not exists (select 1 from categorylinks where cl_from=page_id
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.