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

  FROM afwiktionary_p.page wikt

  JOIN afwiktionary_p.templatelinks

    ON wikt.page_id = tl_from AND tl_namespace = 10 AND tl_title = '--af--'

  JOIN afwiki_p.page wiki 

    ON wiki.page_title = concat(ucase(substr(wikt.page_title, 1,1)), substr(wikt.page_title, 2))

  JOIN afwiki_p.templatelinks

    ON wiki.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

;