Cart

Mini Cart

Now Shopping by
Color: Mustard
Color: Orange
Color: Violet
Color: Royal Blue
Color: Multicolor
Color: Cream
Color: Purple
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 (294653, 294550, 294531, 294498, 294411, 293965, 293961, 293926, 293924, 293913, 293734, 293732, 293723, 293638, 293348, 293342, 293321, 293317, 293316, 293314, 293304, 293299, 293268, 293267, 293257, 293256, 293240, 293231, 293230, 293214, 293210, 293205, 293020, 292830, 292813, 292480, 292468, 292434, 292424, 292408, 291524, 290731, 290711, 290691, 290690, 290688, 290453, 290451, 290353, 290352, 290347, 290324, 290293, 290266, 289765, 289742, 289720, 289717, 289713, 289710, 289708, 289698, 289697, 289696, 289690, 289653, 289648, 289634, 289605, 289597, 289591, 289587, 289585, 289569, 289561, 289560, 289230, 288532, 288528, 288495, 288485, 288441, 288423, 288421, 288419, 288393, 288380, 287999, 287975, 287803, 287785, 287763, 287663, 287565, 286946, 286917, 286910, 286906, 286633, 286620, 285693, 285692, 285669, 285632, 285628, 285621, 285604, 285601, 285570, 285569, 285568, 285567, 285506, 285467, 285465, 285451, 285429, 285389, 285360, 285302, 285290, 283718, 283709, 283696, 283645, 283639, 283637, 283620, 283617, 283520, 283518, 283493, 283491, 283490, 283483, 283479, 283455, 283135, 283104, 282945, 282840, 282809, 282807, 282788, 282713, 282651, 282612, 282579, 282546, 282445, 282398, 282377, 282371, 282125, 281633, 281631, 281620, 281609, 281585, 281584, 281558, 281551, 281550, 281549, 281536, 281490, 281093, 281090, 281060, 281055, 281033, 280054, 279774, 279748, 279698, 279693, 279264, 279261, 277710, 277709, 277708, 277697, 277696, 277679, 277661, 274773, 274654, 274597, 274395, 274381, 274222, 274216, 274202, 274201, 273992, 273928, 273873, 273683, 273672, 273671, 273670, 273669, 273648, 273647, 273630, 273625, 273619, 273607, 273589, 273587, 273583, 273543, 273492, 273490, 273416, 272858, 272757, 272509, 272429, 272421, 272407, 272390, 272387, 272383, 272289, 272236, 272235, 272231, 272205, 272197, 272171, 272092, 272051, 272017, 271941, 271921, 271838, 271767, 271647, 271639, 271627, 271606, 271583, 271564, 271272, 271265, 270797, 270782, 270622, 270190, 270177, 270176, 270093, 270073, 269696, 269126, 269007, 268738, 268672, 268658, 268483, 268467, 268195, 266557, 265342, 263167, 262610, 262034, 259376, 259008, 258785, 257369, 256873, 256229, 254513, 254309, 253901, 252240, 251597, 251464, 251447, 250731, 250545, 250539, 250534, 249980, 249452, 249302, 248544, 247354, 246887, 245050, 244916, 243533, 241527, 235133, 229589, 220050, 210388)) AND (t_d.attribute_id IN ('71', '86', '87', '97', '112', '113', '114', '119', '453', '463', '465', '471')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))