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 (293338, 293336, 293330, 293323, 293300, 292456, 292426, 292397, 290847, 289765, 289720, 288542, 288529, 288528, 288495, 288435, 288419, 288396, 288393, 285590, 285589, 285453, 285383, 285247, 284563, 284562, 283699, 283636, 283631, 283597, 283518, 283456, 283455, 283104, 283070, 282399, 282398, 282395, 282377, 282375, 282371, 281125, 281089, 281055, 280212, 279752, 277697, 277696, 274394, 274389, 274387, 274269, 273992, 273972, 273928, 273872, 273843, 273842, 273671, 273663, 273656, 273596, 273591, 273588, 273548, 271874, 271860, 271838, 271779, 271626, 271566, 270813, 270797, 270782, 270128, 270113, 270019, 269693, 268810, 268718, 268682, 268653, 268523, 268483, 268470, 268467, 268379, 268284, 268241, 268195, 268186, 267420, 267039, 266557, 262410, 254324, 250731, 249980, 248552, 248505, 244980, 241876, 241528, 240305, 233303)) AND (t_d.attribute_id IN ('76', '120', '467', '468', '469', '481')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))