SELECT concat('[[', w.page_title, ']]') "Wikwoordeboek", concat('[[w:', w.page_title, ']]') "Wikipedia"

  FROM afwiktionary_p.page w

  JOIN afwiktionary_p.templatelinks wl

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

  JOIN afwiki_p.page p

    ON p.page_title = concat(ucase(substr(t.page_title, 1,1)), substr(t.page_title, 2)) AND p.page_namespace = 0 AND p.page_is_redirect = 0 

       AND p.page_id NOT IN (SELECT tl_from FROM afwiki_p.templatelinks WHERE p.page_id = pl.tl_from AND tl_namespace = 10 AND tl_title IN ('Wikt', 'Wikt-inlyn'))

 WHERE 

   w.page_namespace = 0 AND w.page_is_redirect = 0

;