USE trwiki_p;

SELECT concat("tr.wikipedia.org/wiki?redirect=no&curid=",page_id) as url, page_title, pl_from from page left join pagelinks on pl_title = page_title

where page_namespace = 6 and page_is_redirect = 1 

and (pl_from_namespace is null OR pl_from_namespace = 0)

order by page_latest

limit 100

;