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 (293980, 293965, 293732, 293723, 293348, 293342, 293256, 293240, 293020, 292830, 292813, 292439, 292434, 292427, 292407, 292404, 292390, 291529, 291524, 290709, 290691, 290688, 290352, 290346, 290325, 290266, 289931, 289808, 289765, 289742, 289720, 289717, 289710, 289708, 289698, 289697, 289696, 289691, 289690, 289681, 289665, 289648, 289605, 289592, 289583, 289567, 289560, 289548, 289230, 289154, 288544, 288532, 288528, 288495, 288482, 288426, 288423, 288419, 288393, 287975, 287830, 287785, 287763, 287726, 287663, 287657, 287633, 286945, 286917, 286906, 286720, 286633, 286319, 286318, 286241, 285669, 285667, 285622, 285605, 285467, 285389, 285360, 285344, 285342, 285324, 285290, 285286, 283713, 283694, 283637, 283617, 283598, 283526, 283518, 283505, 283493, 283492, 283478, 283474, 283461, 283455, 283185, 283135, 283104, 282945, 282788, 282749, 282748, 282713, 282651, 282579, 282578, 282463, 282398, 282377, 282371, 282125, 282081, 281586, 281124, 281055, 281033, 279751, 279748, 279264, 279261, 277545, 274808, 274254, 274026, 273970, 273928, 273690, 273659, 273645, 273626, 273606, 273567, 273490, 273366, 272723, 272635, 272629, 272394, 272373, 272292, 272205, 272129, 271912, 271871, 271856, 271839, 271647, 271604, 271565, 271562, 271272, 271246, 271218, 270822, 270797, 270782, 270190, 270176, 270143, 270059, 270041, 269962, 269777, 269730, 269712, 268559, 268316, 268283, 268278, 268195, 268079, 267836, 267726, 266722, 266581, 261802, 259728, 256475, 254513, 252178, 250731, 250540, 250537, 250534, 250016, 249980, 249466, 247354, 247314, 246887, 245050, 242288, 237223, 231834, 222496, 221209, 210388)) 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))