SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_varchar` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (174682, 174683, 174684, 174685, 174686, 174688, 175412, 175413, 175414, 175415, 175418, 175419, 175420, 175421, 175423, 175424, 175427, 175430, 175438, 175441, 175447, 175448, 175449, 175450, 175451, 175453, 175461, 175465, 175470, 175472, 175473, 175475, 175476, 175480, 175481, 175485, 175486, 175487, 175490, 175500, 175501, 175503, 175512, 175515, 175516, 175517, 175519, 175521, 175524, 175525, 175526, 175529, 175538, 175541, 175543, 175546, 175547, 175548, 175552, 175557, 175559, 175560, 175563, 175566, 175567, 175568, 175570, 175572, 175575, 175576, 175578, 175586, 175587, 175590, 175591, 175592, 175594, 175597, 175599, 175600, 175601, 175602, 175603, 175605, 175606, 175611, 175612, 175616, 175618, 175619, 175629, 175631, 175632, 175635, 175641, 175644, 175647, 175649, 175653, 175656, 175659, 175660, 175670, 175672, 175674, 175675, 175676, 175678, 175681, 175683, 175685, 175689, 175690, 175692, 175695, 175698, 175699, 175700, 175703, 175704, 175705, 175706, 175707, 175708, 175709, 175710, 175711, 175712, 175713, 175714, 175715, 175718, 175721, 175722, 175723, 175724, 175725, 175727, 175728, 175729, 175730, 175731, 175732, 175734, 175735, 175736, 175737, 175739, 175740, 175742, 175744, 175745, 175746, 175747, 175748, 175749, 175750, 175751, 175752, 175753, 175754, 175755, 175756, 175757, 175759, 175760, 175761, 175762, 175763, 175765, 175766, 175767, 175768, 175769, 175770, 175771, 175772, 175773, 175775, 175776, 175777, 175779, 175780, 175781, 175782, 175783, 175784, 175785, 175791, 175792, 175793, 175795, 175796, 175797, 175808, 175810, 175811, 175812, 175815, 175820, 175823, 175824, 175825, 175826, 175828, 175829, 175830, 175831, 175832, 175837, 175845, 175848, 175851, 175852, 175853, 175854, 175855, 175856, 175857, 175858, 175859, 175860, 175861, 175862, 175863, 175868, 175870, 175872, 175874, 175875, 175876, 175877, 175878, 175880, 175881, 175882, 175883, 175884, 175885, 175887, 175889, 175890, 175891, 175892, 175893, 175894, 175895, 175896, 175897, 175898, 175899, 175900, 175902, 175903, 175904, 175905, 175906, 175907, 175908, 175909, 175910, 175911, 175912, 175913, 175914, 175915, 175916, 175917, 175919, 175920, 175922, 175923, 175926, 175927, 175928, 175929, 175930, 175933, 175937, 175938, 175941, 175942, 175943, 175946, 175949, 175950, 175952, 175953, 175955, 175956, 175959, 175960, 175961, 175962, 175963, 175965, 175966, 175967, 175968, 175969, 175972, 175973, 175974, 175977, 175979, 175981, 175983, 175984, 175985, 175986, 175988, 175990, 175991, 175994, 175998, 175999, 176000, 176001, 176002, 176003, 176007, 176008, 176013, 176014, 176015, 176021, 176022, 176023, 176024, 176025, 176026, 176027, 176028, 176030, 176031, 176032, 176033, 176034, 176035, 176036, 176037, 176038, 176041, 176042, 176045, 176046, 176051, 176052, 176062, 176063, 176065, 176066, 176067, 176068, 176071, 176072, 176073, 176078, 176080, 176081, 176083, 176084, 176085, 176086, 176087, 176088, 176089, 176091, 176092, 176093, 176094, 176095, 176096, 176099, 176100, 176101, 176103, 176104, 176105, 176106, 176107, 176108, 176109, 176110, 176111, 176112, 176113, 176115, 176116, 176117, 176118, 176119, 176120, 176121, 176123, 176124, 176125, 176126, 176127, 176128, 176129, 176130, 176131, 176132, 176133, 176134, 176135, 176136, 176139, 176140, 176141, 176143, 176146, 176148, 176149, 176150, 176151, 176152, 176155, 176156, 176157, 176158, 176159, 176160, 176161, 176162, 176163, 176164, 176165, 176166, 176167, 176168, 176169, 176171, 176172, 176173, 176174, 176175, 176176, 176177, 176178, 176180, 176181, 176182, 176183, 176184, 176185, 176187, 176188, 176189, 176190, 176191, 176192, 176196, 176199, 176200, 176201, 176202, 176203, 176204, 176205, 176208, 176210, 176213, 176214, 176215, 176216, 176217, 176218, 176219, 176220, 176221, 176222, 176224, 176225, 176226, 176227, 176228, 176229, 176230, 176231, 176232, 176233, 176236, 176237, 176238, 176239, 176240, 176241, 176242, 176243, 176244, 176245, 176246, 176248, 176249, 176251, 176252, 176254, 176258, 176259, 176261, 176262, 176263, 176264, 176265, 176266, 176267, 176268, 176269, 176270, 176271, 176272, 176274, 176276, 176277, 176278, 176279, 176280, 176283, 176285, 176286, 176287, 176288, 176289, 176291, 176292, 176294, 176295, 176296, 176297, 176298, 176299, 176300, 176302, 176303, 176306, 176307, 176308, 176309, 176310, 176311, 176312, 176313, 176315, 176316, 176317, 176318, 176320, 176321, 176322, 176323, 176325, 176326, 176327, 176328, 176331, 176332, 176333, 176335, 176337, 176338, 176339, 176340, 176341, 176342, 176343, 176344, 176345, 176346, 176347, 176348, 176349, 176350, 176351, 176352, 176353, 176354, 176355, 176356, 176357, 176361, 176362, 176366, 176367, 176370, 176371, 176372, 176373, 176374, 176375, 176390, 176391, 176392, 176393, 176394, 176395, 176396, 176400, 176402, 176403, 176404, 176406, 176408, 176409, 176410, 176411, 176413, 176414, 176415, 176416, 176417, 176418, 176419, 176420, 176428, 176429, 176433, 176435, 176436, 176437, 176438, 176439, 176440, 176441, 176442, 176443, 176444, 176445, 176447, 176449, 176450, 176453, 176455, 176456, 176457, 176458, 176460, 176464, 176465, 176466, 176467, 176471, 176472, 176474, 176475, 176476, 176477, 176478, 176479, 176480, 176482, 176483, 176484, 176485, 176486, 176487, 176488, 176489, 176490, 176491, 176492, 176493, 176494, 176495, 176496, 176497, 176498, 176499, 176500, 176501, 176504, 176505, 176506, 176507, 176508, 176509, 176510, 176519, 176523, 176526, 176527, 176528, 176537, 176542, 176544, 176547, 176548, 176549, 176550, 176552, 176553, 176554, 176556, 176557, 176558, 176559, 176560, 176561, 176562, 176563, 176564, 176570, 176574, 176584, 176587, 176594, 176595, 176605, 176606, 176607, 176608, 176611, 176615, 176618, 176625, 176641, 176643, 176647, 176648, 176651, 176654, 176655, 176656, 176657, 176658, 176660, 176663, 176664, 176665, 176666, 176667, 176668, 176669, 176670, 176673, 176674, 176675, 176677, 176679, 176680, 176682, 176683, 176684, 176685, 176686, 176687, 176688, 176689, 176690, 176691, 176692, 176693, 176694, 176695, 176696, 176697, 176698, 176699, 176700, 176702, 176703, 176705, 176706, 176708, 176710, 176711, 176712, 176714, 176715, 176717, 176718, 176719, 176721, 176722, 176725, 176728, 176730, 176731, 176732, 176734, 176735, 176736, 176738, 176740, 176741, 176742, 176743, 176744, 176748, 176749, 176753, 176767, 176768, 176779, 176780, 176786, 176788, 176789, 176790, 176791, 176795, 176798, 176800, 176808, 176820, 176821, 176822, 176825, 176829, 176832, 176836, 176843, 176844, 176851, 176852, 176853, 176854, 176855, 176859, 176860, 176862, 176866, 176867, 176868, 176870, 176871, 176872, 176873, 176876, 176877, 176878, 176879, 176880, 176881, 176882, 176883, 176884, 176885, 176886, 176887, 176889, 176891, 176895, 176896, 176897, 176898, 176900, 176901, 176902, 176903, 176904, 176907, 176908, 176909, 176911, 176912, 176913, 176914, 176916, 176917, 176918, 176919, 176921, 176922, 176923, 176924, 176926, 176928, 176929, 176931, 176933, 176935, 176936, 176938, 176939, 176942, 176943, 176944, 176946, 176948, 176949, 176950, 176951, 176952, 176953, 176954, 176955, 176956, 176958, 176959, 176960, 176961, 176962, 176963, 176964, 176965, 176967, 176972, 176974, 176975, 176976, 176977, 176978, 176979, 176980, 176981, 176982, 176983, 176985, 176986, 176987, 176988, 176990, 176992, 176993, 176994, 176995, 176996, 176997, 176998, 177000, 177002, 177003, 177004, 177005, 177009, 177011, 177012, 177013, 177014, 177015, 177016, 177017, 177018, 177019, 177020, 177021, 177022, 177023, 177026, 177029, 177030, 177031, 177032, 177033, 177034, 177035, 177036, 177038, 177039, 177040, 177041, 177042, 177043, 177044, 177045, 177046, 177047, 177048, 177049, 177051, 177052, 177053, 177055, 177056, 177058, 177059, 177060, 177061, 177062, 177063, 177064, 177065, 177066, 177067, 177068, 177069, 177070, 177071, 177072, 177073, 177074, 177075, 177076, 177077, 177081, 177083, 177084, 177085, 177086, 177087, 177088, 177089, 177090, 177091, 177096, 177097, 177101, 177102, 177103, 177104, 177108, 177112, 177113, 177114, 177115, 177116, 177117, 177118, 177119, 177120, 177121, 177126, 177127, 177130, 177131, 177132, 177133, 177134, 177135, 177138, 177139, 177141, 177143, 177144, 177150, 177151, 177152, 177156, 177157, 177158, 177159, 177160, 177161, 177162, 177167, 177168, 177169, 177170, 177171, 177172, 177175, 177176, 177179, 177180, 177181, 177182, 177183, 177184, 177185, 177186, 177190, 177191, 177194, 177196, 177197, 177198, 177199, 177200, 177203, 177204, 177205, 177206, 177207, 177213, 177214, 177215, 177216, 177218, 177219, 177222, 177225, 177226, 177227, 177228, 177229, 177230, 177231, 177232, 177235, 177236, 177239, 177240, 177241, 177242, 177243, 177244, 177250, 177253, 177254, 177255, 177257, 177258, 177259, 177266, 177275, 177276, 177279, 177280, 177281, 177282, 177283, 177287, 177288, 177289, 177302, 177303, 177316, 177317, 177318, 177322, 177323, 177324, 177325, 177330, 177331, 177332, 177338, 177339, 177343, 177345, 177346, 177347, 177349, 177350, 177351, 177352, 177353, 177354, 177355, 177357, 177358, 177360, 177361, 177362, 177364, 177365, 177366, 177369, 177372, 177373, 177374, 177381, 177382, 177383, 177384, 177388, 177390, 177391, 177392, 177393, 177394, 177398, 177400, 177401, 177402, 177403, 177404, 177405, 177407, 177409, 177411, 177412, 177415, 177416, 177417, 177420, 177421, 177422, 177423, 177424, 177425, 177429, 177431, 177432, 177433, 177436, 177437, 177439, 177440, 177442, 177445, 177446, 177448, 177449, 177450, 177452, 177453, 177454, 177455, 177456, 177457, 177459, 177460, 177464, 177475, 177477, 177478, 177479, 177481, 177484, 177485, 177495, 177496, 177497, 177499, 177502, 177503, 177505, 177508, 177510, 177511, 177512, 177513, 177514, 177515, 177516, 177517, 177521, 177524, 177528, 177529, 177530, 177533, 177534, 177535, 177536, 177537, 177539, 177544, 177545, 177546, 177551, 177554, 177555, 177556, 177557, 177558, 177559, 177562, 177563, 177567, 177568, 177569, 177570, 177571, 177572, 177573, 177574, 177576, 177577, 177578, 177579, 177581, 177583, 177586, 177587, 177592, 177593, 177602, 177603, 177606, 177608, 177609, 177610, 177616, 177617, 177625, 177635, 177636, 177638, 177641, 177642, 177645, 177646, 177648, 177649, 177650, 177658, 177662, 177669, 177672, 177673, 177675, 177676, 177680, 177681, 177683, 177684, 177686, 177695, 177703, 177706, 177707, 177708, 177709, 177712, 177713, 177716, 177717, 177719, 177721, 177722, 177726, 177728, 177729, 177730, 177733, 177735, 177737, 177740, 177741, 177742, 177745, 177749, 177751, 177752, 177753, 177755, 177758, 177769, 177770, 177775, 177777, 177778, 177779, 177780, 177781, 177782, 177787, 177788, 177789, 177793, 177797, 177799, 177801, 177807, 177810, 177820, 177821, 177822, 177823, 177827, 177833, 177834, 177835, 177838, 177839, 177841, 177842, 177843, 177844, 177845, 177846, 177847, 177852, 177853, 177859, 177863, 177865, 177866, 177867, 177868, 177869, 177870, 177873, 177875, 177876, 177877, 177878, 177882, 177886, 177887, 177888, 177902, 177905, 177906, 177910, 177912, 177914, 177915, 177916, 177918, 177919, 177922, 177923, 177927, 177928, 177930, 177933, 177935, 177936, 177937, 177938, 177941, 177943, 177944, 177945, 177946, 177948, 177949, 177953, 177956, 177957, 177958, 177960, 177962, 177965, 177967, 177968, 177969, 177971, 177973, 177974, 177976, 177978, 177979, 177983, 177985, 177986, 177987, 177989, 177990, 177995, 178000, 178002, 178003, 178004, 178008, 178012, 178013, 178019, 178020, 178021, 178024, 178025, 178026, 178027, 178029, 178030, 178031, 178033, 178034, 178036, 178037, 178039, 178040, 178041, 178044, 178046, 178048, 178049, 178050, 178052, 178054, 178061, 178064, 178066, 178067, 178069, 178071, 178072, 178075, 178076, 178077, 178078, 178081, 178085, 178086, 178087, 178093, 178095, 178096, 178097, 178098, 178101, 178102, 178103, 178106, 178107, 178108, 178109, 178111, 178112, 178115, 178116, 178117, 178118, 178119, 178120, 178121, 178122, 178124, 178125, 178127, 178128, 178129, 178134, 178135, 178136, 178137, 178146, 178148, 178150, 178152, 178153, 178154, 178158, 178159, 178165, 178166, 178173, 178174, 178175, 178176, 178177, 178178, 178179, 178180, 178181, 178183, 178186, 178188, 178189, 178192, 178193, 178194, 178195, 178198, 178200, 178201, 178203, 178204, 178206, 178210, 178218, 178219, 178220, 178225, 178228, 178229, 178230, 178231, 178232, 178233, 178234, 178235, 178240, 178241, 178242, 178243, 178248, 178249, 178250, 178251, 178252, 178254, 178255, 178259, 178260, 178262, 178265, 178267, 178268, 178269, 178270, 178271, 178272, 178274, 178276, 178277, 178278, 178279, 178281, 178284, 178285, 178286, 178287, 178288, 178289, 178290, 178291, 178292, 178294, 178296, 178297, 178298, 178299, 178300, 178302, 178303, 178304, 178306, 178308, 178309, 178310, 178317, 178318, 178321, 178322, 178323, 178328, 178330, 178332, 178333, 178336, 178338, 178339, 178342, 178344, 178346, 178348, 178349, 178350, 178353, 178356, 178365, 178372, 178373, 178375, 178376, 178381, 178382, 178383, 178395, 178398, 178399, 178400, 178401, 178402, 178405, 178406, 178410, 178414, 178418, 178420, 178427, 178430, 178432, 178433, 178434, 178435, 178439, 178440, 178441, 178442, 178443, 178444, 178445, 178446, 178453, 178454, 178455, 178456, 178457, 178458, 178459, 178460, 178461, 178462, 178463, 178464, 178465, 178470, 178477, 178480, 178481, 178482, 178484, 178486, 178488, 178491, 178492, 178493, 178496, 178498, 178500, 178502, 178503, 178504, 178507, 178508, 178509, 178510, 178511, 178512, 178513, 178515, 178516, 178517, 178519, 178520, 178521, 178523, 178524, 178525, 178527, 178528, 178529, 178530, 178536, 178537, 178548, 178558, 178561, 178562, 178565, 178567, 178569, 178570, 178571, 178573, 178574, 178577, 178580, 178582, 178584, 178587, 178588, 178589, 178590, 178591, 178593, 178596, 178597, 178598, 178600, 178601, 178603, 178604, 178606, 178607, 178618, 178622, 178623, 178624, 178625, 178627, 178628, 178630, 178631, 178632, 178633, 178634, 178635, 178638, 178639, 178647, 178648, 178649, 178650, 178651, 178652, 178653, 178654, 178655, 178656, 178657, 178658, 178660, 178661, 178662, 178663, 178664, 178665, 178666, 178668, 178670, 178671, 178672, 178673, 178679, 178680, 178685, 178687, 178688, 178689, 178690, 178691, 178693, 178695, 178696, 178697, 178698, 178699, 178700, 178701, 178702, 178703, 178704, 178705, 178707, 178710, 178711, 178718, 178725, 178726, 178727, 178728, 178729, 178730, 178731, 178737, 178738, 178740, 178741, 178742, 178743, 178744, 178746, 178756, 178757, 178758, 178760, 178762, 178764, 178765, 178766, 178769, 178770, 178771, 178772, 178775, 178776, 178779, 178783, 178784, 178785, 178789, 178794, 178797, 178798, 178799, 178800, 178802, 178804, 178806, 178807, 178808, 178809, 178810, 178811, 178814, 178816, 178818, 178821, 178822, 178823, 178824, 178825, 178826, 178828, 178829, 178839, 178842, 178843, 178845, 178847, 178854, 178855, 178860, 178862, 178865, 178867, 178868, 178872, 178874, 178875, 178879, 178881, 178882, 178883, 178884, 178888, 178890, 178891, 178892, 178893, 178894, 178898, 178899, 178900, 178902, 178903, 178905, 178906, 178908, 178912, 178913, 178915, 178916, 178917, 178919, 178922, 178925, 178926, 178930, 178935, 178936, 178937, 178941, 178945, 178946, 178948, 178949, 178950, 178951, 178952, 178953, 178956, 178957, 178968, 178971, 178972, 178973, 178977, 178979, 178980, 178981, 178983, 178984, 178985, 178986, 178989, 178991, 178994, 179000, 179014, 179019, 179023, 179024, 179027, 179028, 179030, 179031, 179032, 179039, 179040, 179046, 179049, 179050, 179054, 179059, 179060, 179061, 179062, 179063, 179064, 179065, 179066, 179067, 179068, 179069, 179070, 179071, 179072, 179073, 179074, 179075, 179076, 179082, 179083, 179084, 179085, 179086, 179087, 179092, 179095, 179096, 179097, 179099, 179103, 179106, 179107, 179109, 179111, 179114, 179116, 179120, 179121, 179122, 179123, 179124, 179126, 179127, 179128, 179129, 179130, 179131, 179132, 179133, 179135, 179139, 179141, 179143, 179144, 179145, 179148, 179149, 179150, 179151, 179156, 179157, 179158, 179159, 179166, 179167, 179173, 179177, 179178, 179179, 179181, 179182, 179183, 179184, 179186, 179187, 179189, 179190, 179192, 179193, 179198, 179199, 179200, 179201, 179202, 179204, 179205, 179206, 179207, 179208, 179210, 179212, 179214, 179221, 179224, 179225, 179226, 179230, 179231, 179232, 179233, 179234, 179235, 179239, 179240, 179242, 179243, 179246, 179250, 179251, 179252, 179254, 179257, 179259, 179261, 179265, 179267, 179269, 179270, 179271, 179272, 179273, 179274, 179275, 179276, 179277, 179278, 179279, 179284, 179285, 179286, 179287, 179289, 179291, 179292, 179294, 179295, 179296, 179298, 179301, 179305, 179306, 179307, 179309, 179313, 179314, 179315, 179316, 179317, 179319, 179320, 179321, 179322, 179323, 179324, 179327, 179328, 179329, 179330, 179331, 179334, 179335, 179336, 179337, 179338, 179339, 179340, 179341, 179342, 179343, 179344, 179346, 179347, 179348, 179349, 179350, 179353, 179354, 179355, 179362, 179363, 179366, 179367, 179368, 179369, 179371, 179372, 179374, 179377, 179378, 179379, 179381, 179382, 179383, 179384, 179386, 179387, 179389, 179390, 179392, 179394, 179395, 179396, 179398, 179399, 179401, 179402, 179404, 179405, 179406, 179407, 179408, 179409, 179412, 179414, 179415, 179416, 179417, 179419, 179420, 179424, 179425, 179426, 179427, 179433, 179438, 179439, 179445, 179447, 179449, 179453, 179454, 179455, 179456, 179457, 179459, 179463, 179467, 179468, 179469, 179470, 179471, 179475, 179476, 179477, 179479, 179488, 179489, 179496, 179500, 179501, 179502, 179503, 179504, 179505, 179508, 179518, 179545, 179546, 179548, 179549, 179550, 179551, 179553, 179557, 179558, 179562, 179565, 179572, 179573, 179574, 179580, 179581, 179582, 179583, 179584, 179585, 179586, 179587, 179588, 179591, 179592, 179594, 179595, 179597, 179603, 179606, 179608, 179609, 179614, 179619, 179620, 179621, 179627, 179628, 179630, 179631, 179632, 179633, 179634, 179635, 179636, 179638, 179640, 179644, 179647, 179648, 179650, 179651, 179653, 179654, 179655, 179656, 179657, 179658, 179659, 179660, 179661, 179663, 179665, 179668, 179671, 179673, 179677, 179678, 179681, 179682, 179683, 179684, 179685, 179687, 179689, 179690, 179693, 179696, 179697, 179699, 179700, 179701, 179702, 179703, 179705, 179706, 179708, 179711, 179713, 179717, 179719, 179722, 179727, 179728, 179732, 179734, 179735, 179736, 179737, 179738, 179740, 179742, 179743, 179744, 179745, 179746, 179747, 179748, 179751, 179752, 179754, 179755, 179758, 179760, 179761, 179763, 179764, 179765, 179766, 179767, 179770, 179773, 179774, 179775, 179778, 179779, 179780, 179783, 179785, 179786, 179788, 179789, 179790, 179791, 179794, 179795, 179796, 179803, 179805, 179806, 179808, 179809, 179811, 179815, 179821, 179822, 179823, 179826, 179832, 179836, 179837, 179838, 179839, 179840, 179841, 179843, 179844, 179847, 179851, 179852, 179853, 179856, 179857, 179858, 179865, 179866, 179869, 179874, 179876, 179881, 179885, 179887, 179888, 179892, 179894, 179898, 179902, 179906, 179907, 179911, 179912, 179918, 179920, 179921, 179922, 179923, 179924, 179926, 179928, 179935, 179941, 179943, 179945, 179947, 179961, 179962, 179964, 179967, 179970, 179971, 179973, 179974, 179983, 179994, 179995, 179996, 180000, 180001, 180003, 180004, 180005, 180006, 180010, 180014, 180018, 180019, 180022, 205332, 210273, 210632, 216371, 216373, 216375, 216377, 216393, 216397, 216406, 216408, 216422, 216450, 216459, 216460, 216464, 216469, 216474, 216475, 216477, 216478, 216479, 216493, 216503, 216507, 216520, 216522, 216523, 216524, 216525, 216544, 216552, 216571, 216592, 216593, 216594, 216601, 216605, 216606, 216610, 216633, 216653, 216658, 216678, 216688, 216689, 216690, 216691, 216693, 216710)) AND (t_d.attribute_id IN ('96', '109')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (174682, 174683, 174684, 174685, 174686, 174688, 175412, 175413, 175414, 175415, 175418, 175419, 175420, 175421, 175423, 175424, 175427, 175430, 175438, 175441, 175447, 175448, 175449, 175450, 175451, 175453, 175461, 175465, 175470, 175472, 175473, 175475, 175476, 175480, 175481, 175485, 175486, 175487, 175490, 175500, 175501, 175503, 175512, 175515, 175516, 175517, 175519, 175521, 175524, 175525, 175526, 175529, 175538, 175541, 175543, 175546, 175547, 175548, 175552, 175557, 175559, 175560, 175563, 175566, 175567, 175568, 175570, 175572, 175575, 175576, 175578, 175586, 175587, 175590, 175591, 175592, 175594, 175597, 175599, 175600, 175601, 175602, 175603, 175605, 175606, 175611, 175612, 175616, 175618, 175619, 175629, 175631, 175632, 175635, 175641, 175644, 175647, 175649, 175653, 175656, 175659, 175660, 175670, 175672, 175674, 175675, 175676, 175678, 175681, 175683, 175685, 175689, 175690, 175692, 175695, 175698, 175699, 175700, 175703, 175704, 175705, 175706, 175707, 175708, 175709, 175710, 175711, 175712, 175713, 175714, 175715, 175718, 175721, 175722, 175723, 175724, 175725, 175727, 175728, 175729, 175730, 175731, 175732, 175734, 175735, 175736, 175737, 175739, 175740, 175742, 175744, 175745, 175746, 175747, 175748, 175749, 175750, 175751, 175752, 175753, 175754, 175755, 175756, 175757, 175759, 175760, 175761, 175762, 175763, 175765, 175766, 175767, 175768, 175769, 175770, 175771, 175772, 175773, 175775, 175776, 175777, 175779, 175780, 175781, 175782, 175783, 175784, 175785, 175791, 175792, 175793, 175795, 175796, 175797, 175808, 175810, 175811, 175812, 175815, 175820, 175823, 175824, 175825, 175826, 175828, 175829, 175830, 175831, 175832, 175837, 175845, 175848, 175851, 175852, 175853, 175854, 175855, 175856, 175857, 175858, 175859, 175860, 175861, 175862, 175863, 175868, 175870, 175872, 175874, 175875, 175876, 175877, 175878, 175880, 175881, 175882, 175883, 175884, 175885, 175887, 175889, 175890, 175891, 175892, 175893, 175894, 175895, 175896, 175897, 175898, 175899, 175900, 175902, 175903, 175904, 175905, 175906, 175907, 175908, 175909, 175910, 175911, 175912, 175913, 175914, 175915, 175916, 175917, 175919, 175920, 175922, 175923, 175926, 175927, 175928, 175929, 175930, 175933, 175937, 175938, 175941, 175942, 175943, 175946, 175949, 175950, 175952, 175953, 175955, 175956, 175959, 175960, 175961, 175962, 175963, 175965, 175966, 175967, 175968, 175969, 175972, 175973, 175974, 175977, 175979, 175981, 175983, 175984, 175985, 175986, 175988, 175990, 175991, 175994, 175998, 175999, 176000, 176001, 176002, 176003, 176007, 176008, 176013, 176014, 176015, 176021, 176022, 176023, 176024, 176025, 176026, 176027, 176028, 176030, 176031, 176032, 176033, 176034, 176035, 176036, 176037, 176038, 176041, 176042, 176045, 176046, 176051, 176052, 176062, 176063, 176065, 176066, 176067, 176068, 176071, 176072, 176073, 176078, 176080, 176081, 176083, 176084, 176085, 176086, 176087, 176088, 176089, 176091, 176092, 176093, 176094, 176095, 176096, 176099, 176100, 176101, 176103, 176104, 176105, 176106, 176107, 176108, 176109, 176110, 176111, 176112, 176113, 176115, 176116, 176117, 176118, 176119, 176120, 176121, 176123, 176124, 176125, 176126, 176127, 176128, 176129, 176130, 176131, 176132, 176133, 176134, 176135, 176136, 176139, 176140, 176141, 176143, 176146, 176148, 176149, 176150, 176151, 176152, 176155, 176156, 176157, 176158, 176159, 176160, 176161, 176162, 176163, 176164, 176165, 176166, 176167, 176168, 176169, 176171, 176172, 176173, 176174, 176175, 176176, 176177, 176178, 176180, 176181, 176182, 176183, 176184, 176185, 176187, 176188, 176189, 176190, 176191, 176192, 176196, 176199, 176200, 176201, 176202, 176203, 176204, 176205, 176208, 176210, 176213, 176214, 176215, 176216, 176217, 176218, 176219, 176220, 176221, 176222, 176224, 176225, 176226, 176227, 176228, 176229, 176230, 176231, 176232, 176233, 176236, 176237, 176238, 176239, 176240, 176241, 176242, 176243, 176244, 176245, 176246, 176248, 176249, 176251, 176252, 176254, 176258, 176259, 176261, 176262, 176263, 176264, 176265, 176266, 176267, 176268, 176269, 176270, 176271, 176272, 176274, 176276, 176277, 176278, 176279, 176280, 176283, 176285, 176286, 176287, 176288, 176289, 176291, 176292, 176294, 176295, 176296, 176297, 176298, 176299, 176300, 176302, 176303, 176306, 176307, 176308, 176309, 176310, 176311, 176312, 176313, 176315, 176316, 176317, 176318, 176320, 176321, 176322, 176323, 176325, 176326, 176327, 176328, 176331, 176332, 176333, 176335, 176337, 176338, 176339, 176340, 176341, 176342, 176343, 176344, 176345, 176346, 176347, 176348, 176349, 176350, 176351, 176352, 176353, 176354, 176355, 176356, 176357, 176361, 176362, 176366, 176367, 176370, 176371, 176372, 176373, 176374, 176375, 176390, 176391, 176392, 176393, 176394, 176395, 176396, 176400, 176402, 176403, 176404, 176406, 176408, 176409, 176410, 176411, 176413, 176414, 176415, 176416, 176417, 176418, 176419, 176420, 176428, 176429, 176433, 176435, 176436, 176437, 176438, 176439, 176440, 176441, 176442, 176443, 176444, 176445, 176447, 176449, 176450, 176453, 176455, 176456, 176457, 176458, 176460, 176464, 176465, 176466, 176467, 176471, 176472, 176474, 176475, 176476, 176477, 176478, 176479, 176480, 176482, 176483, 176484, 176485, 176486, 176487, 176488, 176489, 176490, 176491, 176492, 176493, 176494, 176495, 176496, 176497, 176498, 176499, 176500, 176501, 176504, 176505, 176506, 176507, 176508, 176509, 176510, 176519, 176523, 176526, 176527, 176528, 176537, 176542, 176544, 176547, 176548, 176549, 176550, 176552, 176553, 176554, 176556, 176557, 176558, 176559, 176560, 176561, 176562, 176563, 176564, 176570, 176574, 176584, 176587, 176594, 176595, 176605, 176606, 176607, 176608, 176611, 176615, 176618, 176625, 176641, 176643, 176647, 176648, 176651, 176654, 176655, 176656, 176657, 176658, 176660, 176663, 176664, 176665, 176666, 176667, 176668, 176669, 176670, 176673, 176674, 176675, 176677, 176679, 176680, 176682, 176683, 176684, 176685, 176686, 176687, 176688, 176689, 176690, 176691, 176692, 176693, 176694, 176695, 176696, 176697, 176698, 176699, 176700, 176702, 176703, 176705, 176706, 176708, 176710, 176711, 176712, 176714, 176715, 176717, 176718, 176719, 176721, 176722, 176725, 176728, 176730, 176731, 176732, 176734, 176735, 176736, 176738, 176740, 176741, 176742, 176743, 176744, 176748, 176749, 176753, 176767, 176768, 176779, 176780, 176786, 176788, 176789, 176790, 176791, 176795, 176798, 176800, 176808, 176820, 176821, 176822, 176825, 176829, 176832, 176836, 176843, 176844, 176851, 176852, 176853, 176854, 176855, 176859, 176860, 176862, 176866, 176867, 176868, 176870, 176871, 176872, 176873, 176876, 176877, 176878, 176879, 176880, 176881, 176882, 176883, 176884, 176885, 176886, 176887, 176889, 176891, 176895, 176896, 176897, 176898, 176900, 176901, 176902, 176903, 176904, 176907, 176908, 176909, 176911, 176912, 176913, 176914, 176916, 176917, 176918, 176919, 176921, 176922, 176923, 176924, 176926, 176928, 176929, 176931, 176933, 176935, 176936, 176938, 176939, 176942, 176943, 176944, 176946, 176948, 176949, 176950, 176951, 176952, 176953, 176954, 176955, 176956, 176958, 176959, 176960, 176961, 176962, 176963, 176964, 176965, 176967, 176972, 176974, 176975, 176976, 176977, 176978, 176979, 176980, 176981, 176982, 176983, 176985, 176986, 176987, 176988, 176990, 176992, 176993, 176994, 176995, 176996, 176997, 176998, 177000, 177002, 177003, 177004, 177005, 177009, 177011, 177012, 177013, 177014, 177015, 177016, 177017, 177018, 177019, 177020, 177021, 177022, 177023, 177026, 177029, 177030, 177031, 177032, 177033, 177034, 177035, 177036, 177038, 177039, 177040, 177041, 177042, 177043, 177044, 177045, 177046, 177047, 177048, 177049, 177051, 177052, 177053, 177055, 177056, 177058, 177059, 177060, 177061, 177062, 177063, 177064, 177065, 177066, 177067, 177068, 177069, 177070, 177071, 177072, 177073, 177074, 177075, 177076, 177077, 177081, 177083, 177084, 177085, 177086, 177087, 177088, 177089, 177090, 177091, 177096, 177097, 177101, 177102, 177103, 177104, 177108, 177112, 177113, 177114, 177115, 177116, 177117, 177118, 177119, 177120, 177121, 177126, 177127, 177130, 177131, 177132, 177133, 177134, 177135, 177138, 177139, 177141, 177143, 177144, 177150, 177151, 177152, 177156, 177157, 177158, 177159, 177160, 177161, 177162, 177167, 177168, 177169, 177170, 177171, 177172, 177175, 177176, 177179, 177180, 177181, 177182, 177183, 177184, 177185, 177186, 177190, 177191, 177194, 177196, 177197, 177198, 177199, 177200, 177203, 177204, 177205, 177206, 177207, 177213, 177214, 177215, 177216, 177218, 177219, 177222, 177225, 177226, 177227, 177228, 177229, 177230, 177231, 177232, 177235, 177236, 177239, 177240, 177241, 177242, 177243, 177244, 177250, 177253, 177254, 177255, 177257, 177258, 177259, 177266, 177275, 177276, 177279, 177280, 177281, 177282, 177283, 177287, 177288, 177289, 177302, 177303, 177316, 177317, 177318, 177322, 177323, 177324, 177325, 177330, 177331, 177332, 177338, 177339, 177343, 177345, 177346, 177347, 177349, 177350, 177351, 177352, 177353, 177354, 177355, 177357, 177358, 177360, 177361, 177362, 177364, 177365, 177366, 177369, 177372, 177373, 177374, 177381, 177382, 177383, 177384, 177388, 177390, 177391, 177392, 177393, 177394, 177398, 177400, 177401, 177402, 177403, 177404, 177405, 177407, 177409, 177411, 177412, 177415, 177416, 177417, 177420, 177421, 177422, 177423, 177424, 177425, 177429, 177431, 177432, 177433, 177436, 177437, 177439, 177440, 177442, 177445, 177446, 177448, 177449, 177450, 177452, 177453, 177454, 177455, 177456, 177457, 177459, 177460, 177464, 177475, 177477, 177478, 177479, 177481, 177484, 177485, 177495, 177496, 177497, 177499, 177502, 177503, 177505, 177508, 177510, 177511, 177512, 177513, 177514, 177515, 177516, 177517, 177521, 177524, 177528, 177529, 177530, 177533, 177534, 177535, 177536, 177537, 177539, 177544, 177545, 177546, 177551, 177554, 177555, 177556, 177557, 177558, 177559, 177562, 177563, 177567, 177568, 177569, 177570, 177571, 177572, 177573, 177574, 177576, 177577, 177578, 177579, 177581, 177583, 177586, 177587, 177592, 177593, 177602, 177603, 177606, 177608, 177609, 177610, 177616, 177617, 177625, 177635, 177636, 177638, 177641, 177642, 177645, 177646, 177648, 177649, 177650, 177658, 177662, 177669, 177672, 177673, 177675, 177676, 177680, 177681, 177683, 177684, 177686, 177695, 177703, 177706, 177707, 177708, 177709, 177712, 177713, 177716, 177717, 177719, 177721, 177722, 177726, 177728, 177729, 177730, 177733, 177735, 177737, 177740, 177741, 177742, 177745, 177749, 177751, 177752, 177753, 177755, 177758, 177769, 177770, 177775, 177777, 177778, 177779, 177780, 177781, 177782, 177787, 177788, 177789, 177793, 177797, 177799, 177801, 177807, 177810, 177820, 177821, 177822, 177823, 177827, 177833, 177834, 177835, 177838, 177839, 177841, 177842, 177843, 177844, 177845, 177846, 177847, 177852, 177853, 177859, 177863, 177865, 177866, 177867, 177868, 177869, 177870, 177873, 177875, 177876, 177877, 177878, 177882, 177886, 177887, 177888, 177902, 177905, 177906, 177910, 177912, 177914, 177915, 177916, 177918, 177919, 177922, 177923, 177927, 177928, 177930, 177933, 177935, 177936, 177937, 177938, 177941, 177943, 177944, 177945, 177946, 177948, 177949, 177953, 177956, 177957, 177958, 177960, 177962, 177965, 177967, 177968, 177969, 177971, 177973, 177974, 177976, 177978, 177979, 177983, 177985, 177986, 177987, 177989, 177990, 177995, 178000, 178002, 178003, 178004, 178008, 178012, 178013, 178019, 178020, 178021, 178024, 178025, 178026, 178027, 178029, 178030, 178031, 178033, 178034, 178036, 178037, 178039, 178040, 178041, 178044, 178046, 178048, 178049, 178050, 178052, 178054, 178061, 178064, 178066, 178067, 178069, 178071, 178072, 178075, 178076, 178077, 178078, 178081, 178085, 178086, 178087, 178093, 178095, 178096, 178097, 178098, 178101, 178102, 178103, 178106, 178107, 178108, 178109, 178111, 178112, 178115, 178116, 178117, 178118, 178119, 178120, 178121, 178122, 178124, 178125, 178127, 178128, 178129, 178134, 178135, 178136, 178137, 178146, 178148, 178150, 178152, 178153, 178154, 178158, 178159, 178165, 178166, 178173, 178174, 178175, 178176, 178177, 178178, 178179, 178180, 178181, 178183, 178186, 178188, 178189, 178192, 178193, 178194, 178195, 178198, 178200, 178201, 178203, 178204, 178206, 178210, 178218, 178219, 178220, 178225, 178228, 178229, 178230, 178231, 178232, 178233, 178234, 178235, 178240, 178241, 178242, 178243, 178248, 178249, 178250, 178251, 178252, 178254, 178255, 178259, 178260, 178262, 178265, 178267, 178268, 178269, 178270, 178271, 178272, 178274, 178276, 178277, 178278, 178279, 178281, 178284, 178285, 178286, 178287, 178288, 178289, 178290, 178291, 178292, 178294, 178296, 178297, 178298, 178299, 178300, 178302, 178303, 178304, 178306, 178308, 178309, 178310, 178317, 178318, 178321, 178322, 178323, 178328, 178330, 178332, 178333, 178336, 178338, 178339, 178342, 178344, 178346, 178348, 178349, 178350, 178353, 178356, 178365, 178372, 178373, 178375, 178376, 178381, 178382, 178383, 178395, 178398, 178399, 178400, 178401, 178402, 178405, 178406, 178410, 178414, 178418, 178420, 178427, 178430, 178432, 178433, 178434, 178435, 178439, 178440, 178441, 178442, 178443, 178444, 178445, 178446, 178453, 178454, 178455, 178456, 178457, 178458, 178459, 178460, 178461, 178462, 178463, 178464, 178465, 178470, 178477, 178480, 178481, 178482, 178484, 178486, 178488, 178491, 178492, 178493, 178496, 178498, 178500, 178502, 178503, 178504, 178507, 178508, 178509, 178510, 178511, 178512, 178513, 178515, 178516, 178517, 178519, 178520, 178521, 178523, 178524, 178525, 178527, 178528, 178529, 178530, 178536, 178537, 178548, 178558, 178561, 178562, 178565, 178567, 178569, 178570, 178571, 178573, 178574, 178577, 178580, 178582, 178584, 178587, 178588, 178589, 178590, 178591, 178593, 178596, 178597, 178598, 178600, 178601, 178603, 178604, 178606, 178607, 178618, 178622, 178623, 178624, 178625, 178627, 178628, 178630, 178631, 178632, 178633, 178634, 178635, 178638, 178639, 178647, 178648, 178649, 178650, 178651, 178652, 178653, 178654, 178655, 178656, 178657, 178658, 178660, 178661, 178662, 178663, 178664, 178665, 178666, 178668, 178670, 178671, 178672, 178673, 178679, 178680, 178685, 178687, 178688, 178689, 178690, 178691, 178693, 178695, 178696, 178697, 178698, 178699, 178700, 178701, 178702, 178703, 178704, 178705, 178707, 178710, 178711, 178718, 178725, 178726, 178727, 178728, 178729, 178730, 178731, 178737, 178738, 178740, 178741, 178742, 178743, 178744, 178746, 178756, 178757, 178758, 178760, 178762, 178764, 178765, 178766, 178769, 178770, 178771, 178772, 178775, 178776, 178779, 178783, 178784, 178785, 178789, 178794, 178797, 178798, 178799, 178800, 178802, 178804, 178806, 178807, 178808, 178809, 178810, 178811, 178814, 178816, 178818, 178821, 178822, 178823, 178824, 178825, 178826, 178828, 178829, 178839, 178842, 178843, 178845, 178847, 178854, 178855, 178860, 178862, 178865, 178867, 178868, 178872, 178874, 178875, 178879, 178881, 178882, 178883, 178884, 178888, 178890, 178891, 178892, 178893, 178894, 178898, 178899, 178900, 178902, 178903, 178905, 178906, 178908, 178912, 178913, 178915, 178916, 178917, 178919, 178922, 178925, 178926, 178930, 178935, 178936, 178937, 178941, 178945, 178946, 178948, 178949, 178950, 178951, 178952, 178953, 178956, 178957, 178968, 178971, 178972, 178973, 178977, 178979, 178980, 178981, 178983, 178984, 178985, 178986, 178989, 178991, 178994, 179000, 179014, 179019, 179023, 179024, 179027, 179028, 179030, 179031, 179032, 179039, 179040, 179046, 179049, 179050, 179054, 179059, 179060, 179061, 179062, 179063, 179064, 179065, 179066, 179067, 179068, 179069, 179070, 179071, 179072, 179073, 179074, 179075, 179076, 179082, 179083, 179084, 179085, 179086, 179087, 179092, 179095, 179096, 179097, 179099, 179103, 179106, 179107, 179109, 179111, 179114, 179116, 179120, 179121, 179122, 179123, 179124, 179126, 179127, 179128, 179129, 179130, 179131, 179132, 179133, 179135, 179139, 179141, 179143, 179144, 179145, 179148, 179149, 179150, 179151, 179156, 179157, 179158, 179159, 179166, 179167, 179173, 179177, 179178, 179179, 179181, 179182, 179183, 179184, 179186, 179187, 179189, 179190, 179192, 179193, 179198, 179199, 179200, 179201, 179202, 179204, 179205, 179206, 179207, 179208, 179210, 179212, 179214, 179221, 179224, 179225, 179226, 179230, 179231, 179232, 179233, 179234, 179235, 179239, 179240, 179242, 179243, 179246, 179250, 179251, 179252, 179254, 179257, 179259, 179261, 179265, 179267, 179269, 179270, 179271, 179272, 179273, 179274, 179275, 179276, 179277, 179278, 179279, 179284, 179285, 179286, 179287, 179289, 179291, 179292, 179294, 179295, 179296, 179298, 179301, 179305, 179306, 179307, 179309, 179313, 179314, 179315, 179316, 179317, 179319, 179320, 179321, 179322, 179323, 179324, 179327, 179328, 179329, 179330, 179331, 179334, 179335, 179336, 179337, 179338, 179339, 179340, 179341, 179342, 179343, 179344, 179346, 179347, 179348, 179349, 179350, 179353, 179354, 179355, 179362, 179363, 179366, 179367, 179368, 179369, 179371, 179372, 179374, 179377, 179378, 179379, 179381, 179382, 179383, 179384, 179386, 179387, 179389, 179390, 179392, 179394, 179395, 179396, 179398, 179399, 179401, 179402, 179404, 179405, 179406, 179407, 179408, 179409, 179412, 179414, 179415, 179416, 179417, 179419, 179420, 179424, 179425, 179426, 179427, 179433, 179438, 179439, 179445, 179447, 179449, 179453, 179454, 179455, 179456, 179457, 179459, 179463, 179467, 179468, 179469, 179470, 179471, 179475, 179476, 179477, 179479, 179488, 179489, 179496, 179500, 179501, 179502, 179503, 179504, 179505, 179508, 179518, 179545, 179546, 179548, 179549, 179550, 179551, 179553, 179557, 179558, 179562, 179565, 179572, 179573, 179574, 179580, 179581, 179582, 179583, 179584, 179585, 179586, 179587, 179588, 179591, 179592, 179594, 179595, 179597, 179603, 179606, 179608, 179609, 179614, 179619, 179620, 179621, 179627, 179628, 179630, 179631, 179632, 179633, 179634, 179635, 179636, 179638, 179640, 179644, 179647, 179648, 179650, 179651, 179653, 179654, 179655, 179656, 179657, 179658, 179659, 179660, 179661, 179663, 179665, 179668, 179671, 179673, 179677, 179678, 179681, 179682, 179683, 179684, 179685, 179687, 179689, 179690, 179693, 179696, 179697, 179699, 179700, 179701, 179702, 179703, 179705, 179706, 179708, 179711, 179713, 179717, 179719, 179722, 179727, 179728, 179732, 179734, 179735, 179736, 179737, 179738, 179740, 179742, 179743, 179744, 179745, 179746, 179747, 179748, 179751, 179752, 179754, 179755, 179758, 179760, 179761, 179763, 179764, 179765, 179766, 179767, 179770, 179773, 179774, 179775, 179778, 179779, 179780, 179783, 179785, 179786, 179788, 179789, 179790, 179791, 179794, 179795, 179796, 179803, 179805, 179806, 179808, 179809, 179811, 179815, 179821, 179822, 179823, 179826, 179832, 179836, 179837, 179838, 179839, 179840, 179841, 179843, 179844, 179847, 179851, 179852, 179853, 179856, 179857, 179858, 179865, 179866, 179869, 179874, 179876, 179881, 179885, 179887, 179888, 179892, 179894, 179898, 179902, 179906, 179907, 179911, 179912, 179918, 179920, 179921, 179922, 179923, 179924, 179926, 179928, 179935, 179941, 179943, 179945, 179947, 179961, 179962, 179964, 179967, 179970, 179971, 179973, 179974, 179983, 179994, 179995, 179996, 180000, 180001, 180003, 180004, 180005, 180006, 180010, 180014, 180018, 180019, 180022, 205332, 210273, 210632, 216371, 216373, 216375, 216377, 216393, 216397, 216406, 216408, 216422, 216450, 216459, 216460, 216464, 216469, 216474, 216475, 216477, 216478, 216479, 216493, 216503, 216507, 216520, 216522, 216523, 216524, 216525, 216544, 216552, 216571, 216592, 216593, 216594, 216601, 216605, 216606, 216610, 216633, 216653, 216658, 216678, 216688, 216689, 216690, 216691, 216693, 216710)) AND (t_d.attribute_id IN ('506')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_product_entity_int` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (e.entity_id IN (174682, 174683, 174684, 174685, 174686, 174688, 175412, 175413, 175414, 175415, 175418, 175419, 175420, 175421, 175423, 175424, 175427, 175430, 175438, 175441, 175447, 175448, 175449, 175450, 175451, 175453, 175461, 175465, 175470, 175472, 175473, 175475, 175476, 175480, 175481, 175485, 175486, 175487, 175490, 175500, 175501, 175503, 175512, 175515, 175516, 175517, 175519, 175521, 175524, 175525, 175526, 175529, 175538, 175541, 175543, 175546, 175547, 175548, 175552, 175557, 175559, 175560, 175563, 175566, 175567, 175568, 175570, 175572, 175575, 175576, 175578, 175586, 175587, 175590, 175591, 175592, 175594, 175597, 175599, 175600, 175601, 175602, 175603, 175605, 175606, 175611, 175612, 175616, 175618, 175619, 175629, 175631, 175632, 175635, 175641, 175644, 175647, 175649, 175653, 175656, 175659, 175660, 175670, 175672, 175674, 175675, 175676, 175678, 175681, 175683, 175685, 175689, 175690, 175692, 175695, 175698, 175699, 175700, 175703, 175704, 175705, 175706, 175707, 175708, 175709, 175710, 175711, 175712, 175713, 175714, 175715, 175718, 175721, 175722, 175723, 175724, 175725, 175727, 175728, 175729, 175730, 175731, 175732, 175734, 175735, 175736, 175737, 175739, 175740, 175742, 175744, 175745, 175746, 175747, 175748, 175749, 175750, 175751, 175752, 175753, 175754, 175755, 175756, 175757, 175759, 175760, 175761, 175762, 175763, 175765, 175766, 175767, 175768, 175769, 175770, 175771, 175772, 175773, 175775, 175776, 175777, 175779, 175780, 175781, 175782, 175783, 175784, 175785, 175791, 175792, 175793, 175795, 175796, 175797, 175808, 175810, 175811, 175812, 175815, 175820, 175823, 175824, 175825, 175826, 175828, 175829, 175830, 175831, 175832, 175837, 175845, 175848, 175851, 175852, 175853, 175854, 175855, 175856, 175857, 175858, 175859, 175860, 175861, 175862, 175863, 175868, 175870, 175872, 175874, 175875, 175876, 175877, 175878, 175880, 175881, 175882, 175883, 175884, 175885, 175887, 175889, 175890, 175891, 175892, 175893, 175894, 175895, 175896, 175897, 175898, 175899, 175900, 175902, 175903, 175904, 175905, 175906, 175907, 175908, 175909, 175910, 175911, 175912, 175913, 175914, 175915, 175916, 175917, 175919, 175920, 175922, 175923, 175926, 175927, 175928, 175929, 175930, 175933, 175937, 175938, 175941, 175942, 175943, 175946, 175949, 175950, 175952, 175953, 175955, 175956, 175959, 175960, 175961, 175962, 175963, 175965, 175966, 175967, 175968, 175969, 175972, 175973, 175974, 175977, 175979, 175981, 175983, 175984, 175985, 175986, 175988, 175990, 175991, 175994, 175998, 175999, 176000, 176001, 176002, 176003, 176007, 176008, 176013, 176014, 176015, 176021, 176022, 176023, 176024, 176025, 176026, 176027, 176028, 176030, 176031, 176032, 176033, 176034, 176035, 176036, 176037, 176038, 176041, 176042, 176045, 176046, 176051, 176052, 176062, 176063, 176065, 176066, 176067, 176068, 176071, 176072, 176073, 176078, 176080, 176081, 176083, 176084, 176085, 176086, 176087, 176088, 176089, 176091, 176092, 176093, 176094, 176095, 176096, 176099, 176100, 176101, 176103, 176104, 176105, 176106, 176107, 176108, 176109, 176110, 176111, 176112, 176113, 176115, 176116, 176117, 176118, 176119, 176120, 176121, 176123, 176124, 176125, 176126, 176127, 176128, 176129, 176130, 176131, 176132, 176133, 176134, 176135, 176136, 176139, 176140, 176141, 176143, 176146, 176148, 176149, 176150, 176151, 176152, 176155, 176156, 176157, 176158, 176159, 176160, 176161, 176162, 176163, 176164, 176165, 176166, 176167, 176168, 176169, 176171, 176172, 176173, 176174, 176175, 176176, 176177, 176178, 176180, 176181, 176182, 176183, 176184, 176185, 176187, 176188, 176189, 176190, 176191, 176192, 176196, 176199, 176200, 176201, 176202, 176203, 176204, 176205, 176208, 176210, 176213, 176214, 176215, 176216, 176217, 176218, 176219, 176220, 176221, 176222, 176224, 176225, 176226, 176227, 176228, 176229, 176230, 176231, 176232, 176233, 176236, 176237, 176238, 176239, 176240, 176241, 176242, 176243, 176244, 176245, 176246, 176248, 176249, 176251, 176252, 176254, 176258, 176259, 176261, 176262, 176263, 176264, 176265, 176266, 176267, 176268, 176269, 176270, 176271, 176272, 176274, 176276, 176277, 176278, 176279, 176280, 176283, 176285, 176286, 176287, 176288, 176289, 176291, 176292, 176294, 176295, 176296, 176297, 176298, 176299, 176300, 176302, 176303, 176306, 176307, 176308, 176309, 176310, 176311, 176312, 176313, 176315, 176316, 176317, 176318, 176320, 176321, 176322, 176323, 176325, 176326, 176327, 176328, 176331, 176332, 176333, 176335, 176337, 176338, 176339, 176340, 176341, 176342, 176343, 176344, 176345, 176346, 176347, 176348, 176349, 176350, 176351, 176352, 176353, 176354, 176355, 176356, 176357, 176361, 176362, 176366, 176367, 176370, 176371, 176372, 176373, 176374, 176375, 176390, 176391, 176392, 176393, 176394, 176395, 176396, 176400, 176402, 176403, 176404, 176406, 176408, 176409, 176410, 176411, 176413, 176414, 176415, 176416, 176417, 176418, 176419, 176420, 176428, 176429, 176433, 176435, 176436, 176437, 176438, 176439, 176440, 176441, 176442, 176443, 176444, 176445, 176447, 176449, 176450, 176453, 176455, 176456, 176457, 176458, 176460, 176464, 176465, 176466, 176467, 176471, 176472, 176474, 176475, 176476, 176477, 176478, 176479, 176480, 176482, 176483, 176484, 176485, 176486, 176487, 176488, 176489, 176490, 176491, 176492, 176493, 176494, 176495, 176496, 176497, 176498, 176499, 176500, 176501, 176504, 176505, 176506, 176507, 176508, 176509, 176510, 176519, 176523, 176526, 176527, 176528, 176537, 176542, 176544, 176547, 176548, 176549, 176550, 176552, 176553, 176554, 176556, 176557, 176558, 176559, 176560, 176561, 176562, 176563, 176564, 176570, 176574, 176584, 176587, 176594, 176595, 176605, 176606, 176607, 176608, 176611, 176615, 176618, 176625, 176641, 176643, 176647, 176648, 176651, 176654, 176655, 176656, 176657, 176658, 176660, 176663, 176664, 176665, 176666, 176667, 176668, 176669, 176670, 176673, 176674, 176675, 176677, 176679, 176680, 176682, 176683, 176684, 176685, 176686, 176687, 176688, 176689, 176690, 176691, 176692, 176693, 176694, 176695, 176696, 176697, 176698, 176699, 176700, 176702, 176703, 176705, 176706, 176708, 176710, 176711, 176712, 176714, 176715, 176717, 176718, 176719, 176721, 176722, 176725, 176728, 176730, 176731, 176732, 176734, 176735, 176736, 176738, 176740, 176741, 176742, 176743, 176744, 176748, 176749, 176753, 176767, 176768, 176779, 176780, 176786, 176788, 176789, 176790, 176791, 176795, 176798, 176800, 176808, 176820, 176821, 176822, 176825, 176829, 176832, 176836, 176843, 176844, 176851, 176852, 176853, 176854, 176855, 176859, 176860, 176862, 176866, 176867, 176868, 176870, 176871, 176872, 176873, 176876, 176877, 176878, 176879, 176880, 176881, 176882, 176883, 176884, 176885, 176886, 176887, 176889, 176891, 176895, 176896, 176897, 176898, 176900, 176901, 176902, 176903, 176904, 176907, 176908, 176909, 176911, 176912, 176913, 176914, 176916, 176917, 176918, 176919, 176921, 176922, 176923, 176924, 176926, 176928, 176929, 176931, 176933, 176935, 176936, 176938, 176939, 176942, 176943, 176944, 176946, 176948, 176949, 176950, 176951, 176952, 176953, 176954, 176955, 176956, 176958, 176959, 176960, 176961, 176962, 176963, 176964, 176965, 176967, 176972, 176974, 176975, 176976, 176977, 176978, 176979, 176980, 176981, 176982, 176983, 176985, 176986, 176987, 176988, 176990, 176992, 176993, 176994, 176995, 176996, 176997, 176998, 177000, 177002, 177003, 177004, 177005, 177009, 177011, 177012, 177013, 177014, 177015, 177016, 177017, 177018, 177019, 177020, 177021, 177022, 177023, 177026, 177029, 177030, 177031, 177032, 177033, 177034, 177035, 177036, 177038, 177039, 177040, 177041, 177042, 177043, 177044, 177045, 177046, 177047, 177048, 177049, 177051, 177052, 177053, 177055, 177056, 177058, 177059, 177060, 177061, 177062, 177063, 177064, 177065, 177066, 177067, 177068, 177069, 177070, 177071, 177072, 177073, 177074, 177075, 177076, 177077, 177081, 177083, 177084, 177085, 177086, 177087, 177088, 177089, 177090, 177091, 177096, 177097, 177101, 177102, 177103, 177104, 177108, 177112, 177113, 177114, 177115, 177116, 177117, 177118, 177119, 177120, 177121, 177126, 177127, 177130, 177131, 177132, 177133, 177134, 177135, 177138, 177139, 177141, 177143, 177144, 177150, 177151, 177152, 177156, 177157, 177158, 177159, 177160, 177161, 177162, 177167, 177168, 177169, 177170, 177171, 177172, 177175, 177176, 177179, 177180, 177181, 177182, 177183, 177184, 177185, 177186, 177190, 177191, 177194, 177196, 177197, 177198, 177199, 177200, 177203, 177204, 177205, 177206, 177207, 177213, 177214, 177215, 177216, 177218, 177219, 177222, 177225, 177226, 177227, 177228, 177229, 177230, 177231, 177232, 177235, 177236, 177239, 177240, 177241, 177242, 177243, 177244, 177250, 177253, 177254, 177255, 177257, 177258, 177259, 177266, 177275, 177276, 177279, 177280, 177281, 177282, 177283, 177287, 177288, 177289, 177302, 177303, 177316, 177317, 177318, 177322, 177323, 177324, 177325, 177330, 177331, 177332, 177338, 177339, 177343, 177345, 177346, 177347, 177349, 177350, 177351, 177352, 177353, 177354, 177355, 177357, 177358, 177360, 177361, 177362, 177364, 177365, 177366, 177369, 177372, 177373, 177374, 177381, 177382, 177383, 177384, 177388, 177390, 177391, 177392, 177393, 177394, 177398, 177400, 177401, 177402, 177403, 177404, 177405, 177407, 177409, 177411, 177412, 177415, 177416, 177417, 177420, 177421, 177422, 177423, 177424, 177425, 177429, 177431, 177432, 177433, 177436, 177437, 177439, 177440, 177442, 177445, 177446, 177448, 177449, 177450, 177452, 177453, 177454, 177455, 177456, 177457, 177459, 177460, 177464, 177475, 177477, 177478, 177479, 177481, 177484, 177485, 177495, 177496, 177497, 177499, 177502, 177503, 177505, 177508, 177510, 177511, 177512, 177513, 177514, 177515, 177516, 177517, 177521, 177524, 177528, 177529, 177530, 177533, 177534, 177535, 177536, 177537, 177539, 177544, 177545, 177546, 177551, 177554, 177555, 177556, 177557, 177558, 177559, 177562, 177563, 177567, 177568, 177569, 177570, 177571, 177572, 177573, 177574, 177576, 177577, 177578, 177579, 177581, 177583, 177586, 177587, 177592, 177593, 177602, 177603, 177606, 177608, 177609, 177610, 177616, 177617, 177625, 177635, 177636, 177638, 177641, 177642, 177645, 177646, 177648, 177649, 177650, 177658, 177662, 177669, 177672, 177673, 177675, 177676, 177680, 177681, 177683, 177684, 177686, 177695, 177703, 177706, 177707, 177708, 177709, 177712, 177713, 177716, 177717, 177719, 177721, 177722, 177726, 177728, 177729, 177730, 177733, 177735, 177737, 177740, 177741, 177742, 177745, 177749, 177751, 177752, 177753, 177755, 177758, 177769, 177770, 177775, 177777, 177778, 177779, 177780, 177781, 177782, 177787, 177788, 177789, 177793, 177797, 177799, 177801, 177807, 177810, 177820, 177821, 177822, 177823, 177827, 177833, 177834, 177835, 177838, 177839, 177841, 177842, 177843, 177844, 177845, 177846, 177847, 177852, 177853, 177859, 177863, 177865, 177866, 177867, 177868, 177869, 177870, 177873, 177875, 177876, 177877, 177878, 177882, 177886, 177887, 177888, 177902, 177905, 177906, 177910, 177912, 177914, 177915, 177916, 177918, 177919, 177922, 177923, 177927, 177928, 177930, 177933, 177935, 177936, 177937, 177938, 177941, 177943, 177944, 177945, 177946, 177948, 177949, 177953, 177956, 177957, 177958, 177960, 177962, 177965, 177967, 177968, 177969, 177971, 177973, 177974, 177976, 177978, 177979, 177983, 177985, 177986, 177987, 177989, 177990, 177995, 178000, 178002, 178003, 178004, 178008, 178012, 178013, 178019, 178020, 178021, 178024, 178025, 178026, 178027, 178029, 178030, 178031, 178033, 178034, 178036, 178037, 178039, 178040, 178041, 178044, 178046, 178048, 178049, 178050, 178052, 178054, 178061, 178064, 178066, 178067, 178069, 178071, 178072, 178075, 178076, 178077, 178078, 178081, 178085, 178086, 178087, 178093, 178095, 178096, 178097, 178098, 178101, 178102, 178103, 178106, 178107, 178108, 178109, 178111, 178112, 178115, 178116, 178117, 178118, 178119, 178120, 178121, 178122, 178124, 178125, 178127, 178128, 178129, 178134, 178135, 178136, 178137, 178146, 178148, 178150, 178152, 178153, 178154, 178158, 178159, 178165, 178166, 178173, 178174, 178175, 178176, 178177, 178178, 178179, 178180, 178181, 178183, 178186, 178188, 178189, 178192, 178193, 178194, 178195, 178198, 178200, 178201, 178203, 178204, 178206, 178210, 178218, 178219, 178220, 178225, 178228, 178229, 178230, 178231, 178232, 178233, 178234, 178235, 178240, 178241, 178242, 178243, 178248, 178249, 178250, 178251, 178252, 178254, 178255, 178259, 178260, 178262, 178265, 178267, 178268, 178269, 178270, 178271, 178272, 178274, 178276, 178277, 178278, 178279, 178281, 178284, 178285, 178286, 178287, 178288, 178289, 178290, 178291, 178292, 178294, 178296, 178297, 178298, 178299, 178300, 178302, 178303, 178304, 178306, 178308, 178309, 178310, 178317, 178318, 178321, 178322, 178323, 178328, 178330, 178332, 178333, 178336, 178338, 178339, 178342, 178344, 178346, 178348, 178349, 178350, 178353, 178356, 178365, 178372, 178373, 178375, 178376, 178381, 178382, 178383, 178395, 178398, 178399, 178400, 178401, 178402, 178405, 178406, 178410, 178414, 178418, 178420, 178427, 178430, 178432, 178433, 178434, 178435, 178439, 178440, 178441, 178442, 178443, 178444, 178445, 178446, 178453, 178454, 178455, 178456, 178457, 178458, 178459, 178460, 178461, 178462, 178463, 178464, 178465, 178470, 178477, 178480, 178481, 178482, 178484, 178486, 178488, 178491, 178492, 178493, 178496, 178498, 178500, 178502, 178503, 178504, 178507, 178508, 178509, 178510, 178511, 178512, 178513, 178515, 178516, 178517, 178519, 178520, 178521, 178523, 178524, 178525, 178527, 178528, 178529, 178530, 178536, 178537, 178548, 178558, 178561, 178562, 178565, 178567, 178569, 178570, 178571, 178573, 178574, 178577, 178580, 178582, 178584, 178587, 178588, 178589, 178590, 178591, 178593, 178596, 178597, 178598, 178600, 178601, 178603, 178604, 178606, 178607, 178618, 178622, 178623, 178624, 178625, 178627, 178628, 178630, 178631, 178632, 178633, 178634, 178635, 178638, 178639, 178647, 178648, 178649, 178650, 178651, 178652, 178653, 178654, 178655, 178656, 178657, 178658, 178660, 178661, 178662, 178663, 178664, 178665, 178666, 178668, 178670, 178671, 178672, 178673, 178679, 178680, 178685, 178687, 178688, 178689, 178690, 178691, 178693, 178695, 178696, 178697, 178698, 178699, 178700, 178701, 178702, 178703, 178704, 178705, 178707, 178710, 178711, 178718, 178725, 178726, 178727, 178728, 178729, 178730, 178731, 178737, 178738, 178740, 178741, 178742, 178743, 178744, 178746, 178756, 178757, 178758, 178760, 178762, 178764, 178765, 178766, 178769, 178770, 178771, 178772, 178775, 178776, 178779, 178783, 178784, 178785, 178789, 178794, 178797, 178798, 178799, 178800, 178802, 178804, 178806, 178807, 178808, 178809, 178810, 178811, 178814, 178816, 178818, 178821, 178822, 178823, 178824, 178825, 178826, 178828, 178829, 178839, 178842, 178843, 178845, 178847, 178854, 178855, 178860, 178862, 178865, 178867, 178868, 178872, 178874, 178875, 178879, 178881, 178882, 178883, 178884, 178888, 178890, 178891, 178892, 178893, 178894, 178898, 178899, 178900, 178902, 178903, 178905, 178906, 178908, 178912, 178913, 178915, 178916, 178917, 178919, 178922, 178925, 178926, 178930, 178935, 178936, 178937, 178941, 178945, 178946, 178948, 178949, 178950, 178951, 178952, 178953, 178956, 178957, 178968, 178971, 178972, 178973, 178977, 178979, 178980, 178981, 178983, 178984, 178985, 178986, 178989, 178991, 178994, 179000, 179014, 179019, 179023, 179024, 179027, 179028, 179030, 179031, 179032, 179039, 179040, 179046, 179049, 179050, 179054, 179059, 179060, 179061, 179062, 179063, 179064, 179065, 179066, 179067, 179068, 179069, 179070, 179071, 179072, 179073, 179074, 179075, 179076, 179082, 179083, 179084, 179085, 179086, 179087, 179092, 179095, 179096, 179097, 179099, 179103, 179106, 179107, 179109, 179111, 179114, 179116, 179120, 179121, 179122, 179123, 179124, 179126, 179127, 179128, 179129, 179130, 179131, 179132, 179133, 179135, 179139, 179141, 179143, 179144, 179145, 179148, 179149, 179150, 179151, 179156, 179157, 179158, 179159, 179166, 179167, 179173, 179177, 179178, 179179, 179181, 179182, 179183, 179184, 179186, 179187, 179189, 179190, 179192, 179193, 179198, 179199, 179200, 179201, 179202, 179204, 179205, 179206, 179207, 179208, 179210, 179212, 179214, 179221, 179224, 179225, 179226, 179230, 179231, 179232, 179233, 179234, 179235, 179239, 179240, 179242, 179243, 179246, 179250, 179251, 179252, 179254, 179257, 179259, 179261, 179265, 179267, 179269, 179270, 179271, 179272, 179273, 179274, 179275, 179276, 179277, 179278, 179279, 179284, 179285, 179286, 179287, 179289, 179291, 179292, 179294, 179295, 179296, 179298, 179301, 179305, 179306, 179307, 179309, 179313, 179314, 179315, 179316, 179317, 179319, 179320, 179321, 179322, 179323, 179324, 179327, 179328, 179329, 179330, 179331, 179334, 179335, 179336, 179337, 179338, 179339, 179340, 179341, 179342, 179343, 179344, 179346, 179347, 179348, 179349, 179350, 179353, 179354, 179355, 179362, 179363, 179366, 179367, 179368, 179369, 179371, 179372, 179374, 179377, 179378, 179379, 179381, 179382, 179383, 179384, 179386, 179387, 179389, 179390, 179392, 179394, 179395, 179396, 179398, 179399, 179401, 179402, 179404, 179405, 179406, 179407, 179408, 179409, 179412, 179414, 179415, 179416, 179417, 179419, 179420, 179424, 179425, 179426, 179427, 179433, 179438, 179439, 179445, 179447, 179449, 179453, 179454, 179455, 179456, 179457, 179459, 179463, 179467, 179468, 179469, 179470, 179471, 179475, 179476, 179477, 179479, 179488, 179489, 179496, 179500, 179501, 179502, 179503, 179504, 179505, 179508, 179518, 179545, 179546, 179548, 179549, 179550, 179551, 179553, 179557, 179558, 179562, 179565, 179572, 179573, 179574, 179580, 179581, 179582, 179583, 179584, 179585, 179586, 179587, 179588, 179591, 179592, 179594, 179595, 179597, 179603, 179606, 179608, 179609, 179614, 179619, 179620, 179621, 179627, 179628, 179630, 179631, 179632, 179633, 179634, 179635, 179636, 179638, 179640, 179644, 179647, 179648, 179650, 179651, 179653, 179654, 179655, 179656, 179657, 179658, 179659, 179660, 179661, 179663, 179665, 179668, 179671, 179673, 179677, 179678, 179681, 179682, 179683, 179684, 179685, 179687, 179689, 179690, 179693, 179696, 179697, 179699, 179700, 179701, 179702, 179703, 179705, 179706, 179708, 179711, 179713, 179717, 179719, 179722, 179727, 179728, 179732, 179734, 179735, 179736, 179737, 179738, 179740, 179742, 179743, 179744, 179745, 179746, 179747, 179748, 179751, 179752, 179754, 179755, 179758, 179760, 179761, 179763, 179764, 179765, 179766, 179767, 179770, 179773, 179774, 179775, 179778, 179779, 179780, 179783, 179785, 179786, 179788, 179789, 179790, 179791, 179794, 179795, 179796, 179803, 179805, 179806, 179808, 179809, 179811, 179815, 179821, 179822, 179823, 179826, 179832, 179836, 179837, 179838, 179839, 179840, 179841, 179843, 179844, 179847, 179851, 179852, 179853, 179856, 179857, 179858, 179865, 179866, 179869, 179874, 179876, 179881, 179885, 179887, 179888, 179892, 179894, 179898, 179902, 179906, 179907, 179911, 179912, 179918, 179920, 179921, 179922, 179923, 179924, 179926, 179928, 179935, 179941, 179943, 179945, 179947, 179961, 179962, 179964, 179967, 179970, 179971, 179973, 179974, 179983, 179994, 179995, 179996, 180000, 180001, 180003, 180004, 180005, 180006, 180010, 180014, 180018, 180019, 180022, 205332, 210273, 210632, 216371, 216373, 216375, 216377, 216393, 216397, 216406, 216408, 216422, 216450, 216459, 216460, 216464, 216469, 216474, 216475, 216477, 216478, 216479, 216493, 216503, 216507, 216520, 216522, 216523, 216524, 216525, 216544, 216552, 216571, 216592, 216593, 216594, 216601, 216605, 216606, 216610, 216633, 216653, 216658, 216678, 216688, 216689, 216690, 216691, 216693, 216710)) AND (t_d.attribute_id IN ('996')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))