alaa_wmde added a comment.
Retrieve labels of entity in a specific language
------------------------------------------------
**[OLD] wb_terms**
SQL
## For a property with id P123, in 'en-gb' language
SELECT term_language, term_type, term_text
FROM wb_terms
WHERE
term_full_entity_id = 'P123'
AND term_type = 'label'
AND term_language = 'en-gb'
**[New] new schema**
SQL
## For a property with id P123, in 'en-gb' language
SELECT
wbxl_language as term_language,
wby_name as term_type,
wbx_text as term_text
FROM wbt_property_terms
INNER JOIN wbt_term_in_lang ON wbpt_term_in_lang_id = wbtl_id
INNER JOIN wbt_type ON wbtl_type_id = wby_id
INNER JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
INNER JOIN wbt_text ON wbxl_text_id = wbx_id
WHERE
wbpt_property_id = 123
AND wby_name = 'label'
AND wbxl_language = 'en-gb'
;
TASK DETAIL
https://phabricator.wikimedia.org/T221747
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: alaa_wmde
Cc: Aklapper, Lea_Lacroix_WMDE, alaa_wmde, Nandana, Lahi, Gq86,
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Wikidata-bugs,
aude, Lydia_Pintscher, JeroenDeDauw, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
