Addshore created this task.
Addshore added projects: Wikidata-Campsite, Wikidata.
Restricted Application added a subscriber: Aklapper.
TASK DESCRIPTION
The below query has "und" as a condition, which isn't a valid language code,
so probably shouldn't make it all the way down the this layer.
SELECT /*
Wikibase\Lib\Store\Sql\Terms\DatabaseTermInLangIdsResolver::selectTermsViaJoin
*/ wbtl_id, wbtl_type_id, wbxl_language, wbx_text, wbit_item_id FROM
`wbt_term_in_lang`, `wbt_text_in_lang`, `wbt_text`, `wbt_item_terms` WHERE
(wbtl_text_in_lang_id=wbxl_id) AND (wbxl_text_id=wbx_id) AND wbit_item_id IN
(17437798, 17437798, 17437796, 17437796, 513, 513, 11175022, 11175022, 512187,
512187, 33823, 33823, 24291597, 24291597, 6256, 6256, 123480, 123480, 3624078,
3624078, 82794, 82794, 148, 148, 3089177, 3089177, 668, 668, 3088768, 3088768,
43582, 43582, 57441, 57441, 16193958, 16193958, 159741, 159741, 48183, 48183,
48, 48, 28235, 28235, 28464, 28464, 28462, 28462, 28579, 28579, 28576, 28576,
25104017, 25104017, 25104019, 25104019, 25104008, 25104008, 25104009, 25104009,
25104015, 25104015, 25104016, 25104016, 25104014, 25104014, 1065, 1065, 7825,
7825, 191384, 191384, 827525, 827525, 656801, 656801, 1043527, 1043527, 899770,
899770, 384535, 384535, 188822, 188822, 795985, 795985, 8475, 8475, 842490,
842490, 7809, 7809, 5611262, 5611262, 17495, 17495, 376150, 376150, 19826574,
19826574, 371559, 371559, 328, 328, 7085149, 7085149, 21167586, 21167586,
206855, 206855, 40426579, 40426579, 30302657, 30302657, 209224, 209224, 202895,
202895, 54919, 54919, 14005, 14005, 15241312, 15241312, 3063249, 3063249,
1078602, 1078602, 470903, 470903, 315500, 315500, 422969, 422969, 3195923,
3195923, 57816, 57816, 7482577, 7482577, 8065114, 8065114, 6890, 6890, 3297477,
3297477, 7522136, 7522136, 7031185, 7031185, 39825, 39825, 19850216, 19850216,
791801, 791801, 11191, 11191, 19849885, 19849885, 19849849, 19849849, 21540096,
21540096, 19848219, 19848219, 408, 408, 159583, 159583, 5886107, 5886107, 851,
851, 22931307, 22931307, 403, 403, 20437949, 20437949, 183, 183, 18011081,
18011081, 20, 20, 15944791, 15944791, 458, 458, 15942449, 15942449, 917, 917,
1587249, 1587249, 35, 35, 5258036, 5258036, 252, 252, 15948948, 15948948, 833,
833, 15949066, 15949066, 843, 843, 15942337, 15942337, 865, 865, 22078963,
22078963, 30, 30, 6994578, 6994578, 159, 159, 6994577, 6994577, 17, 17, 788335,
788335, 902, 902, 4855500, 4855500, 5100250, 5100250, 6024273, 6024273, 801,
801, 6087760, 6087760, 28, 28, 63993611, 63993611, 9043, 9043, 499327, 499327,
146786, 146786, 1775415, 1775415, 47088290, 47088290, 47088293, 47088293,
47088292, 47088292, 47088295, 47088295, 48839297, 48839297, 11573, 11573, 4917,
4917, 20007257, 20007257, 13196750, 13196750, 2398928, 2398928, 11229, 11229,
1378312, 1378312, 193858, 193858, 60740126, 60740126, 1383497, 1383497, 25250,
25250, 39369, 39369, 25648793, 25648793, 35535, 35535, 25648794, 25648794,
6498663, 6498663, 25648798, 25648798, 860447, 860447, 1648546, 1648546,
27103885, 27103885, 712226, 712226, 465, 465, 24564698, 24564698, 27177113,
27177113, 1185686, 1185686, 28840786, 28840786, 1860, 1860, 30100626, 30100626,
39893449, 39893449, 16057514, 16057514, 3274219, 3274219, 3896143, 3896143,
4584155, 4584155, 17014962, 17014962, 125421, 125421, 39573052, 39573052,
6932210, 6932210, 12953036, 12953036, 12952969, 12952969, 3436664, 3436664,
2392342, 2392342, 3449126, 3449126, 3449115, 3449115, 3449842, 3449842,
6940122, 6940122, 5061915, 5061915, 4926344, 4926344, 4926353, 4926353,
6957144, 6957144, 5091700, 5091700, 5116126, 5116126, 3522797, 3522797,
7296262, 7296262, 7286138, 7286138, 10951226, 10951226, 3832956, 3832956,
7395644, 7395644, 6190889, 6190889, 6310991, 6310991, 6310993, 6310993,
3915492, 3915492, 7709348, 7709348, 7710314, 7710314, 11883865, 11883865,
7803037, 7803037, 6380675, 6380675, 12952538, 12952538, 6426194, 6426194,
6443304, 6443304, 6448337, 6448337, 6481472, 6481472, 7917585, 7917585,
6746900, 6746900, 6703050, 6703050, 7961957, 7961957, 13580783, 13580783,
6737786, 6737786, 15615594, 15615594, 56442, 56442, 15971577, 15971577, 56477,
56477, 6668040, 6668040, 1568, 1568, 35229, 35229, 56500, 56500, 56553, 56553,
56549, 56549, 56666, 56666, 18415595, 18415595, 56871, 56871, 19841092,
19841092, 56904, 56904, 56863, 56863, 56804, 56804, 35990, 35990, 36109, 36109,
56785, 56785, 36612, 36612, 56372, 56372, 56317, 56317, 56316, 56316, 56315,
56315, 28378, 28378, 56381, 56381, 33268, 33268, 32961, 32961, 32994, 32994,
29579, 29579, 33630, 33630, 33979, 33979, 33736, 33736, 33965, 33965, 34271,
34271, 3200624, 3200624, 9229570, 9229570, 12640969, 12640969, 12629033,
12629033, 12629969, 12629969, 12952622, 12952622, 12952691, 12952691, 12952453,
12952453, 12952742, 12952742, 12952744, 12952744, 12952840, 12952840, 12952758,
12952758, 12953022, 12953022, 12953177, 12953177, 12953175, 12953175, 12953178,
12953178, 12953223, 12953223, 12953890, 12953890, 15616509, 15616509, 14240916,
14240916, 12953920, 12953920, 17442461, 17442461, 17588918, 17588918, 22083804,
22083804, 22674828, 22674828, 22303263, 22303263, 22674847, 22674847, 22083815,
22083815, 22662104, 22662104, 22236996, 22236996, 22083826, 22083826, 22237017,
22237017, 22083822, 22083822, 30226846, 30226846, 46995026, 46995026, 1071516,
1071516, 13183983, 13183983, 2605658, 2605658, 1277626, 1277626, 1144444,
1144444, 524007, 524007, 3892207, 3892207, 47740, 47740, 1194596, 1194596,
905467, 905467, 1341218, 1341218, 4292816, 4292816, 27963681, 27963681,
2668355, 2668355, 7530475, 7530475, 1111240, 1111240, 817287, 817287, 6448103,
6448103, 602358, 602358, 24468954, 24468954, 19180675, 19180675, 24790948,
24790948, 19190511, 19190511, 44720760, 44720760, 4837690, 4837690, 153756,
153756, 3152127, 3152127, 47185145, 47185145, 1417780, 1417780, 771405, 771405,
7112372, 7112372, 7977151, 7977151, 265049, 265049, 3037, 3037, 16917033,
16917033, 24259013, 24259013, 5589267, 5589267, 5451, 5451, 192305, 192305,
1318435, 1318435, 7644951, 7644951, 56686358, 56686358, 577, 577, 550207,
550207, 837, 837, 3316598, 3316598, 84044349, 84044349, 9051, 9051, 11175022,
11175022, 33823, 33823, 24291597, 24291597, 3089177, 3089177, 3088768, 3088768,
43582, 43582, 57441, 57441, 16193958, 16193958, 159741, 159741, 28235, 28235,
28464, 28464, 28462, 28462, 28579, 28579, 28576, 28576, 25104017, 25104017,
25104019, 25104019, 25104008, 25104008, 25104009, 25104009, 25104015, 25104015,
25104016, 25104016, 25104014, 25104014, 656801, 1043527, 795985, 795985,
371559, 371559, 7085149, 7085149, 209224, 209224, 202895, 202895, 1078602,
1078602, 470903, 470903, 315500, 315500, 422969, 422969, 3195923, 3195923,
57816, 57816, 7482577, 7482577, 8065114, 8065114, 3297477, 3297477, 7522136,
7522136, 7031185, 7031185, 19850216, 19850216, 19849885, 19849885, 19849849,
19849849, 21540096, 19848219, 19848219, 5886107, 5886107, 22931307, 22931307,
20437949, 20437949, 18011081, 18011081, 15942449, 15942449, 1587249, 1587249,
5258036, 5258036, 15948948, 15948948, 15949066, 15949066, 15942337, 15942337,
22078963, 22078963, 6994577, 6994577, 788335, 788335, 4855500, 4855500,
5100250, 5100250, 6024273, 6024273, 6087760, 6087760, 63993611, 63993611,
47088290, 47088293, 47088292, 47088295, 48839297, 48839297, 2398928, 2398928,
60740126, 60740126, 1383497, 1383497, 25648798, 25648798, 1648546, 1648546,
27103885, 27103885, 27177113, 30100626, 30100626, 16057514, 16057514, 3274219,
3274219, 3896143, 3896143, 4584155, 4584155, 17014962, 17014962, 6932210,
6932210, 12953036, 12953036, 12952969, 12952969, 3436664, 3436664, 2392342,
2392342, 3449126, 3449126, 3449115, 3449115, 3449842, 3449842, 6940122,
6940122, 5061915, 5061915, 4926344, 4926344, 4926353, 4926353, 6957144,
6957144, 5091700, 5091700, 5116126, 5116126, 3522797, 3522797, 7296262,
7296262, 7286138, 7286138, 10951226, 10951226, 3832956, 3832956, 7395644,
7395644, 6190889, 6190889, 6310991, 6310991, 6310993, 6310993, 3915492,
3915492, 7709348, 7709348, 7710314, 7710314, 11883865, 11883865, 7803037,
7803037, 6380675, 6380675, 12952538, 12952538, 6426194, 6426194, 6443304,
6443304, 6448337, 6448337, 6481472, 6481472, 7917585, 7917585, 6746900,
6746900, 6703050, 6703050, 7961957, 7961957, 13580783, 13580783, 6737786,
6737786, 15615594, 15615594, 56442, 56442, 15971577, 15971577, 56477, 56477,
6668040, 6668040, 35229, 35229, 56500, 56500, 56553, 56553, 56549, 56549,
56666, 56666, 18415595, 18415595, 56871, 56871, 19841092, 19841092, 56904,
56904, 56863, 56863, 56804, 56804, 35990, 35990, 56785, 56785, 36612, 36612,
56372, 56372, 56317, 56317, 56316, 56316, 56315, 56315, 28378, 28378, 56381,
56381, 33268, 33268, 32961, 32961, 32994, 32994, 29579, 29579, 33630, 33630,
33979, 33979, 33736, 33736, 33965, 33965, 34271, 34271, 3200624, 3200624,
9229570, 9229570, 12640969, 12640969, 12629033, 12629033, 12629969, 12629969,
12952622, 12952622, 12952691, 12952691, 12952453, 12952453, 12952742, 12952742,
12952744, 12952744, 12952840, 12952840, 12952758, 12952758, 12953022, 12953022,
12953177, 12953177, 12953175, 12953175, 12953178, 12953178, 12953223, 12953223,
12953890, 12953890, 15616509, 15616509, 14240916, 14240916, 12953920, 12953920,
17442461, 17442461, 17588918, 17588918, 22083804, 22083804, 22674828, 22674828,
22303263, 22303263, 22674847, 22674847, 22083815, 22083815, 22662104, 22662104,
22236996, 22236996, 22083826, 22083826, 22237017, 22237017, 22083822, 22083822,
30226846, 30226846, 46995026, 46995026, 1071516, 1071516, 13183983, 13183983,
2605658, 2605658, 1277626, 1277626, 1144444, 1144444, 524007, 524007, 3892207,
3892207, 47740, 47740, 1194596, 1194596, 905467, 905467, 1341218, 1341218,
4292816, 4292816, 27963681, 27963681, 2668355, 2668355, 7530475, 7530475,
1111240, 1111240, 817287, 817287, 6448103, 6448103, 24468954, 24468954,
24790948, 24790948, 44720760, 44720760, 153756, 153756, 47185145, 47185145,
771405, 771405, 7112372, 7112372, 7977151, 7977151, 16917033, 16917033,
24259013, 24259013, 5589267, 5589267, 5451, 5451, 192305, 192305, 1318435,
1318435, 7644951, 7644951, 56686358, 56686358, 3316598, 3316598, 84044349,
84044349) AND wbxl_language IN ('und', 'en') AND (`wbit_term_in_lang_id` =
wbtl_id) /* 274fe6d1308a3ed659507d95bd8cdeec db1126 wikidatawiki 2s */
TASK DETAIL
https://phabricator.wikimedia.org/T250225
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore
Cc: Addshore, Aklapper, darthmon_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic,
QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs,
aude, Lydia_Pintscher, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
