USE plwiki_p;# war pt  zh

SELECT /*page_namespace as ns,*/ 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;