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 (667664, 667661, 667535, 667490, 667487, 667481, 667466, 667445, 667436, 667412, 667409, 667400, 667388, 667361, 667322, 667094, 663583, 663548, 663485, 663483, 663458, 663377, 663365, 663356, 660465, 653971, 652750, 652566, 652323, 652320, 652317, 652314, 652305, 652296, 652293, 652290, 652287, 652284, 651874, 651817)) AND (t_d.attribute_id IN (73, 87, 88, 89, 109, 110, 111, 127, 175, 204, 224, 1603, 1660, 1681, 1684, 1699, 1708, 1723, 1735, 1738, 1748, 1772, 1778, 1793, 1796, 1811, 1814, 1838, 1844, 1847, 1865, 1868, 1871, 1874, 1877, 1895, 1901, 1907, 1910, 1919, 1922, 1928, 1936, 1967, 1970, 1982, 2003, 2012, 2030, 2048, 2051, 2060, 2078, 2096, 2117, 2126, 2147, 2156, 2165, 2168, 2174, 2183, 2216, 2219, 2231, 2243, 2249, 2261, 2264, 2276, 2306, 2309, 2327, 2333, 2336, 2339, 2345, 2348, 2360, 2393, 2399, 2411, 2441, 2442, 2451, 2463, 2469, 2472, 2475, 2478)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL 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_decimal` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_decimal` 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 (667664, 667661, 667535, 667490, 667487, 667481, 667466, 667445, 667436, 667412, 667409, 667400, 667388, 667361, 667322, 667094, 663583, 663548, 663485, 663483, 663458, 663377, 663365, 663356, 660465, 653971, 652750, 652566, 652323, 652320, 652317, 652314, 652305, 652296, 652293, 652290, 652287, 652284, 651874, 651817)) AND (t_d.attribute_id IN (78, 1164, 2487)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL 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 (667664, 667661, 667535, 667490, 667487, 667481, 667466, 667445, 667436, 667412, 667409, 667400, 667388, 667361, 667322, 667094, 663583, 663548, 663485, 663483, 663458, 663377, 663365, 663356, 660465, 653971, 652750, 652566, 652323, 652320, 652317, 652314, 652305, 652296, 652293, 652290, 652287, 652284, 651874, 651817)) AND (t_d.attribute_id IN (97, 117, 120, 121, 128, 131, 201, 202, 203, 206, 225, 231, 334, 376, 398, 508, 514, 520, 1117, 1134, 1501, 1504, 1507, 1510, 1513, 1529, 1606, 1609, 1612, 1615, 1618, 1621, 1624, 1627, 1630, 1633, 1636, 1639, 1642, 1645, 1648, 1651, 1654, 1657, 1663, 1666, 1669, 1675, 1678, 1687, 1690, 1693, 1696, 1702, 1705, 1711, 1714, 1717, 1720, 1726, 1729, 1732, 1739, 1740, 1741, 1742, 1745, 1751, 1754, 1757, 1760, 1763, 1766, 1769, 1775, 1781, 1784, 1787, 1790, 1799, 1802, 1805, 1808, 1817, 1820, 1823, 1826, 1829, 1832, 1835, 1841, 1850, 1853, 1856, 1859, 1862, 1880, 1883, 1886, 1889, 1892, 1898, 1904, 1913, 1916, 1925, 1932, 1934, 1938, 1940, 1943, 1946, 1949, 1952, 1955, 1958, 1961, 1964, 1973, 1976, 1979, 1985, 1988, 1991, 1994, 1997, 2000, 2006, 2009, 2015, 2018, 2021, 2024, 2027, 2033, 2036, 2039, 2042, 2045, 2054, 2057, 2063, 2066, 2069, 2072, 2075, 2081, 2084, 2087, 2090, 2093, 2099, 2102, 2105, 2108, 2111, 2114, 2120, 2123, 2129, 2132, 2135, 2138, 2141, 2144, 2150, 2153, 2159, 2162, 2171, 2177, 2180, 2186, 2189, 2192, 2195, 2198, 2201, 2204, 2207, 2210, 2213, 2222, 2225, 2228, 2234, 2237, 2240, 2246, 2252, 2255, 2258, 2267, 2270, 2273, 2279, 2282, 2285, 2288, 2291, 2294, 2297, 2300, 2303, 2312, 2315, 2318, 2321, 2324, 2330, 2342, 2351, 2354, 2357, 2363, 2366, 2369, 2372, 2375, 2378, 2381, 2384, 2387, 2390, 2396, 2402, 2405, 2408, 2414, 2417, 2420, 2423, 2426, 2429, 2432, 2435, 2438, 2445, 2448, 2454, 2457, 2460, 2466, 2481, 2484)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL 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_text` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_text` 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 (667664, 667661, 667535, 667490, 667487, 667481, 667466, 667445, 667436, 667412, 667409, 667400, 667388, 667361, 667322, 667094, 663583, 663548, 663485, 663483, 663458, 663377, 663365, 663356, 660465, 653971, 652750, 652566, 652323, 652320, 652317, 652314, 652305, 652296, 652293, 652290, 652287, 652284, 651874, 651817)) AND (t_d.attribute_id IN (279, 1216, 1219, 1222, 1225, 1228, 1231, 1234, 1237, 1240, 1243, 1246, 1249, 1252, 1255, 1258, 1261, 1264, 1267, 1270, 1276, 1279, 1282, 1285, 1288, 1291, 1294, 1297, 1300, 1303, 1306, 1309, 1312, 1315, 1318, 1321, 1324, 1327, 1330)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))