Addshore added a comment.
Confirming it is not an issue with the new store.
mysql:[email protected] [wikidatawiki]> SELECT
-> wbpt_property_id as id,
-> wby_name as type,
-> wbxl_language as language,
-> wbx_text as text
-> FROM wbt_property_terms
-> LEFT JOIN wbt_term_in_lang ON wbpt_term_in_lang_id = wbtl_id
-> LEFT JOIN wbt_type ON wbtl_type_id = wby_id
-> LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
-> LEFT JOIN wbt_text ON wbxl_text_id = wbx_id
-> WHERE wbpt_property_id = 1566
-> AND wby_name = 'label'
-> AND wbxl_language = 'en';
+------+-------+----------+-------------+
| id | type | language | text |
+------+-------+----------+-------------+
| 1566 | label | en | GeoNames ID |
+------+-------+----------+-------------+
1 row in set (0.01 sec)
TASK DETAIL
https://phabricator.wikimedia.org/T243530
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore
Cc: Ladsgroup, Addshore, Sjoerddebruin, Bencemac, WMDE-leszek, Aklapper,
Lucas_Werkmeister_WMDE, Iflorez, darthmon_wmde, alaa_wmde, Nandana, Lahi, Gq86,
GoranSMilovanovic, Jayprakash12345, QZanden, LawExplorer, _jensen, rosalieper,
Scott_WUaS, Jonas, Wong128hk, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
