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 (297245, 297214, 297199, 297195, 297173, 297171, 297153, 297150, 297147, 297126, 297119, 297118, 297117, 297114, 297073, 297072, 297069, 296644, 296642, 296626, 296599, 296588, 296579, 296504, 296501, 296496, 296494, 296492, 296491, 296490, 296481, 296473, 296471, 296468, 296467, 296465, 296464, 296462, 296461, 296458, 296457, 294972, 294665, 294653, 294635, 294634, 294631, 294572, 294549, 294548, 294511, 294498, 294468, 294467, 294429, 294411, 293974, 293932, 293742, 293741, 293739, 293738, 293737, 293731, 293722, 293720, 293640, 293637, 293636, 293344, 293338, 293330, 293325, 293312, 293309, 293308, 293300, 293279, 293266, 293255, 293248, 293231, 293230, 293218, 293208, 292858, 292812, 292482, 292481, 292480, 292476, 292474, 292467, 292455, 292445, 292435, 292426, 292396, 292395, 292391, 291527, 291526, 290998, 290871, 290794, 290689, 290687, 290680, 290677, 290459, 290452, 290429, 290407, 290389, 290387, 290353, 290344, 290324, 290321, 290293, 290292, 290272, 290270, 290267, 289857, 289741, 289734, 289719, 289706, 289705, 289634, 289626, 289612, 289593, 289591, 289588, 289587, 289585, 289568, 289562, 289559, 289558, 289547, 289546, 289545, 289262, 289157, 289111, 289049, 289044, 288546, 288545, 288542, 288509, 288501, 288435, 288396, 288380, 288349, 288267, 288037, 288036, 288008, 287934, 287901, 287885, 287884, 287866, 287848, 287835, 287829, 287803, 287723, 287700, 287636, 287593, 287578, 287566, 287565, 287537, 287536, 287266, 287246, 287163, 287074, 286950, 286943, 286939, 286936, 286915, 286914, 286908, 286900, 286899, 286895, 286813, 286790, 286750, 286717, 286667, 286657, 286617, 286317, 286289, 285693, 285692, 285628, 285621, 285589, 285571, 285569, 285568, 285567, 285566, 285529, 285465, 285453, 285451, 285429, 285427, 285383, 285302, 285261, 285248, 285247, 283709, 283699, 283665, 283660, 283649, 283641, 283639, 283636, 283633, 283631, 283621, 283609, 283597, 283590, 283564, 283562, 283541, 283538, 283525, 283484, 283483, 283479, 283456, 283444, 283123, 283070, 282857, 282840, 282807, 282675, 282669, 282599, 282562, 282465, 282445, 282399, 282395, 282375, 282103, 282075, 281631, 281620, 281619, 281609, 281608, 281580, 281558, 281550, 281549, 281536, 281502, 281490, 281489, 281163, 281132, 281125, 281123, 281110, 281089, 281070, 281053, 281040, 279774, 279752, 279693, 279642, 279359, 279305, 279286, 279262, 279189, 277954, 277952, 277879, 277859)) 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))