Ladsgroup added a comment.
This seems good to me:
wikiadmin@10.64.0.96(wikidatawiki)> EXPLAIN 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 = 17\G;
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: wbt_property_terms
type: ref
possible_keys:
wbt_property_terms_term_in_lang_id_property_id,wbt_property_terms_property_id
key: wbt_property_terms_property_id
key_len: 4
ref: const
rows: 374
Extra:
*************************** 2. row ***************************
id: 1
select_type: SIMPLE
table: wbt_term_in_lang
type: eq_ref
possible_keys:
PRIMARY,wbt_term_in_lang_text_in_lang_id_lang_id,wbt_term_in_lang_type_id_text_in
key: PRIMARY
key_len: 4
ref: wikidatawiki.wbt_property_terms.wbpt_term_in_lang_id
rows: 1
Extra:
*************************** 3. row ***************************
id: 1
select_type: SIMPLE
table: wbt_text_in_lang
type: eq_ref
possible_keys: PRIMARY,wbt_text_in_lang_text_id_text_id
key: PRIMARY
key_len: 4
ref: wikidatawiki.wbt_term_in_lang.wbtl_text_in_lang_id
rows: 1
Extra:
*************************** 4. row ***************************
id: 1
select_type: SIMPLE
table: wbt_text
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: wikidatawiki.wbt_text_in_lang.wbxl_text_id
rows: 1
Extra:
*************************** 5. row ***************************
id: 1
select_type: SIMPLE
table: wbt_type
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: wikidatawiki.wbt_term_in_lang.wbtl_type_id
rows: 1
Extra:
5 rows in set (0.00 sec)
TASK DETAIL
https://phabricator.wikimedia.org/T225053
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Ladsgroup
Cc: hoo, Lucas_Werkmeister_WMDE, Ladsgroup, Aklapper, alaa_wmde, Hook696,
Daryl-TTMG, RomaAmorRoma, 0010318400, E.S.A-Sheild, darthmon_wmde, joker88john,
DannyS712, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo,
Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Af420,
Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls,
Ramalepe, Liugev6, QZanden, LawExplorer, WSH1906, Lewizho99, Maathavan,
_jensen, rosalieper, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
