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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs