SELECT concat('[[', wikt.page_title, ']]'), concat('[[w:', wikt.page_title, ']]'), tl_title

FROM afwiktionary_p.page wikt

JOIN afwiki_p.page wiki 

       ON wikt.page_title = wiki.page_title

JOIN afwiki_p.templatelinks

       ON wikt.page_id = tl_from AND /* tl_namespace = 10 AND */ tl_title IN ('wikt', 'wikt-inlyn')

WHERE wiki.page_namespace = 0

  AND wikt.page_namespace = 0

  AND wiki.page_is_redirect = 0

  AND wikt.page_is_redirect = 0

;