SQL
AخA
SELECT CONCAT('https://en.wikipedia.org/wiki/', p.page_title) AS 'Page', pp.pp_value AS 'Short description', CHAR_LENGTH(CONVERT(pp.pp_value USING utf8mb4)) AS 'Length'
FROM page_props pp
INNER JOIN page p ON pp.pp_page = p.page_id AND p.page_namespace = 0
WHERE pp_propname = 'wikibase-shortdesc'
AND CONVERT(pp.pp_value USING utf8mb4) REGEXP '[^[:alpha:][:ascii:]\\x{2013}\\x{00a0}]';
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.