Page MenuHomePhabricator

Investigate 'und' making it into a term store query
Open, Needs TriagePublic

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 */