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 (294665, 294634, 294590, 294549, 294468, 293256, 293255, 292481, 292476, 292468, 292465, 292423, 292408, 292395, 290452, 290451, 290407, 290389, 290354, 290344, 290292, 289592, 289591, 289559, 289558, 289157, 289049, 288501, 287835, 287700, 286750, 286443, 286318, 286317, 286289, 285261, 285248, 283660, 283649, 283644, 283641, 283609, 283590, 283570, 283564, 283525, 283520, 283484, 283461, 283444, 282788, 282669, 282562, 282545, 282103, 282075, 281163, 281132, 281123, 281093, 281070, 281060, 281053, 281040, 279712, 279361, 279360, 279359, 279305, 279302, 279286, 279262, 279192, 279189, 274815, 274774, 274773, 274709, 274601, 274598, 274597, 274381, 274355, 274216, 273795, 272809, 272390, 272171, 271896, 270659, 270621, 266377, 264789, 264693, 264601, 264599, 263167, 262929, 262702, 262416, 262149, 256873, 254452, 254386)) 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))