Woorde op Wikt met 'n artikel op Wiki

SQL

SELECT concat('[[', t.page_title, ']]'), concat('[[w:', t.page_title, ']]')
  FROM afwiktionary_p.page t
  JOIN afwiktionary_p.templatelinks tl
    ON t.page_id = tl.tl_from AND tl.tl_namespace = 10 AND tl.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
/*
JOIN afwiki_p.templatelinks pl
    ON p.page_id = pl.tl_from AND pl.tl_namespace = 10 AND pl.tl_title IN ('Wikt', 'Wikt-inlyn')
*/
 WHERE 
   t.page_namespace = 0 AND t.page_is_redirect = 0
LIMIT 10
;

SQL

Checking query status...