SQL
AخA
USE zhwiktionary_p;
SELECT page_namespace,
CONCAT(case
when page_namespace = 10 then "Template:"
when page_namespace = 11 then "Template talk:"
when page_namespace = 828 then "Module:"
when page_namespace = 829 then "Module talk:"
end, page_title) AS 'real title',
page_id
FROM page
WHERE page_title REGEXP '^[a-z]'
AND (page_namespace = 10 OR page_namespace = 11 OR page_namespace = 828 OR page_namespace = 829)
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.