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, 1152, 1167, 1200, 1104, 631, 1153, 1105, 696, 1046, 1106, 697, 633, 1155, 1107, 698, 726, 1048, 635, 727, 1049, 1109, 728, 1051, 1111, 638, 730, 1052, 1112, 1516, 640, 1517, 734, 735, 736, 1058, 645, 737, 1059, 738, 740, 1062, 649, 741, 1515, 650, 1563, 651, 743, 652, 744, 745, 654, 746, 1587, 747, 1627, 750, 752, 753, 755, 757, 760, 766, 769, 770, 771, 772, 774, 775, 776, 779, 784, 786, 790, 792, 793, 794, 1501, 1505, 1506, 1507, 1629, 1630, 655, 667, 669, 671, 674, 676, 681, 685, 686, 687, 688, 690, 700, 706, 708, 716, 717, 711, 713, 797, 1028, 1036, 1020, 834, 846, 860, 862, 864, 865, 875, 876, 899, 893, 901, 928, 931, 932, 934, 950, 953, 966, 970, 980, 981, 1037, 1039, 1038, 986, 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, 1521, 1522, 1520, 1514, 1523, 1519, 1524, 1625, 1593, 1628, 1631, 1639, 656, 701, 707, 709, 718, 712, 798, 1029, 1021, 828, 835, 847, 859, 861, 866, 877, 900, 894, 902, 929, 935, 954, 971, 1556, 1040, 1003, 1011, 1074, 1076, 1095, 1118, 1125, 1133, 1136, 1518, 1224, 1226, 1240, 1159, 1163, 1169, 1176, 1180, 1183, 1626, 1632, 1640, 657, 702, 799, 829, 836, 1508, 878, 903, 1510, 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, 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, 1623, 1621, 1633, 1635, 663, 1263, 807, 851, 868, 871, 886, 891, 880, 896, 898, 914, 919, 907, 945, 1637, 959, 1250, 1026, 1643, 1252, 1097, 1099, 1121, 1127, 1230, 1232, 1234, 1238, 1236, 1173, 1178, 1305, 1634, 1636, 1264, 1503, 1489, 1265, 1279, 1312, 1027, 1122, 1241, 1243, 1239, 1504, 1242, 1244, 802, 805, 808, 839, 842, 845, 855, 852, 869, 872, 881, 884, 887, 889, 892, 908, 910, 915, 916, 920, 940, 943, 946, 957, 960, 1006, 1014, 1018, 1032, 1035, 1130, 1128, 1251, 1253, 1256, 1259, 1261, 1267, 1306, 1309, 1313, 1622, 1624, 1638, 1645, 1270, 856, 922, 1249, 1641, 1644, 1131, 1129, 1642, 1257, 1509, 1307, 1310, 1646, 857, 854, 1308, 1311)) AND (t_d.attribute_id IN (45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))