Untitled query #42092

SQL

use ruwiki_p; # 77810
/*select * from page
where page_namespace = 0
#and page_title rlike "^[а-яА-Я]*_[0-9]*$"
and not page_is_redirect
and exists
(select * from redirect
 where rd_title = page_title)
limit 50*/
select * from redirect
where rd_title rlike "[а-яА-Яa-zA-Z]"
and
(rd_title like "%א%"
 or rd_title like "%ב%"
 or rd_title like "%ג%"
 or rd_title like "%ד%"
 or rd_title like "%ה%"
 or rd_title like "%ו%"
 or rd_title like "%ז%"
 or rd_title like "%ח%"
 or rd_title like "%ט%"
 or rd_title like "%י%"
 or rd_title like "%כ%"
 or rd_title like "%ל%"
 or rd_title like "%מ%"
 or rd_title like "%נ%"
 or rd_title like "%ס%"
 or rd_title like "%ע%"
 or rd_title like "%פ%"
 or rd_title like "%צ%"
 or rd_title like "%ק%"
 or rd_title like "%ר%"
 or rd_title like "%ש%"
 or rd_title like "%ת%")
limit 100
SQL

Checking query status...
