SQL
AخA
SELECT CONCAT('https://en.wikipedia.org/wiki/', page_title) AS 'Page',
REGEXP_REPLACE(CONVERT(pp_value USING utf8mb4), '[^[:print:]]', '&unprint;') AS 'Short description'
FROM page_props
JOIN page ON pp_page = page_id AND page_namespace = 0
WHERE pp_propname = 'wikibase-shortdesc'
AND CONVERT(pp_value USING utf8mb4) REGEXP '[^[:print:]]';
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.