Replicas browser and optimizer
(temp for the moment)
This query is marked as a draft
This query has been published
use wikidatawiki_p; # First run.... # as, Executed in 787.56 seconds as of Tue Mar 24 2020. # bn, Executed in 1809.17 seconds as of Tue Mar 24 2020. 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 # A INNER JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id # B 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
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in