Fork of
(temp for the moment)
by Addshore
This query is marked as a draft
This query has been published
by Gnoeee.
SQL
x
use wikidatawiki_p;
SELECT
wby_name as term_type,
term_language,
terms
FROM (
SELECT
wbtl_type_id as term_type_id,
wbxl_language as term_language,
count(*) as terms
FROM wbt_item_terms
INNER JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
INNER JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
WHERE wbxl_language ='ml'
GROUP BY wbtl_type_id
) a
INNER JOIN wbt_type ON term_type_id = wby_id;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.