USE trwiki_p;

select * 

from page p1 join

(select * from pagelinks plll where plll.pl_from_namespace = 10 and plll.pl_namespace = 0) as pl10dan

on p1.page_id = pl10dan.pl_from

join

(select * from pagelinks plllll where plllll.pl_from_namespace = 0 and plllll.pl_namespace = 10) as pl10a

on p1.page_title = pl10a.pl_title

limit 2

;