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

​