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 = 2 WHERE (e.entity_id IN (5, 40, 1525, 1512, 1931, 1514, 1471, 65, 1515, 95, 2007, 60, 1513, 1478, 2250, 524, 1480, 792, 1470, 2228, 789, 1004, 957, 2143, 1903, 1476, 775, 1911, 2005, 1001, 1925, 1197, 810, 58, 1479, 1771, 2006, 1000, 955, 1310, 1429, 815, 185, 2026, 1789, 1518, 1772, 2004, 155, 1454, 1524, 482, 1496, 1790, 41, 1802, 1734, 988, 97, 1431, 809, 1324, 1497, 484, 1786, 1005, 994, 96, 2020, 1721, 817, 850, 1498, 1792, 52, 1773, 1003, 1526, 907, 1506, 794, 23, 1499, 1793, 48, 1769, 1002, 1327, 1432, 797, 1686, 1774, 1053, 1453, 18, 1501, 1795, 68, 1777, 1299, 1507, 14, 1502, 1796, 59, 1779, 1486, 110, 1433, 19, 1503, 1797, 51, 1780, 1488, 1434, 808, 64, 1504, 1798, 69, 1770, 1210, 1435, 90, 1857, 1781, 916, 1722, 1839, 1782, 777, 857, 1436, 812, 1841, 1768, 1182, 2000, 1437, 811, 1783, 104, 1329, 1720, 813, 1785, 1438, 1784, 1135, 1439, 1331, 1440, 1101, 2032, 1118, 921, 1259, 1212, 1251, 1695, 1694, 1698, 1687, 74, 1765, 1275, 1481, 106, 2199, 1491, 918, 1105, 1119, 1145, 1256, 1260, 1302, 1368, 1897, 1347, 1508, 1455, 127, 771, 1569, 1578, 1896, 1609, 1619, 1635, 1647, 1689, 1904, 1912, 2023, 2029, 1696, 1693, 1699, 1688, 75, 1767, 1276, 101, 105, 1926, 1492, 917, 1748, 1198, 1930, 1252, 1321, 1301, 1312, 1370, 1671, 1384, 1509, 1456, 111, 1483, 1570, 1579, 1588, 1610, 1636, 1648, 1690, 1905, 1913, 1697, 1692, 1700, 1766, 1277, 102, 107, 1494, 1235, 1060, 1108, 2248, 1254, 1262, 1307, 2035, 1390, 1510, 1457, 125, 1559, 1571, 1580, 1589, 1611, 1625, 1637, 1649, 1906, 1914, 2024, 2028, 1701, 1278, 103, 157, 867, 1102, 1107, 1127, 1143, 1201, 1927, 1387, 1799, 1311, 1371, 2165, 1341, 1511, 1458, 1309, 1898, 1572, 1581, 2166, 1806, 1624, 1650, 1915, 2021, 2027, 1279, 1490, 598, 1741, 2149, 1068, 1109, 1750, 2167, 1227, 1213, 1253, 1267, 1306, 1313, 1369, 1685, 1459, 126, 1573, 1582, 1590, 1613, 1626, 1638, 1651, 1907, 1916, 2211, 2212, 1280, 507, 371, 1237, 2146, 1078, 1110, 1125, 1184, 1202, 2034, 1255, 1268, 1304, 1373, 1392, 1343, 1460, 1562, 1575, 1583, 1591, 1612, 1627, 1639, 1652, 1909, 1917, 2025, 2030, 1281, 1482, 154, 865, 1239, 1705, 1111, 1123, 1395, 1297, 1264, 1305, 1314, 1372, 1391, 1746, 1468, 1563, 1574, 1584, 1592, 1614, 1628, 1640, 1653, 1910, 2170, 2200, 2201, 1282, 1293, 152, 1178, 932, 1070, 1112, 1747, 1141, 1702, 1333, 1265, 1303, 1328, 1400, 1346, 1461, 1576, 1585, 1593, 1615, 1629, 1641, 1654, 1918, 1283, 1658, 769, 1071, 1113, 1121, 1138, 1204, 1257, 1263, 1300, 1315, 1424, 1330, 1342, 1462, 1577, 1586, 1594, 1616, 1630, 1642, 1655, 2153, 153, 869, 1236, 929, 1704, 1116, 1744, 1206, 1323, 1266, 1800, 1374, 1394, 1332, 1463, 1566, 1801, 1595, 1617, 1631, 1643, 1656, 2144, 861, 1073, 1114, 1120, 1205, 1258, 1269, 1661, 1396, 1345, 1733, 1587, 1596, 1618, 1632, 1644, 1657, 1493, 150, 1743, 1320, 1185, 1075, 1386, 1128, 1137, 1207, 1261, 1393, 1466, 1464, 1568, 1634, 1645, 1760, 151, 926, 1115, 1126, 1144, 1348, 1675, 1633, 1349, 859, 1074, 1836, 1136, 1901, 1405, 1899, 858, 1751, 1076, 2052, 1159, 2174, 1176, 866, 1077, 2053, 1142, 2175, 1168, 923, 1224, 2251, 2225, 1739, 863, 922, 1149, 2054, 597, 2043, 931, 913, 2044, 1164, 2045, 1211, 2046, 927, 113, 2047, 2092, 2055, 2126, 2138, 2140, 2162, 2139, 1667, 1284, 1665, 914, 1061, 1707, 1668, 1285, 1377, 915, 1062, 1809, 1669, 1286, 1378, 1670, 1287, 1379, 1064, 1288, 1380, 2157, 1738, 1289, 1663, 2158, 1065, 1290, 1381, 1066, 1291, 1664, 1292, 2154, 2145, 1811, 1666, 1406)) AND (t_d.attribute_id IN (41, 223, 225, 213, 219, 216, 214, 220, 217, 215, 221, 218, 227)) 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 = 2 WHERE (e.entity_id IN (5, 40, 1525, 1512, 1931, 1514, 1471, 65, 1515, 95, 2007, 60, 1513, 1478, 2250, 524, 1480, 792, 1470, 2228, 789, 1004, 957, 2143, 1903, 1476, 775, 1911, 2005, 1001, 1925, 1197, 810, 58, 1479, 1771, 2006, 1000, 955, 1310, 1429, 815, 185, 2026, 1789, 1518, 1772, 2004, 155, 1454, 1524, 482, 1496, 1790, 41, 1802, 1734, 988, 97, 1431, 809, 1324, 1497, 484, 1786, 1005, 994, 96, 2020, 1721, 817, 850, 1498, 1792, 52, 1773, 1003, 1526, 907, 1506, 794, 23, 1499, 1793, 48, 1769, 1002, 1327, 1432, 797, 1686, 1774, 1053, 1453, 18, 1501, 1795, 68, 1777, 1299, 1507, 14, 1502, 1796, 59, 1779, 1486, 110, 1433, 19, 1503, 1797, 51, 1780, 1488, 1434, 808, 64, 1504, 1798, 69, 1770, 1210, 1435, 90, 1857, 1781, 916, 1722, 1839, 1782, 777, 857, 1436, 812, 1841, 1768, 1182, 2000, 1437, 811, 1783, 104, 1329, 1720, 813, 1785, 1438, 1784, 1135, 1439, 1331, 1440, 1101, 2032, 1118, 921, 1259, 1212, 1251, 1695, 1694, 1698, 1687, 74, 1765, 1275, 1481, 106, 2199, 1491, 918, 1105, 1119, 1145, 1256, 1260, 1302, 1368, 1897, 1347, 1508, 1455, 127, 771, 1569, 1578, 1896, 1609, 1619, 1635, 1647, 1689, 1904, 1912, 2023, 2029, 1696, 1693, 1699, 1688, 75, 1767, 1276, 101, 105, 1926, 1492, 917, 1748, 1198, 1930, 1252, 1321, 1301, 1312, 1370, 1671, 1384, 1509, 1456, 111, 1483, 1570, 1579, 1588, 1610, 1636, 1648, 1690, 1905, 1913, 1697, 1692, 1700, 1766, 1277, 102, 107, 1494, 1235, 1060, 1108, 2248, 1254, 1262, 1307, 2035, 1390, 1510, 1457, 125, 1559, 1571, 1580, 1589, 1611, 1625, 1637, 1649, 1906, 1914, 2024, 2028, 1701, 1278, 103, 157, 867, 1102, 1107, 1127, 1143, 1201, 1927, 1387, 1799, 1311, 1371, 2165, 1341, 1511, 1458, 1309, 1898, 1572, 1581, 2166, 1806, 1624, 1650, 1915, 2021, 2027, 1279, 1490, 598, 1741, 2149, 1068, 1109, 1750, 2167, 1227, 1213, 1253, 1267, 1306, 1313, 1369, 1685, 1459, 126, 1573, 1582, 1590, 1613, 1626, 1638, 1651, 1907, 1916, 2211, 2212, 1280, 507, 371, 1237, 2146, 1078, 1110, 1125, 1184, 1202, 2034, 1255, 1268, 1304, 1373, 1392, 1343, 1460, 1562, 1575, 1583, 1591, 1612, 1627, 1639, 1652, 1909, 1917, 2025, 2030, 1281, 1482, 154, 865, 1239, 1705, 1111, 1123, 1395, 1297, 1264, 1305, 1314, 1372, 1391, 1746, 1468, 1563, 1574, 1584, 1592, 1614, 1628, 1640, 1653, 1910, 2170, 2200, 2201, 1282, 1293, 152, 1178, 932, 1070, 1112, 1747, 1141, 1702, 1333, 1265, 1303, 1328, 1400, 1346, 1461, 1576, 1585, 1593, 1615, 1629, 1641, 1654, 1918, 1283, 1658, 769, 1071, 1113, 1121, 1138, 1204, 1257, 1263, 1300, 1315, 1424, 1330, 1342, 1462, 1577, 1586, 1594, 1616, 1630, 1642, 1655, 2153, 153, 869, 1236, 929, 1704, 1116, 1744, 1206, 1323, 1266, 1800, 1374, 1394, 1332, 1463, 1566, 1801, 1595, 1617, 1631, 1643, 1656, 2144, 861, 1073, 1114, 1120, 1205, 1258, 1269, 1661, 1396, 1345, 1733, 1587, 1596, 1618, 1632, 1644, 1657, 1493, 150, 1743, 1320, 1185, 1075, 1386, 1128, 1137, 1207, 1261, 1393, 1466, 1464, 1568, 1634, 1645, 1760, 151, 926, 1115, 1126, 1144, 1348, 1675, 1633, 1349, 859, 1074, 1836, 1136, 1901, 1405, 1899, 858, 1751, 1076, 2052, 1159, 2174, 1176, 866, 1077, 2053, 1142, 2175, 1168, 923, 1224, 2251, 2225, 1739, 863, 922, 1149, 2054, 597, 2043, 931, 913, 2044, 1164, 2045, 1211, 2046, 927, 113, 2047, 2092, 2055, 2126, 2138, 2140, 2162, 2139, 1667, 1284, 1665, 914, 1061, 1707, 1668, 1285, 1377, 915, 1062, 1809, 1669, 1286, 1378, 1670, 1287, 1379, 1064, 1288, 1380, 2157, 1738, 1289, 1663, 2158, 1065, 1290, 1381, 1066, 1291, 1664, 1292, 2154, 2145, 1811, 1666, 1406)) AND (t_d.attribute_id IN (222)) 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_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 = 2 WHERE (e.entity_id IN (5, 40, 1525, 1512, 1931, 1514, 1471, 65, 1515, 95, 2007, 60, 1513, 1478, 2250, 524, 1480, 792, 1470, 2228, 789, 1004, 957, 2143, 1903, 1476, 775, 1911, 2005, 1001, 1925, 1197, 810, 58, 1479, 1771, 2006, 1000, 955, 1310, 1429, 815, 185, 2026, 1789, 1518, 1772, 2004, 155, 1454, 1524, 482, 1496, 1790, 41, 1802, 1734, 988, 97, 1431, 809, 1324, 1497, 484, 1786, 1005, 994, 96, 2020, 1721, 817, 850, 1498, 1792, 52, 1773, 1003, 1526, 907, 1506, 794, 23, 1499, 1793, 48, 1769, 1002, 1327, 1432, 797, 1686, 1774, 1053, 1453, 18, 1501, 1795, 68, 1777, 1299, 1507, 14, 1502, 1796, 59, 1779, 1486, 110, 1433, 19, 1503, 1797, 51, 1780, 1488, 1434, 808, 64, 1504, 1798, 69, 1770, 1210, 1435, 90, 1857, 1781, 916, 1722, 1839, 1782, 777, 857, 1436, 812, 1841, 1768, 1182, 2000, 1437, 811, 1783, 104, 1329, 1720, 813, 1785, 1438, 1784, 1135, 1439, 1331, 1440, 1101, 2032, 1118, 921, 1259, 1212, 1251, 1695, 1694, 1698, 1687, 74, 1765, 1275, 1481, 106, 2199, 1491, 918, 1105, 1119, 1145, 1256, 1260, 1302, 1368, 1897, 1347, 1508, 1455, 127, 771, 1569, 1578, 1896, 1609, 1619, 1635, 1647, 1689, 1904, 1912, 2023, 2029, 1696, 1693, 1699, 1688, 75, 1767, 1276, 101, 105, 1926, 1492, 917, 1748, 1198, 1930, 1252, 1321, 1301, 1312, 1370, 1671, 1384, 1509, 1456, 111, 1483, 1570, 1579, 1588, 1610, 1636, 1648, 1690, 1905, 1913, 1697, 1692, 1700, 1766, 1277, 102, 107, 1494, 1235, 1060, 1108, 2248, 1254, 1262, 1307, 2035, 1390, 1510, 1457, 125, 1559, 1571, 1580, 1589, 1611, 1625, 1637, 1649, 1906, 1914, 2024, 2028, 1701, 1278, 103, 157, 867, 1102, 1107, 1127, 1143, 1201, 1927, 1387, 1799, 1311, 1371, 2165, 1341, 1511, 1458, 1309, 1898, 1572, 1581, 2166, 1806, 1624, 1650, 1915, 2021, 2027, 1279, 1490, 598, 1741, 2149, 1068, 1109, 1750, 2167, 1227, 1213, 1253, 1267, 1306, 1313, 1369, 1685, 1459, 126, 1573, 1582, 1590, 1613, 1626, 1638, 1651, 1907, 1916, 2211, 2212, 1280, 507, 371, 1237, 2146, 1078, 1110, 1125, 1184, 1202, 2034, 1255, 1268, 1304, 1373, 1392, 1343, 1460, 1562, 1575, 1583, 1591, 1612, 1627, 1639, 1652, 1909, 1917, 2025, 2030, 1281, 1482, 154, 865, 1239, 1705, 1111, 1123, 1395, 1297, 1264, 1305, 1314, 1372, 1391, 1746, 1468, 1563, 1574, 1584, 1592, 1614, 1628, 1640, 1653, 1910, 2170, 2200, 2201, 1282, 1293, 152, 1178, 932, 1070, 1112, 1747, 1141, 1702, 1333, 1265, 1303, 1328, 1400, 1346, 1461, 1576, 1585, 1593, 1615, 1629, 1641, 1654, 1918, 1283, 1658, 769, 1071, 1113, 1121, 1138, 1204, 1257, 1263, 1300, 1315, 1424, 1330, 1342, 1462, 1577, 1586, 1594, 1616, 1630, 1642, 1655, 2153, 153, 869, 1236, 929, 1704, 1116, 1744, 1206, 1323, 1266, 1800, 1374, 1394, 1332, 1463, 1566, 1801, 1595, 1617, 1631, 1643, 1656, 2144, 861, 1073, 1114, 1120, 1205, 1258, 1269, 1661, 1396, 1345, 1733, 1587, 1596, 1618, 1632, 1644, 1657, 1493, 150, 1743, 1320, 1185, 1075, 1386, 1128, 1137, 1207, 1261, 1393, 1466, 1464, 1568, 1634, 1645, 1760, 151, 926, 1115, 1126, 1144, 1348, 1675, 1633, 1349, 859, 1074, 1836, 1136, 1901, 1405, 1899, 858, 1751, 1076, 2052, 1159, 2174, 1176, 866, 1077, 2053, 1142, 2175, 1168, 923, 1224, 2251, 2225, 1739, 863, 922, 1149, 2054, 597, 2043, 931, 913, 2044, 1164, 2045, 1211, 2046, 927, 113, 2047, 2092, 2055, 2126, 2138, 2140, 2162, 2139, 1667, 1284, 1665, 914, 1061, 1707, 1668, 1285, 1377, 915, 1062, 1809, 1669, 1286, 1378, 1670, 1287, 1379, 1064, 1288, 1380, 2157, 1738, 1289, 1663, 2158, 1065, 1290, 1381, 1066, 1291, 1664, 1292, 2154, 2145, 1811, 1666, 1406)) AND (t_d.attribute_id IN (228)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))