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 '[\\x{2200}-\\x{22FF}\\x{1D400}-\\x{1D7FF}\\x{27C0}-\\x{27EF}\\x{2980}-\\x{29FF}\\x{2300}-\\x{23FF}\\x{25A0}-\\x{25FF}\\x{2190}-\\x{21FF}\\x{27F0}-\\x{27FF}\\x{2900}-\\x{297F}\\x{2B00}-\\x{2BFF}\\x{20D0}-\\x{20F0}\\x{207A}-\\x{208E}\\x{FE61}-\\x{FE68}\\x{2016}-\\x{2052}\\x{03D0}-\\x{03F6}]'
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.