use hewiki_p;

select page_id, page_title, pl_title from page join pagelinks

on page_id = pl_from

where page_namespace = 0

and pl_namespace = 0

and exists

(select * from page

 where page_title = pl_title

 and page_namespace = 0

 and page_is_redirect)

limit 10

​