Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Wikidata descriptions consisting only of one character (all languages)
by
Matěj Suchánek
This query is marked as a draft
This query has been published
by
Frostly
.
See also https://www.wikidata.org/wiki/Special:AbuseFilter/41
Toggle Highlighting
SQL
use wikidatawiki_p; SELECT wbt_item_terms.wbit_item_id AS item, CAST(wbt_text_in_lang.wbxl_language AS CHAR(1000) CHARACTER SET utf8) AS tr, CAST(wbt_text.wbx_text AS CHAR(1000) CHARACTER SET utf8) AS current_desc, LENGTH(wbt_text.wbx_text) AS strl FROM wbt_item_terms JOIN wbt_term_in_lang ON wbt_item_terms.wbit_term_in_lang_id = wbt_term_in_lang.wbtl_id JOIN wbt_text_in_lang ON wbt_term_in_lang.wbtl_text_in_lang_id = wbt_text_in_lang.wbxl_id JOIN wbt_type ON wbt_term_in_lang.wbtl_type_id = wbt_type.wby_id JOIN wbt_text ON wbt_text_in_lang.wbxl_text_id = wbt_text.wbx_id WHERE wbt_text_in_lang.wbxl_language = 'en' AND wbt_type.wby_name = 'description' AND (wbt_text.wbx_text LIKE 'a %' OR wbt_text.wbx_text LIKE 'an %' OR wbt_text.wbx_text LIKE 'A %' OR wbt_text.wbx_text LIKE 'An %') GROUP BY wbt_text.wbx_text, wbt_item_terms.wbit_item_id ORDER BY wbt_item_terms.wbit_item_id DESC LIMIT 1000
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...