Wikidata items with labels in the most number of languages

This query is marked as a draft This query has been published by Danmichaelo.

To avoid timeout, we can only check a subset of the wikidata items, currently the first 10000 items.

SQL

USE wikidatawiki_p;
SELECT
  term_entity_id,
  MIN(term_text) AS term,
  COUNT(term_language) AS language_count
FROM wb_terms
WHERE term_type="label"
and term_entity_id > 5000 and term_entity_id < 6000
GROUP BY term_entity_id
ORDER BY language_count DESC
LIMIT 100;

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.

SQL

Checking query status...