use hewiki_p;

select l.pl_from, l.pl_title, r.rd_title from redirect r

join page p on r.rd_from=p.page_id

join pagelinks l on p.page_title=l.pl_title

where r.rd_namespace=0 and p.page_namespace=0

limit 1000;