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
.
https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/core/+/refs/heads/master/includes/language/LanguageCode.php#42
Toggle Highlighting
SQL
SELECT COUNT(wbxl_id) AS 'count', wbxl_language AS lang FROM wbt_text_in_lang WHERE wbxl_language IN ('als', 'bat-smg', 'be-x-old', 'bh', 'fiu-vro', 'no', 'roa-rup', 'simple', 'zh-classical', 'zh-min-nan', 'zh-yue', 'de-formal', 'es-formal', 'hu-formal', 'nl-informal') GROUP BY wbxl_language /*SELECT wbxl_id, wbxl_language AS lang, wbx_text FROM wbt_text_in_lang, wbt_text WHERE wbxl_language IN ('als', 'bat-smg', 'be-x-old', 'bh', 'fiu-vro', 'no', 'roa-rup', 'simple', 'zh-classical', 'zh-min-nan', 'zh-yue', 'de-formal', 'es-formal', 'hu-formal', 'nl-informal') AND wbx_id=wbxl_text_id 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...
