use ruwiki_p;

select distinct disambig, page from

((select concat('# [[', replace(p1.page_title, "_", " "), ']]') as page, replace(p2.page_title, "_", " ") as disambig

from pagelinks join page as p1 join page as p2 join redirect

on p1.page_id = pl_from

and pl_title = p2.page_title

and p2.page_id = rd_from

where pl_namespace = 0

and p1.page_namespace = 0

and rd_namespace = 0

and rd_title in

(select page_title

from page join categorylinks

on page_namespace = 0

and page_id = cl_from

and cl_to = 'Страницы_значений_по_алфавиту')

and not exists

(select * from categorylinks as cl1

 where cl1.cl_from = p1.page_id

 and cl1.cl_to = 'Страницы значений по алфавиту')

and not p2.page_title like "%_(значения)"

and p1.page_is_redirect = 0

  /*

union

select concat('# [[', replace(p1.page_title, "_", " "), ']]') as page, replace(p2.page_title, "_", " ") as disambig

from page as p1 join pagelinks on p1.page_id = pagelinks.pl_from

join page as p2 on pagelinks.pl_namespace = p2.page_namespace and pagelinks.pl_title = p2.page_title

where p1.page_is_redirect = 0

and p1.page_namespace = 0

and not p2.page_title like "%_(значения)"

and exists

(select * from categorylinks

 where p2.page_id = cl_from

 and cl_to = 'Страницы_значений_по_алфавиту')

and not exists

(select * from categorylinks

 where p1.page_id = cl_from

 and cl_to = 'Страницы_значений_по_алфавиту')

*/

) as t)

order by disambig, page

​