select count(*) from page

where not page_namespace

and page_title rlike '[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz]'

and page_title rlike '[АБВГДЕЁЖЗИЙКЛМНОПРСТУФХЦЧШЩЬЫЪЭЮЯабвгдеёжзийклмнопрстуфхцчшщьыъэюя]';

select * from page

where (not page_namespace)

and page_title rlike '[ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz]'

and page_title rlike '[АБВГДЕЁЖЗИЙКЛМНОПРСТУФХЦЧШЩЬЫЪЭЮЯабвгдеёжзийклмнопрстуфхцчшщьыъэюя]'

and not page_title rlike '[(]'

and not page_title rlike '[)]'

and not page_is_redirect

and page_len > 10000

limit 1000

​