Cart

Mini Cart

Now Shopping by
Color: Mustard
Color: Orange
Color: Saddlebrown
Color: Gold
Color: Red
Color: Magenta
Color: Pink
Color: Peach
Color: Pista Green
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 (298382, 298344, 298242, 297245, 297240, 297238, 297176, 297148, 297132, 297127, 297113, 296643, 296634, 296619, 296618, 296609, 296600, 296599, 296503, 296502, 296499, 296495, 296493, 296489, 296488, 296486, 296485, 296483, 296480, 296479, 296478, 296477, 296475, 296470, 296469, 296463, 296460, 296459, 294973, 294966, 294964, 294944, 294941, 294664, 294633, 294571, 294550, 294531, 294496, 294371, 294104, 294092, 294076, 294075, 294062, 294036, 293982, 293975, 293963, 293951, 293932, 293905, 293904, 293903, 293736, 293732, 293728, 293726, 293725, 293723, 293721, 293352, 293350, 293342, 293332, 293331, 293315, 293313, 293307, 293306, 293305, 293258, 293256, 293240, 292851, 292830, 292813, 292484, 292478, 292477, 292475, 292466, 292452, 292447, 292434, 292407, 292404, 292394, 292390, 291528, 291524, 291523, 290975, 290835, 290815, 290814, 290776, 290709, 290701, 290691, 290688, 290686, 290680, 290400, 290357, 290352, 290350, 290349, 290346, 290325, 290317, 290263, 289946, 289931, 289808, 289766, 289742, 289734, 289722, 289720, 289710, 289707, 289706, 289698, 289697, 289696, 289694, 289691, 289690, 289680, 289679, 289665, 289664, 289663, 289648, 289605, 289593, 289560, 289548, 289544, 289154, 289114, 289078, 289077, 289045, 288550, 288544, 288531, 288528, 288495, 288484, 288482, 288393, 288320, 288268, 288008, 287997, 287990, 287975, 287974, 287973, 287940, 287934, 287830, 287763, 287726, 287716, 287708, 287657, 287634, 287631, 287573, 287127, 286938, 286933, 286913, 286906, 286903, 286896, 286894, 286790, 286720, 286667, 285669, 285667, 285627, 285605, 285467, 285466, 285389, 285360, 285342, 285324, 285308, 285290, 285288, 283713, 283711, 283637, 283628, 283617, 283611, 283598, 283527, 283524, 283518, 283505, 283493, 283492, 283485, 283478, 283466, 283455, 283298, 283135, 283104, 282945, 282853, 282753, 282751, 282713, 282652, 282587, 282579, 282577, 282463, 282398, 282396, 282377, 282371, 282092, 282080, 281580, 281570, 281500, 281499, 281497, 281209, 281124, 281110, 281055, 281033, 279748, 279661, 279645, 279334, 279265, 279264, 279261, 279241, 277971, 277895, 277842, 277585, 277557, 274808, 274676, 274412, 274373, 274372, 274293, 274268, 274215, 274026, 273928, 273905, 273875, 273643, 273633, 273626, 273606, 273590, 273567, 273561, 273490, 273414, 273368, 272917, 272903, 272854, 272723, 272635, 272629, 272567, 272400, 272394, 271970, 271912, 271871, 271856)) 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))