Woorde op Wikt met 'n artikel op Wiki

SQL

SELECT concat('[[', wikt.page_title, ']]'), concat('[[w:', wikt.page_title, ']]'), tl_title
FROM afwiktionary_p.page wikt
JOIN afwiki_p.page wiki 
       ON wiki.page_title = concat(ucase(substr(wikt.page_title, 1,1)), substr(wikt.page_title, 2))
JOIN afwikt_p.templatelinks
       ON wikt.page_id = tl_from AND tl_namespace = 10 AND tl_title = ('--af--')
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
;
SQL

Checking query status...
