Cart

Mini Cart

Now Shopping by
Color: Mustard
Color: Orange
Color: Black
Color: Green
Color: Sandal
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 (294972, 294665, 294634, 294590, 294550, 294549, 294548, 294531, 294511, 294467, 294429, 293981, 293956, 293925, 293742, 293737, 293732, 293723, 293722, 293720, 293718, 293640, 293637, 293636, 293344, 293342, 293338, 293330, 293325, 293322, 293308, 293300, 293266, 293256, 293255, 293248, 293240, 293218, 293208, 293020, 292858, 292831, 292830, 292823, 292813, 292481, 292476, 292465, 292456, 292455, 292445, 292436, 292435, 292434, 292426, 292423, 292397, 292395, 292391, 291527, 291526, 291524, 290847, 290691, 290689, 290688, 290687, 290677, 290460, 290459, 290452, 290407, 290389, 290387, 290354, 290352, 290344, 290292, 290272, 289857, 289765, 289761, 289752, 289742, 289741, 289731, 289720, 289714, 289710, 289705, 289698, 289697, 289696, 289690, 289687, 289648, 289612, 289605, 289588, 289575, 289568, 289562, 289560, 289559, 289558, 289547, 289545, 289262, 289157, 289049, 289044, 288546, 288542, 288529, 288528, 288509, 288501, 288495, 288435, 288419, 288396, 288393, 288349, 288333, 288267, 288071, 288037, 288036, 287975, 287885, 287884, 287866, 287829, 287785, 287763, 287723, 287700, 287663, 287593, 287566, 287537, 287536, 287269, 287266, 287246, 287163, 286950, 286936, 286923, 286917, 286915, 286914, 286911, 286908, 286906, 286900, 286899, 286895, 286813, 286750, 286717, 286657, 286633, 286317, 286289, 285669, 285629, 285603, 285589, 285571, 285566, 285469, 285467, 285453, 285389, 285383, 285360, 285290, 285261, 285248, 285247, 284563, 283699, 283665, 283660, 283649, 283644, 283641, 283637, 283636, 283633, 283631, 283621, 283617, 283609, 283597, 283570, 283564, 283541, 283538, 283525, 283518, 283493, 283484, 283456, 283455, 283444, 283135, 283123, 283104, 283070, 282945, 282857, 282824, 282817, 282808, 282788, 282713, 282669, 282651, 282599, 282579, 282562, 282399, 282398, 282395, 282377, 282375, 282371, 282125, 282103, 282075, 281619, 281608, 281529, 281163, 281132, 281125, 281123, 281089, 281070, 281055, 281053, 281040, 281036, 281033, 279752, 279749, 279748, 279712, 279642, 279359, 279305, 279286, 279264, 279262, 279261, 279189, 277954, 277953, 277896, 277589, 274815, 274774, 274709, 274641, 274601, 274598, 274389, 274387, 274359, 274355, 274269, 273972, 273928, 273872, 273843, 273842, 273663, 273656, 273596, 273591, 273588, 273586, 273582, 273560, 273490, 273489, 273400, 273383, 272905, 272809, 272807, 272689, 272372, 272260, 272230, 272205, 271896, 271874)) 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))