SQL
AخA
SELECT concat('[[', w.page_title, ']]') "Wikwoordeboek", concat('[[w:', p.page_title, ']]') "Wikipedia"
FROM afwiktionary_p.page w
JOIN afwiktionary_p.templatelinks wl
ON w.page_id = wl.tl_from AND wl.tl_namespace = 10 AND wl.tl_title IN ('-af-', '=af=')
JOIN afwiki_p.page p
ON p.page_title = concat(ucase(substr(CONVERT(w.page_title USING latin1), 1,1)), substr(w.page_title, 2))
-- ON p.page_title = w.page_title
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 = tl_from AND tl_title IN ('Wikt', 'Wikt-inlyn'))
WHERE
w.page_namespace = 0 AND w.page_is_redirect = 0
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.