use hewiki_p;

select concat("שיחה:", p.page_title) as "מקור", concat("שיחה:", rd.rd_title) as "יעד" from redirect rd inner join page p

on rd_from = page_id

where page_namespace = 1

and rd_namespace = 1

and exists

(select * from pagelinks

 where pl_namespace = 1

 and pl_title = page_title)

​