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_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 (294550, 293951, 293926, 293732, 293723, 293638, 293342, 293316, 293315, 293299, 293020, 292830, 292424, 291524, 290453, 290352, 289765, 289742, 289720, 289710, 289697, 289696, 289680, 289560, 289045, 288528, 288495, 288419, 288393, 288268, 287785, 287631, 286946, 286917, 286910, 286633, 285632, 285627, 285604, 285601, 285389, 285360, 283718, 283696, 283645, 283620, 283617, 283518, 283493, 283491, 283490, 283485, 283135, 283104, 282945, 282853, 282713, 282651, 282612, 282579, 282546, 282398, 282377, 282125, 282092, 281090, 281055, 281033, 279748, 279698, 279264, 279261, 277895, 274654, 274222, 273873, 273670, 273647, 273490, 273416, 273368, 272854, 271767, 271639, 271564, 271272, 270797, 270782, 270190, 270177, 270093, 270073, 269696, 269126, 269007, 268658, 268314, 268195, 262034, 256229, 254513, 254309, 250545, 250539, 250534, 249980, 249452, 247354, 245050, 244916, 243533, 242212, 220050, 219353, 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))