USE trwiki_p;

set @bas = "tr.wikipedia.org/wiki?curid=";

select concat(@bas,p1.page_id) as url, p1.page_title, pl10dan.pl_title , concat(@bas,pl10a.pl_from) as url2

from page p1 join

(select * from pagelinks plll where plll.pl_from_namespace = 6 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 = 6) as pl10a

on pl10a.pl_title = p1.page_title 

-- where 

limit 200

;