Cart

Mini Cart

Now Shopping by
Color: Mustard
Color: Orange
Color: Saddlebrown
Color: Grey
Color: Magenta
Color: Maroon
Color: Lavender
Color: Dark Lavendar
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 (298395, 298389, 298380, 298303, 298234, 298218, 297245, 297176, 297171, 297145, 297134, 297132, 297069, 296599, 296495, 296493, 296484, 296478, 296466, 294550, 294531, 294469, 294468, 294035, 294023, 294014, 293979, 293974, 293932, 293732, 293727, 293723, 293719, 293342, 293256, 293240, 292830, 292813, 292434, 292427, 291529, 291524, 290691, 290688, 290680, 290352, 289742, 289734, 289720, 289710, 289706, 289698, 289697, 289696, 289690, 289683, 289681, 289668, 289648, 289605, 289593, 289560, 288528, 288495, 288426, 288418, 288393, 288372, 288008, 287975, 287934, 287835, 287763, 287761, 287633, 286945, 286925, 286912, 286906, 286790, 286667, 286319, 285669, 285467, 285427, 285389, 285360, 285344, 285290, 285286, 283694, 283637, 283619, 283617, 283590, 283518, 283511, 283493, 283474, 283455, 283185, 283135, 283104, 282945, 282750, 282749, 282748, 282713, 282711, 282668, 282579, 282578, 282465, 282398, 282379, 282377, 282371, 282102, 282081, 281586, 281580, 281502, 281489, 281110, 281055, 281041, 281033, 279751, 279748, 279333, 279264, 279261, 277636, 277592, 274254, 273928, 273659, 273561, 273490, 273366, 272917, 272400, 272373, 272292, 271817, 271647, 271646, 271562, 271272, 271250, 271196, 270782, 270630, 270190, 270189, 270176, 270059, 270041, 269966, 269962, 269712, 269697, 268732, 268559, 268440, 268319, 268316, 268296, 268283, 268278, 268242, 268155, 268079, 267919, 267839, 267836, 267793, 267225, 266800, 266645, 266581, 263992, 263226, 262438, 261221)) 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))