USE rowiki_p;

SELECT /**/page_namespace as ns, page_title#CONCAT("Template:",page_title)#, pp_value#, concat("*https://ro.wikipedia.org/w/index.php?title=",page_title,"&action=history") as link

    FROM (SELECT * FROM page WHERE page_is_redirect = 1 /*and page_namespace = 10*/) AS page

    JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props

        ON pp_page = page_id

ORDER BY page_title;