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 (583, 648, 649, 650, 651, 652, 653, 654, 657, 660, 662, 664, 665, 667, 669, 670, 671, 672, 1258, 1261, 1267, 1279, 1281, 1418, 1448, 1452, 1455, 1457, 1458, 1974, 1975, 1976, 1977, 1982, 1983, 1986, 1987, 2136, 2138, 2139, 2140, 2141, 2143, 2144, 2145, 2146, 2150, 2151, 2203, 2204, 2206, 2210, 2212, 2214, 2217, 2219, 2226, 2227, 2228, 2229, 2232, 2237, 2239, 2241, 2244, 2246, 2248, 2250, 2251, 2252, 2461, 2631, 2633, 2634, 2635, 2636, 2637, 2638, 2640, 2641, 2643, 2645, 2646, 2698, 2699, 2700, 2701, 2702, 2707, 2714, 2843, 3424, 3429, 3433, 3435, 3439, 3441, 3447, 3449, 3466, 3470, 3471, 3472, 3473, 3479, 3480, 3483, 3487, 3489, 3891, 3944, 3945, 3946, 3947, 3949, 3952, 3953, 3956, 3958, 3961, 3962, 3963, 3966, 3971, 3972, 3978, 3980, 3981, 3982, 3983, 3984, 3985, 3986, 3988, 3989, 3990, 3991, 3992, 3994, 4004, 4006, 4009, 4012, 4019, 4602, 5288, 5289, 5290, 5291, 5292, 5293, 5405, 5406, 5407, 5409, 5412, 5413, 5414, 5416, 5417, 5418, 5420, 5422, 5423, 5424, 5425, 5426, 5427, 5428, 5430, 5431, 5432, 5433, 5434, 5435, 5437, 5438, 5520, 5523, 5524, 5525, 5527, 5528, 5530, 5947, 5948, 5950, 5951, 5953, 5956, 5957, 5958, 5959, 5960, 5961, 5963, 5966, 5969, 5970, 5971, 5972, 5973, 5975, 5976, 5981, 5982, 5983, 5984, 5989, 5990, 5991, 5992, 6002, 6004, 6005, 6006, 6007, 6008, 6009, 6010, 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6018, 6019, 6020, 6021, 6022, 6024, 6025, 6026, 6027, 6028, 6029, 6030, 6031, 6032, 6034, 6035, 6036, 6037, 6038, 6039, 6040, 6041, 6042, 6044, 6045, 6046, 6047, 6048, 6049, 6050, 6051, 6052, 6053, 6054, 6055, 6056, 6057, 6058, 6059, 6060, 6061, 6062, 6063, 6065, 6066, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086, 6087, 6088, 6120, 6121, 6244, 6245, 6248, 6249, 6250, 6251, 6252, 6253, 6254, 6255, 6256, 6257, 6258, 6259, 6260, 6261, 6262, 6263, 6264, 6265, 6266, 6267, 6268, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6290, 6291, 6292, 6293, 6294, 6295, 6296, 6298, 6299, 6300, 6301, 6302, 6348, 6349)) AND (t_d.attribute_id IN ('73', '87', '88', '89', '109', '110', '111', '123', '126', '133', '148', '191')) 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 (583, 648, 649, 650, 651, 652, 653, 654, 657, 660, 662, 664, 665, 667, 669, 670, 671, 672, 1258, 1261, 1267, 1279, 1281, 1418, 1448, 1452, 1455, 1457, 1458, 1974, 1975, 1976, 1977, 1982, 1983, 1986, 1987, 2136, 2138, 2139, 2140, 2141, 2143, 2144, 2145, 2146, 2150, 2151, 2203, 2204, 2206, 2210, 2212, 2214, 2217, 2219, 2226, 2227, 2228, 2229, 2232, 2237, 2239, 2241, 2244, 2246, 2248, 2250, 2251, 2252, 2461, 2631, 2633, 2634, 2635, 2636, 2637, 2638, 2640, 2641, 2643, 2645, 2646, 2698, 2699, 2700, 2701, 2702, 2707, 2714, 2843, 3424, 3429, 3433, 3435, 3439, 3441, 3447, 3449, 3466, 3470, 3471, 3472, 3473, 3479, 3480, 3483, 3487, 3489, 3891, 3944, 3945, 3946, 3947, 3949, 3952, 3953, 3956, 3958, 3961, 3962, 3963, 3966, 3971, 3972, 3978, 3980, 3981, 3982, 3983, 3984, 3985, 3986, 3988, 3989, 3990, 3991, 3992, 3994, 4004, 4006, 4009, 4012, 4019, 4602, 5288, 5289, 5290, 5291, 5292, 5293, 5405, 5406, 5407, 5409, 5412, 5413, 5414, 5416, 5417, 5418, 5420, 5422, 5423, 5424, 5425, 5426, 5427, 5428, 5430, 5431, 5432, 5433, 5434, 5435, 5437, 5438, 5520, 5523, 5524, 5525, 5527, 5528, 5530, 5947, 5948, 5950, 5951, 5953, 5956, 5957, 5958, 5959, 5960, 5961, 5963, 5966, 5969, 5970, 5971, 5972, 5973, 5975, 5976, 5981, 5982, 5983, 5984, 5989, 5990, 5991, 5992, 6002, 6004, 6005, 6006, 6007, 6008, 6009, 6010, 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6018, 6019, 6020, 6021, 6022, 6024, 6025, 6026, 6027, 6028, 6029, 6030, 6031, 6032, 6034, 6035, 6036, 6037, 6038, 6039, 6040, 6041, 6042, 6044, 6045, 6046, 6047, 6048, 6049, 6050, 6051, 6052, 6053, 6054, 6055, 6056, 6057, 6058, 6059, 6060, 6061, 6062, 6063, 6065, 6066, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086, 6087, 6088, 6120, 6121, 6244, 6245, 6248, 6249, 6250, 6251, 6252, 6253, 6254, 6255, 6256, 6257, 6258, 6259, 6260, 6261, 6262, 6263, 6264, 6265, 6266, 6267, 6268, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6290, 6291, 6292, 6293, 6294, 6295, 6296, 6298, 6299, 6300, 6301, 6302, 6348, 6349)) AND (t_d.attribute_id IN ('76')) 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 (583, 648, 649, 650, 651, 652, 653, 654, 657, 660, 662, 664, 665, 667, 669, 670, 671, 672, 1258, 1261, 1267, 1279, 1281, 1418, 1448, 1452, 1455, 1457, 1458, 1974, 1975, 1976, 1977, 1982, 1983, 1986, 1987, 2136, 2138, 2139, 2140, 2141, 2143, 2144, 2145, 2146, 2150, 2151, 2203, 2204, 2206, 2210, 2212, 2214, 2217, 2219, 2226, 2227, 2228, 2229, 2232, 2237, 2239, 2241, 2244, 2246, 2248, 2250, 2251, 2252, 2461, 2631, 2633, 2634, 2635, 2636, 2637, 2638, 2640, 2641, 2643, 2645, 2646, 2698, 2699, 2700, 2701, 2702, 2707, 2714, 2843, 3424, 3429, 3433, 3435, 3439, 3441, 3447, 3449, 3466, 3470, 3471, 3472, 3473, 3479, 3480, 3483, 3487, 3489, 3891, 3944, 3945, 3946, 3947, 3949, 3952, 3953, 3956, 3958, 3961, 3962, 3963, 3966, 3971, 3972, 3978, 3980, 3981, 3982, 3983, 3984, 3985, 3986, 3988, 3989, 3990, 3991, 3992, 3994, 4004, 4006, 4009, 4012, 4019, 4602, 5288, 5289, 5290, 5291, 5292, 5293, 5405, 5406, 5407, 5409, 5412, 5413, 5414, 5416, 5417, 5418, 5420, 5422, 5423, 5424, 5425, 5426, 5427, 5428, 5430, 5431, 5432, 5433, 5434, 5435, 5437, 5438, 5520, 5523, 5524, 5525, 5527, 5528, 5530, 5947, 5948, 5950, 5951, 5953, 5956, 5957, 5958, 5959, 5960, 5961, 5963, 5966, 5969, 5970, 5971, 5972, 5973, 5975, 5976, 5981, 5982, 5983, 5984, 5989, 5990, 5991, 5992, 6002, 6004, 6005, 6006, 6007, 6008, 6009, 6010, 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6018, 6019, 6020, 6021, 6022, 6024, 6025, 6026, 6027, 6028, 6029, 6030, 6031, 6032, 6034, 6035, 6036, 6037, 6038, 6039, 6040, 6041, 6042, 6044, 6045, 6046, 6047, 6048, 6049, 6050, 6051, 6052, 6053, 6054, 6055, 6056, 6057, 6058, 6059, 6060, 6061, 6062, 6063, 6065, 6066, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086, 6087, 6088, 6120, 6121, 6244, 6245, 6248, 6249, 6250, 6251, 6252, 6253, 6254, 6255, 6256, 6257, 6258, 6259, 6260, 6261, 6262, 6263, 6264, 6265, 6266, 6267, 6268, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6290, 6291, 6292, 6293, 6294, 6295, 6296, 6298, 6299, 6300, 6301, 6302, 6348, 6349)) AND (t_d.attribute_id IN ('78', '122')) 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_datetime` AS `t_d` INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_product_entity_datetime` 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 (583, 648, 649, 650, 651, 652, 653, 654, 657, 660, 662, 664, 665, 667, 669, 670, 671, 672, 1258, 1261, 1267, 1279, 1281, 1418, 1448, 1452, 1455, 1457, 1458, 1974, 1975, 1976, 1977, 1982, 1983, 1986, 1987, 2136, 2138, 2139, 2140, 2141, 2143, 2144, 2145, 2146, 2150, 2151, 2203, 2204, 2206, 2210, 2212, 2214, 2217, 2219, 2226, 2227, 2228, 2229, 2232, 2237, 2239, 2241, 2244, 2246, 2248, 2250, 2251, 2252, 2461, 2631, 2633, 2634, 2635, 2636, 2637, 2638, 2640, 2641, 2643, 2645, 2646, 2698, 2699, 2700, 2701, 2702, 2707, 2714, 2843, 3424, 3429, 3433, 3435, 3439, 3441, 3447, 3449, 3466, 3470, 3471, 3472, 3473, 3479, 3480, 3483, 3487, 3489, 3891, 3944, 3945, 3946, 3947, 3949, 3952, 3953, 3956, 3958, 3961, 3962, 3963, 3966, 3971, 3972, 3978, 3980, 3981, 3982, 3983, 3984, 3985, 3986, 3988, 3989, 3990, 3991, 3992, 3994, 4004, 4006, 4009, 4012, 4019, 4602, 5288, 5289, 5290, 5291, 5292, 5293, 5405, 5406, 5407, 5409, 5412, 5413, 5414, 5416, 5417, 5418, 5420, 5422, 5423, 5424, 5425, 5426, 5427, 5428, 5430, 5431, 5432, 5433, 5434, 5435, 5437, 5438, 5520, 5523, 5524, 5525, 5527, 5528, 5530, 5947, 5948, 5950, 5951, 5953, 5956, 5957, 5958, 5959, 5960, 5961, 5963, 5966, 5969, 5970, 5971, 5972, 5973, 5975, 5976, 5981, 5982, 5983, 5984, 5989, 5990, 5991, 5992, 6002, 6004, 6005, 6006, 6007, 6008, 6009, 6010, 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6018, 6019, 6020, 6021, 6022, 6024, 6025, 6026, 6027, 6028, 6029, 6030, 6031, 6032, 6034, 6035, 6036, 6037, 6038, 6039, 6040, 6041, 6042, 6044, 6045, 6046, 6047, 6048, 6049, 6050, 6051, 6052, 6053, 6054, 6055, 6056, 6057, 6058, 6059, 6060, 6061, 6062, 6063, 6065, 6066, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086, 6087, 6088, 6120, 6121, 6244, 6245, 6248, 6249, 6250, 6251, 6252, 6253, 6254, 6255, 6256, 6257, 6258, 6259, 6260, 6261, 6262, 6263, 6264, 6265, 6266, 6267, 6268, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6290, 6291, 6292, 6293, 6294, 6295, 6296, 6298, 6299, 6300, 6301, 6302, 6348, 6349)) AND (t_d.attribute_id IN ('79', '80', '94', '95')) 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 (583, 648, 649, 650, 651, 652, 653, 654, 657, 660, 662, 664, 665, 667, 669, 670, 671, 672, 1258, 1261, 1267, 1279, 1281, 1418, 1448, 1452, 1455, 1457, 1458, 1974, 1975, 1976, 1977, 1982, 1983, 1986, 1987, 2136, 2138, 2139, 2140, 2141, 2143, 2144, 2145, 2146, 2150, 2151, 2203, 2204, 2206, 2210, 2212, 2214, 2217, 2219, 2226, 2227, 2228, 2229, 2232, 2237, 2239, 2241, 2244, 2246, 2248, 2250, 2251, 2252, 2461, 2631, 2633, 2634, 2635, 2636, 2637, 2638, 2640, 2641, 2643, 2645, 2646, 2698, 2699, 2700, 2701, 2702, 2707, 2714, 2843, 3424, 3429, 3433, 3435, 3439, 3441, 3447, 3449, 3466, 3470, 3471, 3472, 3473, 3479, 3480, 3483, 3487, 3489, 3891, 3944, 3945, 3946, 3947, 3949, 3952, 3953, 3956, 3958, 3961, 3962, 3963, 3966, 3971, 3972, 3978, 3980, 3981, 3982, 3983, 3984, 3985, 3986, 3988, 3989, 3990, 3991, 3992, 3994, 4004, 4006, 4009, 4012, 4019, 4602, 5288, 5289, 5290, 5291, 5292, 5293, 5405, 5406, 5407, 5409, 5412, 5413, 5414, 5416, 5417, 5418, 5420, 5422, 5423, 5424, 5425, 5426, 5427, 5428, 5430, 5431, 5432, 5433, 5434, 5435, 5437, 5438, 5520, 5523, 5524, 5525, 5527, 5528, 5530, 5947, 5948, 5950, 5951, 5953, 5956, 5957, 5958, 5959, 5960, 5961, 5963, 5966, 5969, 5970, 5971, 5972, 5973, 5975, 5976, 5981, 5982, 5983, 5984, 5989, 5990, 5991, 5992, 6002, 6004, 6005, 6006, 6007, 6008, 6009, 6010, 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6018, 6019, 6020, 6021, 6022, 6024, 6025, 6026, 6027, 6028, 6029, 6030, 6031, 6032, 6034, 6035, 6036, 6037, 6038, 6039, 6040, 6041, 6042, 6044, 6045, 6046, 6047, 6048, 6049, 6050, 6051, 6052, 6053, 6054, 6055, 6056, 6057, 6058, 6059, 6060, 6061, 6062, 6063, 6065, 6066, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086, 6087, 6088, 6120, 6121, 6244, 6245, 6248, 6249, 6250, 6251, 6252, 6253, 6254, 6255, 6256, 6257, 6258, 6259, 6260, 6261, 6262, 6263, 6264, 6265, 6266, 6267, 6268, 6271, 6272, 6273, 6274, 6275, 6276, 6277, 6278, 6279, 6280, 6281, 6282, 6283, 6284, 6285, 6286, 6287, 6288, 6289, 6290, 6291, 6292, 6293, 6294, 6295, 6296, 6298, 6299, 6300, 6301, 6302, 6348, 6349)) AND (t_d.attribute_id IN ('97', '117', '119', '120', '121', '128', '131', '134', '137', '189')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))