SQL
AخA
SELECT DISTINCT
REPLACE(page_title, '_', ' ') AS page
FROM page
JOIN categorylinks
ON cl_from = page_id
JOIN revision ON rev_page = page_id
WHERE cl_to = "Svenska/Substantiv"
AND page_namespace = 0
ORDER BY rev_timestamp DESC
LIMIT 5000;
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.