use hewiki_p;

select p1.page_title as 'ערך', pl_title as 'הפניה', rd_title as 'פירושון' from pagelinks inner join page as p1 inner join page as p2

inner join redirect

on pl_namespace = 0

and p1.page_id = pl_from

and p1.page_namespace = 0

and pl_title = p2.page_title

and p2.page_id = rd_from

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 = 'פירושונים')

​