Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Uhai
.
Per WP:RAQ Special:Permalink/1189476832 - 12 Dec 2023
Toggle Highlighting
SQL
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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...