Cart

Mini Cart

Now Shopping by
Color: Mustard
Color: Orange
Color: Red
Color: Royal Blue
Color: Maroon
Color: Green
Color: Brown
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 (294972, 294665, 294634, 294590, 294550, 294549, 294548, 294531, 294511, 294496, 294467, 294429, 294373, 293980, 293979, 293965, 293956, 293925, 293742, 293737, 293732, 293729, 293723, 293722, 293720, 293640, 293637, 293636, 293348, 293344, 293342, 293338, 293330, 293329, 293325, 293308, 293300, 293266, 293256, 293255, 293248, 293240, 293218, 293208, 293020, 292858, 292830, 292823, 292813, 292481, 292476, 292465, 292456, 292455, 292445, 292439, 292435, 292434, 292427, 292426, 292423, 292409, 292407, 292404, 292397, 292395, 292391, 292390, 291530, 291529, 291527, 291526, 291525, 291524, 290847, 290709, 290691, 290689, 290688, 290687, 290677, 290460, 290459, 290452, 290407, 290389, 290387, 290354, 290352, 290351, 290346, 290344, 290325, 290320, 290292, 290272, 290266, 289931, 289857, 289808, 289765, 289761, 289756, 289752, 289742, 289741, 289736, 289735, 289733, 289731, 289720, 289717, 289714, 289710, 289709, 289708, 289705, 289698, 289697, 289696, 289691, 289690, 289689, 289687, 289681, 289675, 289665, 289648, 289612, 289605, 289588, 289575, 289568, 289562, 289560, 289559, 289558, 289548, 289547, 289545, 289262, 289230, 289194, 289157, 289156, 289154, 289150, 289115, 289049, 289044, 288549, 288546, 288544, 288542, 288532, 288529, 288528, 288509, 288501, 288495, 288482, 288481, 288435, 288426, 288423, 288419, 288396, 288393, 288349, 288267, 288071, 288037, 288036, 287975, 287885, 287884, 287866, 287830, 287829, 287785, 287763, 287732, 287726, 287723, 287700, 287663, 287657, 287633, 287593, 287566, 287537, 287536, 287266, 287246, 287163, 286950, 286945, 286936, 286920, 286917, 286916, 286915, 286914, 286908, 286906, 286900, 286899, 286895, 286813, 286750, 286743, 286720, 286717, 286657, 286633, 286319, 286317, 286289, 285669, 285667, 285622, 285605, 285603, 285589, 285571, 285566, 285467, 285453, 285389, 285383, 285360, 285344, 285342, 285324, 285290, 285286, 285261, 285248, 285247, 284563, 283720, 283713, 283699, 283694, 283693, 283665, 283660, 283649, 283644, 283642, 283641, 283637, 283636, 283633, 283631, 283621, 283617, 283609, 283607, 283598, 283597, 283570, 283568, 283564, 283541, 283538, 283526, 283525, 283518, 283505, 283493, 283492, 283484, 283478, 283474, 283456, 283455, 283444, 283185, 283135, 283123, 283104, 283070, 283008, 282945, 282857, 282822, 282788, 282749, 282748, 282713, 282669, 282651, 282599, 282579, 282578, 282562, 282548, 282463, 282399)) AND (t_d.attribute_id IN ('96', '122', '124', '126', '127', '128', '129', '132', '429', '442', '444', '462', '464', '466', '470', '480', '490')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))