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 = 1 WHERE (e.entity_id IN (617, 616, 621, 618, 620, 626, 623, 625, 619, 622, 624, 1262, 691, 627, 1149, 1041, 1196, 1164, 1197, 1195, 1101, 692, 1165, 1198, 1102, 693, 721, 1151, 1187, 1166, 1199, 1103, 694, 630, 722, 1152, 1188, 1167, 1200, 1104, 631, 1153, 1105, 696, 724, 1046, 1106, 697, 633, 1155, 1107, 698, 726, 1048, 635, 727, 1049, 1109, 728, 729, 1051, 1111, 638, 730, 1052, 1112, 639, 731, 640, 734, 735, 736, 1058, 645, 737, 1059, 738, 648, 740, 1062, 649, 741, 650, 651, 743, 652, 744, 745, 654, 746, 747, 750, 752, 753, 755, 757, 760, 761, 763, 764, 766, 769, 770, 771, 772, 773, 774, 775, 776, 779, 782, 784, 786, 790, 792, 793, 794, 1501, 655, 666, 667, 669, 671, 674, 675, 676, 681, 684, 685, 686, 687, 688, 690, 700, 706, 708, 716, 717, 711, 713, 797, 809, 811, 1028, 1036, 1020, 826, 832, 834, 846, 860, 862, 864, 865, 875, 876, 899, 893, 901, 928, 931, 932, 934, 950, 953, 961, 963, 964, 966, 970, 973, 980, 981, 982, 1037, 1039, 1038, 986, 989, 994, 995, 998, 1001, 1010, 1066, 1071, 1073, 1075, 1080, 1081, 1089, 1090, 1094, 1123, 1137, 1138, 1140, 1142, 1143, 1223, 1225, 1157, 1158, 1162, 1168, 1175, 1182, 1192, 1193, 656, 701, 707, 709, 718, 712, 798, 1029, 1021, 828, 835, 847, 859, 861, 866, 877, 900, 894, 902, 929, 935, 954, 971, 1040, 990, 1003, 1011, 1074, 1076, 1095, 1118, 1125, 1133, 1136, 1224, 1226, 1240, 1159, 1163, 1169, 1176, 1180, 1183, 657, 702, 799, 829, 836, 878, 903, 1077, 1227, 1160, 1245, 1170, 1181, 658, 1247, 937, 1078, 1228, 1248, 1286, 1254, 662, 661, 660, 659, 705, 703, 704, 800, 803, 831, 830, 837, 843, 840, 848, 850, 885, 879, 895, 897, 913, 918, 906, 941, 938, 955, 1221, 1004, 1016, 1012, 1023, 1025, 1033, 1030, 1096, 1098, 1120, 1126, 1134, 1229, 1231, 1233, 1237, 1235, 1174, 1171, 1172, 1177, 1258, 1260, 1255, 1304, 663, 1263, 807, 814, 851, 868, 871, 886, 891, 880, 896, 898, 914, 919, 907, 945, 959, 1250, 1026, 1252, 1097, 1099, 1121, 1127, 1230, 1232, 1234, 1238, 1236, 1173, 1178, 1305, 1264, 1489, 1265, 1279, 1312, 1027, 1122, 1241, 1243, 1239, 1242, 1244, 802, 805, 808, 816, 839, 842, 845, 855, 852, 869, 872, 881, 884, 887, 889, 892, 908, 910, 915, 916, 920, 921, 940, 943, 946, 957, 960, 1006, 1014, 1018, 1032, 1035, 1130, 1128, 1251, 1253, 1256, 1259, 1261, 1267, 1280, 1306, 1309, 1313, 1270, 856, 909, 911, 1282, 917, 1246, 922, 1249, 1131, 1129, 1257, 1307, 1310, 857, 854, 1281, 912, 1283, 1284, 1308, 1311)) AND (t_d.attribute_id IN (45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))