wikidata: tables - wb_terms - describe table, sample data (old schema)

Fork of Wikidata - tables - wb_terms - describe table, sample data by Jura1

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

SQL

USE wikidatawiki_p; 
SELECT CURRENT_DATE;
DESCRIBE wb_terms;

-- SELECT * FROM wb_terms WHERE term_entity_id = 5 AND term_language='de';

SELECT * FROM wb_terms WHERE term_type='description' AND term_language='en' AND term_search_key LIKE '%annelidologist%' LIMIT 10

-- SELECT term_entity_type, COUNT(*)	FROM wb_terms GROUP BY term_entity_type;
-- SELECT term_type,        COUNT(*) 	FROM wb_terms GROUP BY term_type;
-- SELECT term_language, 	 COUNT(*) 	FROM wb_terms GROUP BY term_language;

-- SELECT term_text, COUNT(*) AS cnt FROM wb_terms WHERE term_entity_type='item' AND term_language='de' AND term_type='description' GROUP BY term_text ORDER BY cnt DESC LIMIT 100;

SQL

Checking query status...