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_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_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 = 4 WHERE (e.entity_id IN (10, 959, 18, 684, 13, 70, 71, 382, 72, 296, 300, 301, 727, 997, 1300, 1287, 40, 85, 86, 302, 746, 691, 1069, 197, 1301, 435, 76, 87, 733, 303, 439, 1383, 744, 171, 1325, 960, 77, 88, 739, 304, 62, 1384, 42, 209, 134, 49, 4, 84, 89, 262, 305, 688, 1385, 249, 1388, 379, 102, 24, 78, 90, 1068, 306, 750, 1386, 967, 1346, 43, 79, 91, 1207, 307, 753, 693, 48, 734, 265, 80, 106, 308, 849, 1387, 378, 735, 961, 83, 92, 309, 63, 695, 1102, 738, 250, 100, 105, 310, 385, 696, 1334, 736, 38, 81, 107, 311, 760, 694, 1343, 737, 46, 12, 82, 108, 312, 627, 692, 47, 99, 109, 313, 759, 690, 51, 314, 59, 15, 315, 401, 444, 64, 316, 405, 65, 317, 394, 66, 318, 101, 67, 319, 431, 93, 320, 999, 94, 321, 1076, 103, 322, 413, 104, 323, 1064, 69, 324, 1288, 745, 325, 1002, 166, 227, 784, 962, 1015, 975, 1023, 970, 122, 115, 195, 233, 237, 243, 1003, 998, 756, 974, 172, 836, 215, 1016, 985, 1005, 400, 402, 407, 414, 436, 441, 748, 770, 722, 700, 717, 701, 713, 705, 709, 1026, 749, 751, 755, 765, 762, 851, 37, 35, 1008, 769, 74, 1065, 1070, 1077, 1103, 1335, 1347, 1389, 167, 136, 191, 965, 968, 992, 1022, 972, 128, 110, 155, 234, 238, 244, 1000, 403, 977, 173, 838, 425, 1017, 986, 1060, 392, 406, 415, 1086, 443, 747, 771, 721, 697, 718, 702, 714, 706, 710, 963, 752, 766, 778, 852, 44, 818, 1009, 775, 75, 1066, 1072, 1078, 1104, 1336, 1348, 689, 168, 138, 192, 966, 1010, 993, 1024, 1058, 132, 112, 156, 235, 412, 245, 1001, 1056, 187, 957, 211, 1059, 987, 1004, 396, 416, 39, 409, 779, 772, 723, 698, 719, 703, 715, 707, 711, 1027, 767, 761, 853, 50, 1100, 757, 96, 1289, 1073, 1105, 1337, 1349, 169, 135, 193, 1329, 1011, 994, 1025, 36, 123, 114, 160, 236, 239, 246, 1036, 978, 1063, 198, 212, 1018, 988, 1006, 386, 417, 52, 408, 782, 773, 724, 699, 720, 704, 716, 708, 712, 1028, 763, 54, 41, 754, 98, 1299, 1071, 1106, 1338, 1350, 170, 411, 1034, 969, 1012, 433, 973, 124, 119, 165, 240, 247, 1037, 979, 248, 728, 226, 1019, 989, 1007, 393, 422, 53, 442, 774, 1221, 1029, 68, 785, 259, 788, 95, 1074, 1339, 1351, 271, 137, 822, 45, 1013, 995, 984, 130, 113, 157, 241, 976, 1107, 298, 1244, 1020, 990, 388, 423, 55, 440, 1030, 777, 56, 432, 850, 73, 1075, 1340, 1352, 730, 623, 97, 1333, 1014, 996, 981, 131, 111, 158, 242, 58, 1099, 743, 1290, 1021, 991, 397, 418, 790, 1032, 776, 57, 816, 764, 1353, 1062, 228, 1035, 817, 60, 983, 125, 116, 159, 982, 174, 789, 217, 1382, 1087, 395, 419, 61, 1033, 1211, 1055, 787, 1354, 5, 229, 1092, 964, 1091, 126, 117, 161, 980, 768, 1088, 376, 384, 420, 1328, 1031, 1330, 427, 758, 1355, 1084, 232, 971, 127, 118, 162, 1302, 1240, 629, 391, 421, 1331, 823, 1356, 19, 230, 1090, 129, 120, 163, 263, 200, 854, 398, 424, 1332, 1245, 1357, 780, 231, 1327, 133, 121, 164, 1067, 207, 740, 389, 1080, 1358, 1038, 175, 266, 1241, 383, 1359, 1057, 176, 618, 1082, 399, 1360, 1242, 1381, 434, 1079, 387, 1361, 194, 208, 685, 390, 1362, 1096, 1341, 216, 177, 821, 848, 225, 1095, 792, 793, 791, 1379, 178, 725, 214, 179, 202, 221, 188, 783, 218, 1089, 844, 847, 224, 437, 375, 264, 206, 1200, 786, 199, 213, 180, 260, 219, 1215, 204, 1093, 1235, 837, 404, 1097, 1342, 842, 1061, 835, 614, 181, 1094, 220, 182, 1243, 377, 410, 183, 1213, 741, 619, 426, 428, 1098, 846, 839, 203, 840, 201, 1208, 1101, 1201, 1202, 184, 820, 185, 297, 1199, 1085, 1380, 205, 958, 261, 1206, 1205, 731, 819, 223, 438, 954, 1303, 1216, 222, 1209, 845, 1210, 186, 189, 190, 1345, 1239, 781, 1212, 1326, 1039, 381, 1247, 829, 1283, 1222, 1291, 1040, 1214, 1246, 826, 1275, 1223, 1292, 1041, 804, 1248, 827, 1276, 1224, 1297, 1042, 814, 1249, 828, 1277, 1225, 1293, 1043, 812, 1250, 830, 1278, 1233, 1294, 1044, 815, 1251, 831, 1279, 1298, 1045, 380, 1252, 832, 1280, 1295, 1046, 794, 1253, 833, 1281, 1296, 1047, 795, 1254, 834, 1282, 1048, 796, 1255, 1284, 1049, 797, 1256, 1285, 1050, 798, 1257, 1286, 1051, 799, 1052, 800, 1053, 801, 16, 1054, 802, 17, 1218, 803, 1304, 805, 806, 807, 808, 809, 810, 811, 813, 1305, 1306, 1307, 1308, 1309, 1310, 1311, 1312, 1313, 1314, 1315, 1316, 1317, 1318, 1319, 1320, 1321, 1322, 1323, 1324, 1219, 1220, 1232, 1234)) AND (t_d.attribute_id IN (111, 113, 953)) 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_category_entity_int` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_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 = 4 WHERE (e.entity_id IN (10, 959, 18, 684, 13, 70, 71, 382, 72, 296, 300, 301, 727, 997, 1300, 1287, 40, 85, 86, 302, 746, 691, 1069, 197, 1301, 435, 76, 87, 733, 303, 439, 1383, 744, 171, 1325, 960, 77, 88, 739, 304, 62, 1384, 42, 209, 134, 49, 4, 84, 89, 262, 305, 688, 1385, 249, 1388, 379, 102, 24, 78, 90, 1068, 306, 750, 1386, 967, 1346, 43, 79, 91, 1207, 307, 753, 693, 48, 734, 265, 80, 106, 308, 849, 1387, 378, 735, 961, 83, 92, 309, 63, 695, 1102, 738, 250, 100, 105, 310, 385, 696, 1334, 736, 38, 81, 107, 311, 760, 694, 1343, 737, 46, 12, 82, 108, 312, 627, 692, 47, 99, 109, 313, 759, 690, 51, 314, 59, 15, 315, 401, 444, 64, 316, 405, 65, 317, 394, 66, 318, 101, 67, 319, 431, 93, 320, 999, 94, 321, 1076, 103, 322, 413, 104, 323, 1064, 69, 324, 1288, 745, 325, 1002, 166, 227, 784, 962, 1015, 975, 1023, 970, 122, 115, 195, 233, 237, 243, 1003, 998, 756, 974, 172, 836, 215, 1016, 985, 1005, 400, 402, 407, 414, 436, 441, 748, 770, 722, 700, 717, 701, 713, 705, 709, 1026, 749, 751, 755, 765, 762, 851, 37, 35, 1008, 769, 74, 1065, 1070, 1077, 1103, 1335, 1347, 1389, 167, 136, 191, 965, 968, 992, 1022, 972, 128, 110, 155, 234, 238, 244, 1000, 403, 977, 173, 838, 425, 1017, 986, 1060, 392, 406, 415, 1086, 443, 747, 771, 721, 697, 718, 702, 714, 706, 710, 963, 752, 766, 778, 852, 44, 818, 1009, 775, 75, 1066, 1072, 1078, 1104, 1336, 1348, 689, 168, 138, 192, 966, 1010, 993, 1024, 1058, 132, 112, 156, 235, 412, 245, 1001, 1056, 187, 957, 211, 1059, 987, 1004, 396, 416, 39, 409, 779, 772, 723, 698, 719, 703, 715, 707, 711, 1027, 767, 761, 853, 50, 1100, 757, 96, 1289, 1073, 1105, 1337, 1349, 169, 135, 193, 1329, 1011, 994, 1025, 36, 123, 114, 160, 236, 239, 246, 1036, 978, 1063, 198, 212, 1018, 988, 1006, 386, 417, 52, 408, 782, 773, 724, 699, 720, 704, 716, 708, 712, 1028, 763, 54, 41, 754, 98, 1299, 1071, 1106, 1338, 1350, 170, 411, 1034, 969, 1012, 433, 973, 124, 119, 165, 240, 247, 1037, 979, 248, 728, 226, 1019, 989, 1007, 393, 422, 53, 442, 774, 1221, 1029, 68, 785, 259, 788, 95, 1074, 1339, 1351, 271, 137, 822, 45, 1013, 995, 984, 130, 113, 157, 241, 976, 1107, 298, 1244, 1020, 990, 388, 423, 55, 440, 1030, 777, 56, 432, 850, 73, 1075, 1340, 1352, 730, 623, 97, 1333, 1014, 996, 981, 131, 111, 158, 242, 58, 1099, 743, 1290, 1021, 991, 397, 418, 790, 1032, 776, 57, 816, 764, 1353, 1062, 228, 1035, 817, 60, 983, 125, 116, 159, 982, 174, 789, 217, 1382, 1087, 395, 419, 61, 1033, 1211, 1055, 787, 1354, 5, 229, 1092, 964, 1091, 126, 117, 161, 980, 768, 1088, 376, 384, 420, 1328, 1031, 1330, 427, 758, 1355, 1084, 232, 971, 127, 118, 162, 1302, 1240, 629, 391, 421, 1331, 823, 1356, 19, 230, 1090, 129, 120, 163, 263, 200, 854, 398, 424, 1332, 1245, 1357, 780, 231, 1327, 133, 121, 164, 1067, 207, 740, 389, 1080, 1358, 1038, 175, 266, 1241, 383, 1359, 1057, 176, 618, 1082, 399, 1360, 1242, 1381, 434, 1079, 387, 1361, 194, 208, 685, 390, 1362, 1096, 1341, 216, 177, 821, 848, 225, 1095, 792, 793, 791, 1379, 178, 725, 214, 179, 202, 221, 188, 783, 218, 1089, 844, 847, 224, 437, 375, 264, 206, 1200, 786, 199, 213, 180, 260, 219, 1215, 204, 1093, 1235, 837, 404, 1097, 1342, 842, 1061, 835, 614, 181, 1094, 220, 182, 1243, 377, 410, 183, 1213, 741, 619, 426, 428, 1098, 846, 839, 203, 840, 201, 1208, 1101, 1201, 1202, 184, 820, 185, 297, 1199, 1085, 1380, 205, 958, 261, 1206, 1205, 731, 819, 223, 438, 954, 1303, 1216, 222, 1209, 845, 1210, 186, 189, 190, 1345, 1239, 781, 1212, 1326, 1039, 381, 1247, 829, 1283, 1222, 1291, 1040, 1214, 1246, 826, 1275, 1223, 1292, 1041, 804, 1248, 827, 1276, 1224, 1297, 1042, 814, 1249, 828, 1277, 1225, 1293, 1043, 812, 1250, 830, 1278, 1233, 1294, 1044, 815, 1251, 831, 1279, 1298, 1045, 380, 1252, 832, 1280, 1295, 1046, 794, 1253, 833, 1281, 1296, 1047, 795, 1254, 834, 1282, 1048, 796, 1255, 1284, 1049, 797, 1256, 1285, 1050, 798, 1257, 1286, 1051, 799, 1052, 800, 1053, 801, 16, 1054, 802, 17, 1218, 803, 1304, 805, 806, 807, 808, 809, 810, 811, 813, 1305, 1306, 1307, 1308, 1309, 1310, 1311, 1312, 1313, 1314, 1315, 1316, 1317, 1318, 1319, 1320, 1321, 1322, 1323, 1324, 1219, 1220, 1232, 1234)) AND (t_d.attribute_id IN (119)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))