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 (1185, 1186, 1187, 1188, 1189, 1190, 665, 672, 703, 711, 715, 727, 1057, 668, 687, 707, 769, 720, 730, 1058, 735, 690, 759, 1055, 994, 744, 1059, 783, 693, 764, 856, 1134, 792, 699, 968, 942, 838, 751, 991, 1176, 845, 756, 1311, 1271, 990, 826, 1321, 1299, 992, 904, 1590, 1307, 1616, 1088, 1602, 1581, 1621, 1102, 1586, 1227, 1617, 1268, 1635, 1273, 1290, 1403, 1437, 1452, 1567, 1579, 1584, 1656, 1773, 666, 669, 673, 688, 691, 694, 700, 704, 708, 712, 716, 721, 728, 731, 736, 745, 752, 757, 760, 765, 784, 793, 827, 839, 846, 905, 969, 1213, 1142, 995, 1089, 1103, 1177, 1228, 1269, 1272, 1274, 1308, 1322, 1438, 1585, 1587, 1774, 680, 781, 696, 749, 762, 718, 723, 866, 949, 747, 770, 754, 786, 799, 807, 828, 859, 848, 1278, 1565, 1183, 1277, 1312, 1451, 682, 1394, 739, 774, 939, 1063, 772, 821, 818, 910, 988, 932, 861, 1314, 1559, 733, 742, 814, 864, 985, 1643, 989, 1060, 1417, 1642, 779, 958, 912, 1275, 1085, 1091, 1444, 1718, 816, 951, 1301, 1107, 1449, 1572, 1741, 902, 979, 1303, 1129, 1659, 1742, 1276, 1118, 1344, 1674, 1131, 1411, 1727, 1135, 1740, 1216, 1218, 1286, 667, 670, 674, 681, 683, 689, 692, 695, 697, 701, 705, 709, 713, 717, 719, 722, 724, 729, 732, 734, 737, 740, 743, 746, 748, 750, 753, 755, 761, 763, 766, 771, 773, 775, 780, 782, 785, 787, 794, 800, 808, 815, 817, 819, 822, 840, 847, 849, 860, 862, 865, 867, 903, 906, 913, 933, 940, 950, 952, 959, 970, 980, 986, 1061, 1064, 1090, 1092, 1104, 1119, 1136, 1217, 1219, 1287, 1302, 1304, 1309, 1313, 1315, 1345, 1395, 1412, 1418, 1445, 1450, 1779, 1566, 1573, 1644, 1660, 1781, 1728, 1782, 1783, 790, 675, 684, 776, 698, 706, 768, 957, 725, 941, 948, 738, 901, 758, 857, 833, 841, 842, 937, 803, 767, 858, 837, 844, 798, 789, 804, 801, 824, 1083, 876, 971, 964, 851, 1123, 899, 1067, 931, 960, 956, 1109, 947, 1130, 1155, 987, 1087, 1143, 1421, 1224, 1105, 1124, 1591, 1331, 1415, 1310, 1759, 1578, 1697, 1434, 1582, 1737, 1746, 676, 685, 777, 741, 802, 812, 976, 917, 962, 853, 843, 930, 938, 894, 788, 928, 868, 836, 795, 825, 823, 829, 914, 1084, 1113, 927, 1328, 1144, 1096, 963, 1305, 1078, 1094, 1448, 1167, 1133, 1414, 1556, 1433, 1655, 1588, 1771, 1749, 677, 686, 778, 797, 973, 813, 1106, 1215, 1138, 887, 1122, 943, 908, 809, 929, 919, 885, 834, 830, 832, 871, 966, 1140, 1115, 1066, 1738, 1221, 1325, 1553, 1201, 1222, 1343, 1137, 1443, 1557, 1435, 1669, 1600, 1786, 678, 852, 796, 820, 872, 1580, 1326, 916, 1125, 909, 810, 934, 978, 895, 835, 831, 850, 881, 1150, 1212, 1291, 1095, 1454, 1568, 1420, 1353, 1399, 1654, 1667, 1436, 1698, 1680, 679, 1558, 811, 882, 873, 1329, 944, 1225, 977, 880, 935, 1160, 915, 854, 889, 920, 911, 1157, 1564, 1112, 1577, 1593, 1393, 1407, 1720, 1689, 1460, 1713, 1733, 791, 870, 893, 875, 1330, 953, 981, 974, 945, 1163, 924, 855, 907, 921, 926, 1158, 1688, 1184, 1633, 1409, 1429, 1721, 1715, 1599, 1743, 805, 874, 900, 898, 1682, 1100, 982, 1082, 954, 1164, 1065, 863, 923, 922, 1099, 1161, 1699, 1199, 1769, 1457, 1592, 1747, 1775, 1615, 806, 877, 918, 972, 1772, 1114, 983, 1214, 955, 1281, 1093, 869, 925, 961, 1126, 1162, 1714, 1442, 1770, 1723, 1750, 1678, 883, 878, 993, 975, 1117, 984, 1288, 1068, 1298, 1097, 888, 1062, 1098, 1147, 1205, 1755, 1562, 1693, 884, 879, 1076, 1121, 1206, 1141, 1560, 1101, 1342, 1156, 896, 1108, 1145, 1165, 1207, 1658, 1694, 886, 936, 1077, 1153, 1208, 1154, 1561, 1127, 1401, 1170, 897, 1111, 1146, 1229, 1306, 1731, 946, 965, 1116, 1289, 1175, 1596, 1204, 1425, 1171, 1079, 1169, 1172, 1270, 1334, 1732, 1069, 967, 1174, 1182, 1609, 1226, 1670, 1178, 1080, 1179, 1292, 1392, 1439, 1070, 1073, 1181, 1209, 1610, 1676, 1323, 1081, 1223, 1327, 1440, 1071, 1074, 1391, 1210, 1611, 1716, 1324, 1086, 1446, 1570, 1665, 1072, 1075, 1396, 1211, 1612, 1416, 1120, 1447, 1605, 1675, 1166, 1128, 1400, 1625, 1613, 1432, 1132, 1456, 1758, 1168, 1148, 1458, 1651, 1614, 1574, 1139, 1569, 1776, 1173, 1149, 1555, 1652, 1623, 1604, 1152, 1571, 1180, 1151, 1628, 1653, 1624, 1619, 1230, 1594, 1200, 1159, 1629, 1647, 1631, 1352, 1595, 1283, 1202, 1646, 1677, 1632, 1390, 1606, 1284, 1231, 1668, 1692, 1648, 1398, 1620, 1285, 1232, 1690, 1662, 1423, 1634, 1294, 1279, 1710, 1696, 1607, 1645, 1333, 1280, 1711, 1734, 1608, 1661, 1335, 1282, 1712, 1735, 1639, 1663, 1404, 1293, 1722, 1768, 1640, 1736, 1406, 1300, 1754, 1641, 1760, 1408, 1332, 1777, 1778, 1422, 1341, 1780, 1424, 1351, 1427, 1397, 1441, 1413, 1563, 1428, 1598, 1455, 1601, 1554, 1636, 1622, 1637, 1627, 1664, 1649, 1685, 1650, 1687, 1666, 1691, 1683, 1704, 1684, 1705, 1700, 1706, 1701, 1707, 1702, 1708, 1703, 1709, 1717, 1730, 1719, 1739, 1724, 1751, 1725, 1752, 1726, 1756, 1744, 1757, 1745, 1761, 1748, 1784, 1753, 1785)) AND (t_d.attribute_id IN ('41')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))