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_varchar` AS `t_d`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id
LEFT JOIN `catalog_product_entity_varchar` 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 (298446, 298425, 298423, 298397, 298395, 298296, 298234, 297176, 297170, 297168, 297133, 297132, 296587, 296500, 296495, 296493, 296482, 296478, 294969, 294965, 294550, 294531, 294077, 293965, 293961, 293913, 293734, 293732, 293723, 293342, 293322, 293317, 293314, 293304, 293256, 293240, 292830, 292813, 292468, 292436, 292434, 291524, 290691, 290690, 290688, 290451, 290352, 290347, 290268, 290266, 289742, 289720, 289717, 289713, 289710, 289708, 289698, 289697, 289696, 289690, 289648, 289605, 289597, 289586, 289576, 289569, 289560, 289230, 288532, 288528, 288495, 288492, 288441, 288423, 288421, 288393, 288367, 288082, 287975, 287763, 287720, 287269, 286948, 286918, 286909, 286906, 286902, 286443, 285669, 285468, 285467, 285389, 285360, 285305, 285290, 283712, 283637, 283617, 283520, 283518, 283493, 283455, 283135, 283104, 282945, 282824, 282809, 282808, 282713, 282579, 282425, 282398, 282377, 282371, 281634, 281633, 281595, 281093, 281060, 281055, 281036, 281033, 279749, 279748, 279361, 279360, 279302, 279264, 279261, 279192, 274773, 274641, 274597, 274404, 274381, 274236, 273928, 273668, 273589, 273490, 272757, 272755, 272719, 272291, 272260, 272039, 271997, 271921, 271908, 271798, 271647, 271627, 271583, 271272, 271173, 271132, 270782, 270603, 270190, 270176, 268380, 268360, 268122, 266935, 266455, 266342, 265342, 262416, 256313)) AND (t_d.attribute_id IN ('71', '86', '87', '97', '112', '113', '114', '119', '453', '463', '465', '471')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))