Ladsgroup moved this task from To Do to Peer Review on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. Ladsgroup added a comment.
With this change the query changes to something like this: SELECT wbtl_id,wbtl_type_id,wbxl_language,wbx_text,wbpt_property_id FROM `wbt_term_in_lang` JOIN `wbt_text_in_lang` ON ((wbtl_text_in_lang_id=wbxl_id)) JOIN `wbt_text` ON ((wbxl_text_id=wbx_id)) JOIN `wbt_property_terms` ON ((`wbpt_term_in_lang_id` = wbtl_id)) WHERE wbpt_property_id = 22 AND wbtl_type_id = 1 AND wbxl_language = 'en' SELECT wbtl_id,wbtl_type_id,wbxl_language,wbx_text,wbit_item_id FROM `wbt_term_in_lang` JOIN `wbt_text_in_lang` ON ((wbtl_text_in_lang_id=wbxl_id)) JOIN `wbt_text` ON ((wbxl_text_id=wbx_id)) JOIN `wbt_item_terms` ON ((`wbit_term_in_lang_id` = wbtl_id)) WHERE wbit_item_id = 228 AND wbtl_type_id = 1 AND wbxl_language = 'en' TASK DETAIL https://phabricator.wikimedia.org/T246232 WORKBOARD https://phabricator.wikimedia.org/project/board/3539/ EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: Addshore, Aklapper, Marostegui, Ladsgroup, jcrespo, Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, Iflorez, darthmon_wmde, Kent7301, alaa_wmde, joker88john, CucyNoiD, Nandana, jijiki, Klaas_Z4us_V, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, Lewizho99, Maathavan, elukey, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331, Jay8g
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs