Cart

Mini Cart

Now Shopping by
Color: Mustard
Color: Orange
Color: Multicolor
Color: Royal Blue
Color: Yellow
Color: Lavender
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 (294635, 294631, 294572, 294550, 294531, 294468, 294411, 293974, 293965, 293950, 293741, 293739, 293738, 293732, 293731, 293723, 293639, 293348, 293342, 293321, 293312, 293309, 293279, 293268, 293267, 293257, 293256, 293240, 293231, 293230, 293216, 293214, 293213, 293210, 293205, 293020, 292830, 292813, 292812, 292482, 292480, 292474, 292467, 292434, 292408, 292396, 291524, 290871, 290691, 290688, 290429, 290353, 290352, 290324, 290293, 290270, 290267, 290266, 289765, 289742, 289720, 289719, 289717, 289710, 289708, 289698, 289697, 289696, 289690, 289653, 289648, 289634, 289626, 289605, 289591, 289587, 289585, 289560, 289546, 289230, 289111, 288545, 288532, 288528, 288495, 288423, 288419, 288393, 288380, 288199, 287975, 287901, 287848, 287835, 287803, 287785, 287763, 287758, 287663, 287636, 287578, 287565, 287074, 286943, 286939, 286917, 286906, 286633, 286617, 285693, 285692, 285669, 285628, 285621, 285570, 285569, 285568, 285567, 285529, 285467, 285465, 285451, 285429, 285427, 285389, 285360, 285302, 285290, 283709, 283639, 283637, 283617, 283590, 283562, 283518, 283493, 283483, 283479, 283455, 283135, 283104, 282945, 282840, 282807, 282788, 282713, 282675, 282651, 282579, 282465, 282445, 282398, 282377, 282371, 282125, 281631, 281620, 281609, 281585, 281584, 281558, 281551, 281550, 281549, 281536, 281502, 281490, 281489, 281055, 281033, 280054, 279774, 279748, 279693, 279264, 279261, 277952, 277879, 277859, 277710, 277708, 277679, 277636, 277592, 277586, 277555, 274605, 274383, 274292, 274216, 274201, 273928, 273683, 273682, 273669, 273648, 273625, 273619, 273607, 273587, 273583, 273543, 273492, 273490, 272858, 272509, 272429, 272421, 272407, 272390, 272388, 272383, 272311, 272289, 272236, 272235, 272231, 272205, 272197, 272171, 272093, 272051, 272017, 271862, 271647, 271646, 271272, 270797, 270782, 270622, 270190, 270176, 268738, 268713, 268687, 268672, 268242, 268195, 268171, 263167, 263109, 262699, 262135, 259376, 259008, 258785, 257369, 256873, 256759, 256281, 255129, 254513, 254479, 253914, 253901, 253898, 252481, 252476, 250731, 250534, 250037, 250015, 249980, 249302, 248536, 247354, 247250, 246887, 245050, 243588, 241527, 241508, 235133, 229144, 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))