use hewiki_p;

select distinct(concat('# [[', replace(p1.page_title, "_", " "), ']]')) as '-----------ערך----------'

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

and not exists

(select * from categorylinks as cl1

 where cl1.cl_from = p1.page_id

 and cl1.cl_to = 'פירושונים')

​