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 (28834, 1363, 1370, 1401, 1405, 1410, 1426, 1482, 1514, 1517, 1364, 1371, 1402, 1406, 1411, 1427, 1483, 1515, 1518, 28835, 1367, 1394, 1458, 1475, 1430, 1497, 1556, 1541, 28836, 1373, 1423, 1523, 1584, 1437, 1545, 1693, 28842, 1379, 1555, 1578, 1652, 1442, 1554, 1761, 28843, 1385, 1589, 1479, 1619, 28848, 1510, 1882, 1487, 1640, 1633, 1912, 1976, 1365, 1368, 1372, 1374, 1380, 1386, 1395, 1403, 1407, 1412, 1424, 1982, 1431, 1438, 1443, 1476, 1480, 1484, 1488, 1516, 1519, 1524, 1542, 1546, 1557, 1579, 1585, 1590, 1620, 1634, 1641, 1653, 1694, 1762, 1913, 1376, 1382, 1391, 1396, 1835, 1389, 1440, 1564, 1535, 1531, 1706, 1460, 1603, 1529, 1526, 1905, 1678, 1539, 1594, 1562, 1561, 1651, 1591, 1720, 1689, 1636, 1848, 1765, 1904, 1807, 1965, 1417, 1414, 1415, 1450, 1566, 1628, 1661, 1506, 1605, 1568, 1559, 1549, 1598, 1610, 1700, 1679, 1684, 1822, 1795, 1871, 1915, 1863, 1513, 1472, 1896, 1696, 1667, 1608, 1659, 1616, 1645, 1744, 1656, 1738, 1721, 1828, 1841, 1980, 1891, 1575, 1492, 1780, 1710, 1671, 1631, 1714, 1955, 1692, 1760, 1726, 1879, 1985, 1978, 1682, 1587, 1837, 1811, 1853, 1783, 1813, 1960, 1728, 1921, 1987, 1626, 1799, 1861, 1742, 1956, 1802, 1869, 1839, 1826, 1843, 1366, 1369, 1375, 1377, 1381, 1383, 1387, 1397, 1404, 1408, 1413, 1416, 1418, 1432, 1439, 1444, 1451, 1461, 1477, 1481, 1489, 1493, 1507, 1520, 1527, 1530, 1532, 1536, 1540, 1649, 1547, 1550, 1560, 1563, 1565, 1567, 1569, 1580, 1586, 1588, 1592, 1595, 1599, 1604, 1606, 1609, 1617, 1621, 1629, 1632, 1637, 1642, 1646, 1654, 1657, 1662, 1668, 1680, 1685, 1690, 1695, 1697, 1711, 1722, 1727, 1763, 1766, 1781, 1808, 1814, 1827, 1961, 1836, 1849, 1854, 1892, 1897, 1916, 1979, 1981, 1392, 1390, 1398, 1378, 1429, 1455, 1478, 1441, 1887, 1466, 1465, 1462, 1420, 1473, 1452, 1650, 1511, 1528, 1502, 1525, 1648, 1548, 1512, 1521, 1577, 1957, 1534, 1572, 1691, 1681, 1894, 1583, 1670, 1796, 1793, 1757, 1705, 1639, 1729, 1732, 1600, 1756, 1638, 1625, 1688, 1716, 1643, 1704, 1925, 1816, 1655, 1715, 1806, 1745, 1752, 1991, 1718, 1784, 1734, 1881, 1865, 1785, 29261, 1850, 1857, 1932, 1883, 1950, 1902, 1972, 1986, 1984, 1399, 1425, 1459, 1400, 1436, 1468, 1906, 1501, 1469, 1504, 1495, 1753, 1776, 1570, 1574, 1660, 1672, 1544, 1522, 1607, 1647, 1914, 1873, 1909, 1884, 1846, 1677, 1820, 1733, 1675, 1832, 1702, 1821, 1855, 1664, 1805, 1941, 1818, 1658, 1886, 1754, 1973, 1992, 1736, 1933, 1768, 1964, 1890, 1789, 1851, 1940, 1983, 1428, 1499, 1509, 1494, 1936, 1958, 1553, 1611, 1866, 1703, 1596, 1712, 1787, 1741, 1601, 1927, 1872, 1876, 1803, 1723, 1862, 1758, 1917, 1683, 1838, 1819, 1701, 1903, 1769, 1994, 1791, 1990, 1778, 1993, 1888, 1967, 1445, 1823, 1938, 1576, 1613, 1597, 1713, 1810, 1743, 1602, 1928, 1899, 1804, 1731, 1852, 1708, 1908, 1730, 1812, 1844, 1946, 1952, 1995, 1467, 1623, 1764, 1751, 1847, 1615, 1930, 1922, 1969, 1859, 1939, 1740, 1840, 1911, 1686, 1974, 1868, 1618, 1949, 1893, 1750, 1951, 1918, 1954, 1724, 1963, 1935, 1968, 1856, 1948, 1384, 1388, 1393, 1409, 1419, 1421, 1792, 1433, 1446, 1456, 1463, 1474, 1490, 1496, 1505, 1508, 1533, 1537, 1551, 1573, 1581, 1593, 1612, 1614, 1624, 1630, 1644, 1923, 1845, 1665, 1669, 1673, 1687, 1698, 1709, 1746, 1755, 1759, 1788, 1790, 1815, 1817, 1962, 1858, 1895, 1907, 1953, 1975, 1435, 1485, 1422, 1771, 1447, 1454, 1457, 1464, 1824, 1552, 1543, 1943, 1538, 1558, 1571, 1786, 1779, 1622, 1735, 1870, 1725, 1676, 1635, 1777, 1877, 1666, 1898, 1717, 1842, 1919, 1775, 1748, 1770, 1800, 1931, 1937, 1470, 1503, 1945, 1500, 1491, 1825, 1627, 1663, 1582, 1867, 1782, 1674, 1901, 1875, 1794, 1739, 1707, 1900, 1934, 1864, 1874, 1773, 1772, 1830, 1719, 1860, 1737, 1924, 1880, 1926, 1797, 1944, 1833, 1809, 1889, 1767, 1977, 1947, 1910, 1878, 1988, 1971, 1434, 1448, 1699, 1747, 1749, 1774, 1801, 1834, 1920, 1486, 1449, 1798, 1829, 1885, 1831, 1959, 1498, 1453, 1942, 1929, 1970, 1471, 1966, 1989)) AND (t_d.attribute_id IN (45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))