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 = 8 WHERE (e.entity_id IN (976, 974, 970, 973, 969, 3711, 971, 1001, 3166, 986, 981, 1012, 1005, 1007, 1006, 1010, 977, 975, 1018, 995, 1011, 984, 1020, 1179, 994, 4741, 983, 988, 987, 992, 993, 1017, 1004, 985, 1100, 1003, 3712, 979, 972, 3714, 980, 3713, 996, 998, 997, 1168, 1088, 1087, 1085, 1086, 1166, 1128, 1194, 1185, 1165, 1130, 1133, 1192, 1132, 1188, 3087, 1129, 1189, 1186, 1131, 1134, 1184, 1193, 1178, 3088, 1019, 1008, 1009, 1002, 1000, 999, 1058, 1056, 1177, 1057, 1055, 1170, 1171, 1173, 1172, 1037, 1034, 1033, 1031, 1029, 1035, 1036, 1032, 1030, 1187, 1191, 1027, 1023, 1025, 1026, 1022, 1024, 1021, 1028, 1121, 1123, 1124, 1122, 1120, 1125, 1109, 1118, 1112, 1114, 1113, 1110, 1115, 1117, 1107, 1111, 1116, 1119, 1045, 1046, 1052, 1048, 1051, 1054, 1176, 1049, 1164, 1050, 1047, 1053, 3725, 1105, 1104, 1106, 2850, 2851, 2852, 2854, 2856, 2853, 2855, 1014, 1016, 1013, 1015, 991, 990, 989, 1060, 1059, 1061, 1062, 1063, 1071, 1072, 1070, 1068, 1069, 1067, 1065, 1064, 1066, 1181, 1382, 1381, 1380, 1379, 1219, 1221, 1223, 1220, 1222, 1499, 1397, 1498, 1396, 1503, 1502, 1505, 1504, 1233, 1501, 1234, 1500, 1506, 1507, 1508, 1520, 1521, 1522, 1529, 1532, 1535, 1513, 1514, 1515, 1398, 1399, 1182, 1146, 1144, 1138, 1147, 1169, 1136, 1174, 1137, 1145, 1143, 1148, 1135, 1139, 1142, 1195, 1141, 1140, 1162, 1161, 1160, 1154, 1152, 1175, 1149, 1167, 1158, 1157, 1163, 1153, 1151, 1183, 1159, 1150, 1156, 1155, 1090, 1084, 1082, 1083, 1089, 1180, 1076, 1073, 1074, 1079, 1080, 1078, 1075, 1081, 1077, 1387, 1386, 1537, 1536, 1539, 1538, 1541, 1540, 1543, 1542, 1237, 1238, 1545, 1544, 1235, 1236, 1491, 1546, 1488, 1487, 1558, 1557, 1559, 1560, 1551, 1552, 1490, 1489, 1369, 1350, 1362, 1358, 1360, 1366, 1356, 1352, 1372, 1364, 1354, 1348, 1239, 1328, 1340, 1332, 1338, 1346, 1393, 1334, 1344, 1336, 1330, 1342, 1127, 1126, 1044, 1043, 1041, 1042, 1040, 1039, 1038, 1302, 1301, 1300, 1299, 1304, 1306, 1308, 1324, 1326, 1322, 1321, 1318, 1317, 1320, 1319, 1316, 1315, 1312, 1311, 1310, 1309, 1314, 1313, 1410, 1409, 1412, 1411, 1510, 1509, 1512, 1511, 1524, 1523, 1526, 1525, 1528, 1527, 1531, 1530, 1534, 1533, 1517, 1516, 1519, 1518, 1246, 1250, 1262, 1261, 1242, 1384, 1266, 1389, 1388, 1264, 1248, 1247, 1252, 1244, 1268, 1267, 1260, 1254, 1400, 1256, 1255, 1258, 1272, 1274, 1276, 1275, 1288, 1292, 1391, 1390, 1298, 1297, 1280, 1282, 1270, 1269, 1290, 1294, 1278, 1295, 1296, 1284, 1283, 1286, 1378, 1218, 1217, 1213, 1214, 1215, 1216, 1224, 1376, 1375, 1395, 1394, 1203, 1204, 1197, 1198, 1199, 1200, 1209, 1210, 1374, 1373, 1207, 1208, 1201, 1202, 1211, 1212, 1205, 1206, 1548, 1547, 1550, 1549, 1554, 1553, 1556, 1555, 1232, 1231, 1230, 1229, 1495, 1494, 1497, 1496, 1493, 1492, 1228, 1226, 1225, 1227, 1446, 1444, 1438, 1437, 1439, 1440, 1442, 1441, 1448, 1447, 1450, 1449, 1418, 1417, 1420, 1419, 1402, 1401, 1452, 1404, 1403, 1451, 1406, 1405, 1408, 1407, 1453, 1429, 1430, 1432, 1431, 1426, 1425, 1428, 1427, 1414, 1413, 1416, 1415, 1434, 1433, 1436, 1435, 1422, 1421, 1424, 1423, 1471, 1470, 1473, 1472, 1475, 1474, 1477, 1476, 1479, 1478, 1481, 1480, 1457, 1456, 1455, 1454, 1484, 1485, 1461, 1460, 1459, 1458, 1482, 1483, 1465, 1464, 1463, 1462, 1469, 1468, 1467, 1466, 1486)) AND (t_d.attribute_id IN (41)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))