SQL
AخA
USE wikidatawiki_p;
SELECT wbit_item_id, wbx_text
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 enwiki_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 'Ancien%'
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.