(Translated by
https://www.hiragana.jp/
)
wikidatawiki Dutch label case anomaly - Quarry
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
Bdijkstra
.
just items for now, no properties
Toggle Highlighting
SQL
SELECT itnl.wbit_item_id AS 'item-id', xnl.wbx_text AS nl, xen.wbx_text AS en, xfr.wbx_text AS fr FROM wbt_item_terms itnl, wbt_item_terms iten, wbt_item_terms itfr, wbt_term_in_lang tnl, wbt_term_in_lang ten, wbt_term_in_lang tfr, wbt_text_in_lang xlnl, wbt_text_in_lang xlen, wbt_text_in_lang xlfr, wbt_text xnl, wbt_text xen, wbt_text xfr WHERE itnl.wbit_item_id=iten.wbit_item_id AND iten.wbit_item_id=itfr.wbit_item_id AND itnl.wbit_term_in_lang_id=tnl.wbtl_id AND iten.wbit_term_in_lang_id=ten.wbtl_id AND itfr.wbit_term_in_lang_id=tfr.wbtl_id AND tnl.wbtl_type_id=1 AND ten.wbtl_type_id=1 AND tfr.wbtl_type_id=1 AND # 1=label tnl.wbtl_text_in_lang_id=xlnl.wbxl_id AND ten.wbtl_text_in_lang_id=xlen.wbxl_id AND tfr.wbtl_text_in_lang_id=xlfr.wbxl_id AND xlnl.wbxl_language='nl' AND xlen.wbxl_language='en' AND xlfr.wbxl_language='fr' AND xlnl.wbxl_text_id=xnl.wbx_id AND xlen.wbxl_text_id=xen.wbx_id AND xlfr.wbxl_text_id=xfr.wbx_id AND xfr.wbx_text REGEXP '^[a-z]' AND xen.wbx_text REGEXP '^[a-z]' AND xnl.wbx_text REGEXP '^[A-Z][a-z]' LIMIT 1000000
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...