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 (298433, 298425, 298383, 298234, 297209, 297176, 297175, 297168, 297145, 297134, 297132, 297129, 297068, 296635, 296610, 296587, 296498, 296497, 296495, 296493, 296487, 296484, 296482, 296478, 296474, 296472, 296466, 294632, 294550, 294531, 294469, 294373, 294049, 293962, 293961, 293926, 293913, 293735, 293734, 293733, 293732, 293730, 293729, 293727, 293724, 293723, 293719, 293638, 293342, 293329, 293317, 293316, 293314, 293304, 293256, 293240, 292830, 292813, 292479, 292468, 292434, 292424, 292409, 292406, 291530, 291524, 290691, 290690, 290688, 290453, 290451, 290352, 290351, 290347, 290320, 289756, 289742, 289736, 289735, 289733, 289720, 289713, 289710, 289709, 289698, 289697, 289696, 289690, 289689, 289683, 289675, 289668, 289648, 289605, 289597, 289570, 289569, 289560, 289194, 289156, 289150, 289115, 289113, 289076, 288549, 288528, 288504, 288495, 288481, 288441, 288429, 288421, 288393, 288372, 287975, 287763, 287761, 287732, 287182, 287126, 286946, 286925, 286920, 286916, 286912, 286910, 286906, 286743, 286366, 285669, 285632, 285604, 285467, 285389, 285360, 285290, 283720, 283696, 283664, 283642, 283637, 283620, 283619, 283617, 283607, 283568, 283520, 283518, 283511, 283493, 283491, 283490, 283455, 283135, 283104, 283008, 282945, 282828, 282822, 282809, 282750, 282713, 282711, 282668, 282612, 282579, 282398, 282379, 282377, 282371, 282102, 281633, 281093, 281075, 281060, 281055, 281041, 281033, 279748, 279698, 279672, 279333, 279264, 279261, 277680, 274773, 274670, 274654, 274597, 274381, 273928, 273873, 273670, 273589, 273490, 272757, 272016, 271921, 271897, 271870, 271817, 271776, 271767, 271647, 271639, 271627, 271583, 271564, 271273, 271272, 271257, 271250, 271196, 271139, 270782, 270190, 270189, 270177, 270176, 270093, 269697, 269696, 269077, 268732, 268440, 268319, 268155, 267793, 267225, 266800, 266645, 265342, 263226, 262438, 261221)) 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))