Now Shopping by
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_decimal` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_decimal` 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 (297145, 296495, 296493, 296484, 296478, 296466, 294550, 294531, 294469, 294104, 294092, 294076, 293732, 293727, 293726, 293725, 293723, 293719, 293342, 293256, 293240, 292830, 292813, 292446, 292434, 291524, 290776, 290702, 290691, 290688, 290352, 289946, 289742, 289720, 289710, 289698, 289697, 289696, 289690, 289683, 289668, 289648, 289605, 289592, 289583, 289567, 289560, 289264, 288528, 288495, 288419, 288393, 288372, 287975, 287868, 287785, 287763, 287761, 286925, 286912, 286906, 286318, 286241, 285669, 285467, 285389, 285360, 285290, 283711, 283637, 283619, 283617, 283608, 283518, 283511, 283493, 283461, 283455, 283135, 283104, 282945, 282750, 282713, 282711, 282668, 282579, 282398, 282379, 282377, 282371, 282102, 281500, 281499, 281055, 281041, 281033, 279748, 279333, 279264, 279261, 273928, 273490, 272175, 271817, 271647, 271272, 271250, 271196, 270782, 270190, 270189, 270176, 269697, 268732, 268686, 268440, 268319, 268286, 268195, 268155, 267793, 267726, 267225, 266800, 266645, 264502, 263226, 262438, 261221, 261102, 260963, 256797, 256473, 252359, 252178, 250731, 249980, 247354)) AND (t_d.attribute_id IN ('76', '120', '467', '468', '469', '481')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))