Cart

Mini Cart

Now Shopping by
Color: Mustard
Color: Orange
Color: Purple
Color: Maroon
Color: Grey
Color: Baby Pink
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 (294949, 294550, 294531, 294469, 294412, 294372, 293979, 293926, 293732, 293727, 293723, 293719, 293638, 293342, 293316, 293299, 293256, 293240, 293020, 292830, 292813, 292439, 292434, 292427, 292424, 291529, 291524, 290691, 290688, 290453, 290352, 289765, 289757, 289742, 289720, 289710, 289698, 289697, 289696, 289690, 289683, 289681, 289668, 289648, 289605, 289560, 289264, 288528, 288495, 288426, 288419, 288393, 288372, 287975, 287785, 287763, 287761, 287663, 287633, 287603, 286946, 286945, 286925, 286917, 286912, 286910, 286906, 286633, 286319, 285669, 285632, 285604, 285601, 285467, 285389, 285360, 285344, 285290, 285286, 283718, 283696, 283694, 283645, 283637, 283620, 283619, 283617, 283518, 283511, 283493, 283491, 283490, 283474, 283455, 283185, 283135, 283104, 282945, 282794, 282788, 282750, 282749, 282748, 282713, 282711, 282668, 282651, 282612, 282579, 282578, 282546, 282398, 282379, 282377, 282371, 282125, 282102, 282081, 281586, 281090, 281055, 281041, 281033, 279751, 279748, 279698, 279333, 279264, 279261, 277545, 274654, 274254, 274222, 273928, 273873, 273690, 273670, 273664, 273659, 273647, 273645, 273569, 273544, 273490, 273416, 273366, 272373, 272292, 272205, 271817, 271767, 271647, 271639, 271564, 271562, 271272, 271250, 271196, 270797, 270782, 270190, 270189, 270177, 270176, 270093, 270073, 270059, 270041, 269962, 269712, 269697, 269696, 269126, 269007, 268732, 268658, 268559, 268440, 268319, 268316, 268283, 268278, 268195, 268155, 268079, 267836, 267793, 267225, 266800, 266645, 266581, 263226, 262438, 262034, 261221, 261102, 259728, 256473, 256229, 254513, 254309, 253932, 250731, 250545, 250539, 250537, 250534, 249980, 249452, 247354, 246887, 245050, 244916, 243830, 243533, 242288, 237223, 223452, 222496, 220964, 220050, 210388)) 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))