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
Certes
.
Toggle Highlighting
SQL
SELECT page_title AS Title, pp_value AS SD, LENGTH(pp_value) AS SDlen FROM page_props JOIN page ON page_id = pp_page WHERE pp_propname = 'wikibase-shortdesc' AND pp_value BETWEEN 'a' AND 'z~~~' AND CONVERT(pp_value, BINARY) REGEXP "^[a-z]" /* AND NOT pp_value REGEXP "[AEIOUYaeiouy]|\\d{4} ?[-–] ?\\d{4}|DJ|CDP" /* Previous checks: AND pp_value REGEXP "([^-0-9.])\\1\\1\\1" AND pp_value REGEXP "^[BCDFGHJKLMNPQRSTVWXZ bcdfghjklmnpqrstvwxz]*$" AND LENGTH(pp_value) < 4 AND pp_value REGEXP "^[A-Z0-9]*$" */ AND page_namespace = 0 AND page_is_redirect = 0 ORDER BY page_title
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...