Wikidata - tables - wb_terms - describe table, sample data

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 Jheald.

SQL

use wikidatawiki_p; 
SELECT CURRENT_DATE;
DESCRIBE wb_terms;

SELECT DISTINCT term_entity_type from wb_terms;

SELECT * from wb_terms WHERE term_entity_id = 5 AND term_language = 'en' 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(*) 
from wb_terms where term_entity_type = 'item' AND term_language = 'en' AND term_type = 'description' 
GROUP BY term_text ORDER BY count(*) DESC LIMIT 75

SQL

Checking query status...