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_text` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_text` 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 (2, 1417, 20, 11, 41, 29, 645, 7, 1064, 3, 1034, 918, 534, 562, 527, 521, 974, 524, 1514, 707, 709, 708, 1505, 1449, 1010, 1078, 1144, 1418, 1423, 1444, 1650, 1050, 415, 1028, 1506, 1450, 1011, 1051, 1145, 1235, 1419, 1424, 1445, 1651, 826, 1484, 1096, 1063, 1029, 1451, 1463, 1052, 1068, 1236, 1420, 1652, 1062, 1160, 463, 1006, 126, 764, 1030, 1053, 1071, 1355, 1662, 1542, 462, 759, 133, 599, 1442, 537, 531, 1023, 1054, 1065, 1356, 1693, 1448, 934, 560, 90, 830, 1085, 1086, 1491, 1339, 1069, 1633, 1439, 585, 603, 141, 690, 695, 1340, 582, 567, 142, 691, 696, 1365, 1388, 647, 1047, 1485, 1021, 644, 149, 694, 1115, 1384, 1067, 1676, 461, 1059, 710, 699, 1070, 125, 671, 143, 831, 100, 144, 877, 1104, 1075, 146, 1674, 1103, 1082, 726, 697, 727, 698, 1472, 95, 99, 1102, 1081, 98, 667, 282, 1592, 283, 1595, 1097, 122, 1581, 1582, 1574, 1589, 665, 1590, 1591, 1596, 460, 1666, 1583, 1584, 1599, 1606, 1663, 225, 254, 1044, 754, 384, 399, 730, 1385, 1696, 1118, 1670, 1001, 1655, 302, 1198, 1202, 1199, 1517, 1527, 1534, 1012, 1480, 1476, 1493, 1501, 1546, 1601, 1613, 1625, 1645, 1658, 1677, 224, 1628, 1045, 865, 1688, 390, 1272, 866, 721, 716, 1112, 840, 1386, 1697, 1119, 1002, 1453, 1335, 1462, 1208, 1183, 1518, 1528, 1535, 1013, 1481, 1477, 1495, 1502, 1544, 1579, 1602, 1614, 1626, 1646, 1659, 1678, 226, 369, 1274, 573, 724, 715, 731, 1698, 1003, 1460, 304, 1174, 1207, 1664, 1519, 1529, 1536, 1482, 1497, 1503, 1438, 1603, 1627, 1647, 1660, 1679, 1702, 251, 378, 1276, 574, 722, 717, 733, 1185, 1184, 1520, 1684, 1537, 1483, 1494, 1504, 1545, 606, 1345, 394, 403, 1604, 1347, 723, 1040, 1255, 1263, 1060, 1197, 1196, 1521, 1530, 1538, 1498, 1429, 725, 1632, 395, 1271, 1346, 1114, 1256, 1264, 1376, 1523, 1531, 1516, 1547, 117, 253, 372, 1433, 1471, 1524, 1532, 1539, 1344, 1273, 1257, 1525, 1635, 1687, 1607, 382, 1605, 1260, 1634, 1685, 1540, 128, 1125, 1683, 1533, 1639, 1637, 127, 1667, 1526, 1636, 1638, 1133, 1131, 1258, 1691, 1541, 1640, 1135, 1615, 1690, 1692, 1681, 1682, 1686, 1675, 1673, 1689, 1694, 244, 1127, 385, 391, 396, 407, 1563, 1554, 1587, 1551, 1557, 1560, 1566, 1616, 245, 386, 392, 410, 1564, 1555, 1588, 1552, 1558, 1561, 1641, 1618, 246, 1129, 393, 413, 1565, 1556, 1553, 1559, 1562, 1567, 464, 1124, 1568, 1130, 408, 411, 409, 412)) AND (t_d.attribute_id IN ('158', '57', '285', '67', '245', '246', '163', '164', '165', '294', '303', '59', '166', '168', '167', '64', '47', '295', '270', '304', '296', '297', '276', '159', '161', '174', '51', '50', '286', '272', '173', '58', '162', '247', '248', '265', '284', '306', '169', '271', '170', '171', '172', '287')) 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 = 1 WHERE (e.entity_id IN (2, 1417, 20, 11, 41, 29, 645, 7, 1064, 3, 1034, 918, 534, 562, 527, 521, 974, 524, 1514, 707, 709, 708, 1505, 1449, 1010, 1078, 1144, 1418, 1423, 1444, 1650, 1050, 415, 1028, 1506, 1450, 1011, 1051, 1145, 1235, 1419, 1424, 1445, 1651, 826, 1484, 1096, 1063, 1029, 1451, 1463, 1052, 1068, 1236, 1420, 1652, 1062, 1160, 463, 1006, 126, 764, 1030, 1053, 1071, 1355, 1662, 1542, 462, 759, 133, 599, 1442, 537, 531, 1023, 1054, 1065, 1356, 1693, 1448, 934, 560, 90, 830, 1085, 1086, 1491, 1339, 1069, 1633, 1439, 585, 603, 141, 690, 695, 1340, 582, 567, 142, 691, 696, 1365, 1388, 647, 1047, 1485, 1021, 644, 149, 694, 1115, 1384, 1067, 1676, 461, 1059, 710, 699, 1070, 125, 671, 143, 831, 100, 144, 877, 1104, 1075, 146, 1674, 1103, 1082, 726, 697, 727, 698, 1472, 95, 99, 1102, 1081, 98, 667, 282, 1592, 283, 1595, 1097, 122, 1581, 1582, 1574, 1589, 665, 1590, 1591, 1596, 460, 1666, 1583, 1584, 1599, 1606, 1663, 225, 254, 1044, 754, 384, 399, 730, 1385, 1696, 1118, 1670, 1001, 1655, 302, 1198, 1202, 1199, 1517, 1527, 1534, 1012, 1480, 1476, 1493, 1501, 1546, 1601, 1613, 1625, 1645, 1658, 1677, 224, 1628, 1045, 865, 1688, 390, 1272, 866, 721, 716, 1112, 840, 1386, 1697, 1119, 1002, 1453, 1335, 1462, 1208, 1183, 1518, 1528, 1535, 1013, 1481, 1477, 1495, 1502, 1544, 1579, 1602, 1614, 1626, 1646, 1659, 1678, 226, 369, 1274, 573, 724, 715, 731, 1698, 1003, 1460, 304, 1174, 1207, 1664, 1519, 1529, 1536, 1482, 1497, 1503, 1438, 1603, 1627, 1647, 1660, 1679, 1702, 251, 378, 1276, 574, 722, 717, 733, 1185, 1184, 1520, 1684, 1537, 1483, 1494, 1504, 1545, 606, 1345, 394, 403, 1604, 1347, 723, 1040, 1255, 1263, 1060, 1197, 1196, 1521, 1530, 1538, 1498, 1429, 725, 1632, 395, 1271, 1346, 1114, 1256, 1264, 1376, 1523, 1531, 1516, 1547, 117, 253, 372, 1433, 1471, 1524, 1532, 1539, 1344, 1273, 1257, 1525, 1635, 1687, 1607, 382, 1605, 1260, 1634, 1685, 1540, 128, 1125, 1683, 1533, 1639, 1637, 127, 1667, 1526, 1636, 1638, 1133, 1131, 1258, 1691, 1541, 1640, 1135, 1615, 1690, 1692, 1681, 1682, 1686, 1675, 1673, 1689, 1694, 244, 1127, 385, 391, 396, 407, 1563, 1554, 1587, 1551, 1557, 1560, 1566, 1616, 245, 386, 392, 410, 1564, 1555, 1588, 1552, 1558, 1561, 1641, 1618, 246, 1129, 393, 413, 1565, 1556, 1553, 1559, 1562, 1567, 464, 1124, 1568, 1130, 408, 411, 409, 412)) AND (t_d.attribute_id IN ('71', '70', '160', '305', '54', '209', '53', '277', '262', '283')) 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_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 (2, 1417, 20, 11, 41, 29, 645, 7, 1064, 3, 1034, 918, 534, 562, 527, 521, 974, 524, 1514, 707, 709, 708, 1505, 1449, 1010, 1078, 1144, 1418, 1423, 1444, 1650, 1050, 415, 1028, 1506, 1450, 1011, 1051, 1145, 1235, 1419, 1424, 1445, 1651, 826, 1484, 1096, 1063, 1029, 1451, 1463, 1052, 1068, 1236, 1420, 1652, 1062, 1160, 463, 1006, 126, 764, 1030, 1053, 1071, 1355, 1662, 1542, 462, 759, 133, 599, 1442, 537, 531, 1023, 1054, 1065, 1356, 1693, 1448, 934, 560, 90, 830, 1085, 1086, 1491, 1339, 1069, 1633, 1439, 585, 603, 141, 690, 695, 1340, 582, 567, 142, 691, 696, 1365, 1388, 647, 1047, 1485, 1021, 644, 149, 694, 1115, 1384, 1067, 1676, 461, 1059, 710, 699, 1070, 125, 671, 143, 831, 100, 144, 877, 1104, 1075, 146, 1674, 1103, 1082, 726, 697, 727, 698, 1472, 95, 99, 1102, 1081, 98, 667, 282, 1592, 283, 1595, 1097, 122, 1581, 1582, 1574, 1589, 665, 1590, 1591, 1596, 460, 1666, 1583, 1584, 1599, 1606, 1663, 225, 254, 1044, 754, 384, 399, 730, 1385, 1696, 1118, 1670, 1001, 1655, 302, 1198, 1202, 1199, 1517, 1527, 1534, 1012, 1480, 1476, 1493, 1501, 1546, 1601, 1613, 1625, 1645, 1658, 1677, 224, 1628, 1045, 865, 1688, 390, 1272, 866, 721, 716, 1112, 840, 1386, 1697, 1119, 1002, 1453, 1335, 1462, 1208, 1183, 1518, 1528, 1535, 1013, 1481, 1477, 1495, 1502, 1544, 1579, 1602, 1614, 1626, 1646, 1659, 1678, 226, 369, 1274, 573, 724, 715, 731, 1698, 1003, 1460, 304, 1174, 1207, 1664, 1519, 1529, 1536, 1482, 1497, 1503, 1438, 1603, 1627, 1647, 1660, 1679, 1702, 251, 378, 1276, 574, 722, 717, 733, 1185, 1184, 1520, 1684, 1537, 1483, 1494, 1504, 1545, 606, 1345, 394, 403, 1604, 1347, 723, 1040, 1255, 1263, 1060, 1197, 1196, 1521, 1530, 1538, 1498, 1429, 725, 1632, 395, 1271, 1346, 1114, 1256, 1264, 1376, 1523, 1531, 1516, 1547, 117, 253, 372, 1433, 1471, 1524, 1532, 1539, 1344, 1273, 1257, 1525, 1635, 1687, 1607, 382, 1605, 1260, 1634, 1685, 1540, 128, 1125, 1683, 1533, 1639, 1637, 127, 1667, 1526, 1636, 1638, 1133, 1131, 1258, 1691, 1541, 1640, 1135, 1615, 1690, 1692, 1681, 1682, 1686, 1675, 1673, 1689, 1694, 244, 1127, 385, 391, 396, 407, 1563, 1554, 1587, 1551, 1557, 1560, 1566, 1616, 245, 386, 392, 410, 1564, 1555, 1588, 1552, 1558, 1561, 1641, 1618, 246, 1129, 393, 413, 1565, 1556, 1553, 1559, 1562, 1567, 464, 1124, 1568, 1130, 408, 411, 409, 412)) AND (t_d.attribute_id IN ('60', '68', '52', '48', '49', '45', '63', '124', '125')) 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_datetime` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_datetime` 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 (2, 1417, 20, 11, 41, 29, 645, 7, 1064, 3, 1034, 918, 534, 562, 527, 521, 974, 524, 1514, 707, 709, 708, 1505, 1449, 1010, 1078, 1144, 1418, 1423, 1444, 1650, 1050, 415, 1028, 1506, 1450, 1011, 1051, 1145, 1235, 1419, 1424, 1445, 1651, 826, 1484, 1096, 1063, 1029, 1451, 1463, 1052, 1068, 1236, 1420, 1652, 1062, 1160, 463, 1006, 126, 764, 1030, 1053, 1071, 1355, 1662, 1542, 462, 759, 133, 599, 1442, 537, 531, 1023, 1054, 1065, 1356, 1693, 1448, 934, 560, 90, 830, 1085, 1086, 1491, 1339, 1069, 1633, 1439, 585, 603, 141, 690, 695, 1340, 582, 567, 142, 691, 696, 1365, 1388, 647, 1047, 1485, 1021, 644, 149, 694, 1115, 1384, 1067, 1676, 461, 1059, 710, 699, 1070, 125, 671, 143, 831, 100, 144, 877, 1104, 1075, 146, 1674, 1103, 1082, 726, 697, 727, 698, 1472, 95, 99, 1102, 1081, 98, 667, 282, 1592, 283, 1595, 1097, 122, 1581, 1582, 1574, 1589, 665, 1590, 1591, 1596, 460, 1666, 1583, 1584, 1599, 1606, 1663, 225, 254, 1044, 754, 384, 399, 730, 1385, 1696, 1118, 1670, 1001, 1655, 302, 1198, 1202, 1199, 1517, 1527, 1534, 1012, 1480, 1476, 1493, 1501, 1546, 1601, 1613, 1625, 1645, 1658, 1677, 224, 1628, 1045, 865, 1688, 390, 1272, 866, 721, 716, 1112, 840, 1386, 1697, 1119, 1002, 1453, 1335, 1462, 1208, 1183, 1518, 1528, 1535, 1013, 1481, 1477, 1495, 1502, 1544, 1579, 1602, 1614, 1626, 1646, 1659, 1678, 226, 369, 1274, 573, 724, 715, 731, 1698, 1003, 1460, 304, 1174, 1207, 1664, 1519, 1529, 1536, 1482, 1497, 1503, 1438, 1603, 1627, 1647, 1660, 1679, 1702, 251, 378, 1276, 574, 722, 717, 733, 1185, 1184, 1520, 1684, 1537, 1483, 1494, 1504, 1545, 606, 1345, 394, 403, 1604, 1347, 723, 1040, 1255, 1263, 1060, 1197, 1196, 1521, 1530, 1538, 1498, 1429, 725, 1632, 395, 1271, 1346, 1114, 1256, 1264, 1376, 1523, 1531, 1516, 1547, 117, 253, 372, 1433, 1471, 1524, 1532, 1539, 1344, 1273, 1257, 1525, 1635, 1687, 1607, 382, 1605, 1260, 1634, 1685, 1540, 128, 1125, 1683, 1533, 1639, 1637, 127, 1667, 1526, 1636, 1638, 1133, 1131, 1258, 1691, 1541, 1640, 1135, 1615, 1690, 1692, 1681, 1682, 1686, 1675, 1673, 1689, 1694, 244, 1127, 385, 391, 396, 407, 1563, 1554, 1587, 1551, 1557, 1560, 1566, 1616, 245, 386, 392, 410, 1564, 1555, 1588, 1552, 1558, 1561, 1641, 1618, 246, 1129, 393, 413, 1565, 1556, 1553, 1559, 1562, 1567, 464, 1124, 1568, 1130, 408, 411, 409, 412)) AND (t_d.attribute_id IN ('61', '62')) 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_decimal` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_decimal` 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 (2, 1417, 20, 11, 41, 29, 645, 7, 1064, 3, 1034, 918, 534, 562, 527, 521, 974, 524, 1514, 707, 709, 708, 1505, 1449, 1010, 1078, 1144, 1418, 1423, 1444, 1650, 1050, 415, 1028, 1506, 1450, 1011, 1051, 1145, 1235, 1419, 1424, 1445, 1651, 826, 1484, 1096, 1063, 1029, 1451, 1463, 1052, 1068, 1236, 1420, 1652, 1062, 1160, 463, 1006, 126, 764, 1030, 1053, 1071, 1355, 1662, 1542, 462, 759, 133, 599, 1442, 537, 531, 1023, 1054, 1065, 1356, 1693, 1448, 934, 560, 90, 830, 1085, 1086, 1491, 1339, 1069, 1633, 1439, 585, 603, 141, 690, 695, 1340, 582, 567, 142, 691, 696, 1365, 1388, 647, 1047, 1485, 1021, 644, 149, 694, 1115, 1384, 1067, 1676, 461, 1059, 710, 699, 1070, 125, 671, 143, 831, 100, 144, 877, 1104, 1075, 146, 1674, 1103, 1082, 726, 697, 727, 698, 1472, 95, 99, 1102, 1081, 98, 667, 282, 1592, 283, 1595, 1097, 122, 1581, 1582, 1574, 1589, 665, 1590, 1591, 1596, 460, 1666, 1583, 1584, 1599, 1606, 1663, 225, 254, 1044, 754, 384, 399, 730, 1385, 1696, 1118, 1670, 1001, 1655, 302, 1198, 1202, 1199, 1517, 1527, 1534, 1012, 1480, 1476, 1493, 1501, 1546, 1601, 1613, 1625, 1645, 1658, 1677, 224, 1628, 1045, 865, 1688, 390, 1272, 866, 721, 716, 1112, 840, 1386, 1697, 1119, 1002, 1453, 1335, 1462, 1208, 1183, 1518, 1528, 1535, 1013, 1481, 1477, 1495, 1502, 1544, 1579, 1602, 1614, 1626, 1646, 1659, 1678, 226, 369, 1274, 573, 724, 715, 731, 1698, 1003, 1460, 304, 1174, 1207, 1664, 1519, 1529, 1536, 1482, 1497, 1503, 1438, 1603, 1627, 1647, 1660, 1679, 1702, 251, 378, 1276, 574, 722, 717, 733, 1185, 1184, 1520, 1684, 1537, 1483, 1494, 1504, 1545, 606, 1345, 394, 403, 1604, 1347, 723, 1040, 1255, 1263, 1060, 1197, 1196, 1521, 1530, 1538, 1498, 1429, 725, 1632, 395, 1271, 1346, 1114, 1256, 1264, 1376, 1523, 1531, 1516, 1547, 117, 253, 372, 1433, 1471, 1524, 1532, 1539, 1344, 1273, 1257, 1525, 1635, 1687, 1607, 382, 1605, 1260, 1634, 1685, 1540, 128, 1125, 1683, 1533, 1639, 1637, 127, 1667, 1526, 1636, 1638, 1133, 1131, 1258, 1691, 1541, 1640, 1135, 1615, 1690, 1692, 1681, 1682, 1686, 1675, 1673, 1689, 1694, 244, 1127, 385, 391, 396, 407, 1563, 1554, 1587, 1551, 1557, 1560, 1566, 1616, 245, 386, 392, 410, 1564, 1555, 1588, 1552, 1558, 1561, 1641, 1618, 246, 1129, 393, 413, 1565, 1556, 1553, 1559, 1562, 1567, 464, 1124, 1568, 1130, 408, 411, 409, 412)) AND (t_d.attribute_id IN ('72')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))