French description

Fork of Czech labels with parenthesis (by number of displays) by Matěj Suchánek

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

SQL

USE wikidatawiki_p;
SELECT wbit_item_id, wbx_text, COUNT(eu_page_id) AS ct
FROM wbt_item_terms
JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
JOIN wbt_type         ON wbtl_type_id = wby_id
JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
JOIN wbt_text         ON wbxl_text_id = wbx_id
LEFT JOIN cswiki_p.wbc_entity_usage ON eu_entity_id = CONCAT('Q', wbit_item_id) AND eu_aspect = CONCAT('L.', wbxl_language)
WHERE wby_name = 'description'
AND wbxl_language = 'fr'
AND wbx_text LIKE '\"%'
GROUP BY wbit_item_id, wbx_text
ORDER BY ct DESC, wbx_text;

SQL

Checking query status...