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 (3, 1798, 2121, 2123, 2374, 2172, 8, 11, 14, 21, 115, 770, 1345, 2185, 2204, 2224, 2688, 2689, 22, 116, 1346, 2186, 2225, 17, 19, 47, 29, 128, 773, 1348, 2187, 2227, 24, 45, 55, 40, 172, 776, 1357, 27, 53, 138, 245, 1360, 31, 82, 144, 134, 283, 868, 1799, 38, 132, 152, 225, 433, 1547, 2133, 51, 146, 168, 243, 878, 2249, 136, 148, 174, 252, 1741, 150, 170, 183, 259, 2168, 178, 176, 271, 222, 279, 232, 248, 289, 250, 285, 356, 326, 254, 307, 343, 256, 324, 832, 431, 273, 354, 281, 358, 888, 291, 428, 1558, 328, 437, 1860, 360, 1169, 2165, 435, 2195, 850, 1501, 2199, 873, 1553, 870, 1551, 1735, 1549, 1851, 1794, 1849, 2222, 1853, 1862, 2239, 2128, 2169, 2247, 18, 20, 23, 25, 28, 30, 32, 39, 41, 46, 48, 52, 54, 56, 83, 117, 129, 133, 135, 137, 139, 145, 147, 149, 151, 153, 169, 171, 173, 175, 177, 179, 184, 223, 226, 233, 244, 246, 249, 251, 253, 255, 257, 260, 272, 274, 280, 282, 284, 286, 290, 292, 308, 325, 327, 329, 344, 355, 357, 359, 361, 429, 432, 434, 436, 438, 774, 777, 833, 851, 869, 871, 874, 879, 889, 1170, 1347, 1349, 1358, 1361, 1502, 1548, 1550, 1552, 1554, 1559, 1736, 1742, 1795, 1800, 1850, 1852, 1854, 1861, 1863, 2129, 2134, 2188, 2193, 2196, 2200, 2223, 2226, 2228, 65, 66, 26, 334, 35, 270, 339, 77, 78, 80, 89, 58, 59, 60, 154, 123, 217, 142, 141, 140, 143, 430, 1838, 158, 159, 160, 228, 229, 234, 180, 181, 182, 401, 224, 299, 337, 410, 411, 297, 298, 258, 262, 295, 296, 419, 420, 421, 422, 293, 294, 1943, 2231, 330, 331, 439, 440, 1845, 441, 775, 779, 858, 859, 875, 896, 890, 1801, 1350, 1359, 1363, 1697, 1555, 1556, 1919, 1699, 1744, 1796, 1836, 2189, 2194, 2197, 2201, 2229, 67, 68, 242, 81, 288, 87, 86, 88, 119, 62, 63, 64, 156, 191, 220, 215, 214, 213, 216, 1837, 1977, 161, 162, 163, 230, 231, 241, 1857, 1856, 1855, 2117, 227, 300, 336, 602, 338, 894, 261, 276, 425, 426, 2241, 2243, 2240, 2242, 423, 424, 1947, 332, 919, 1843, 1844, 1948, 778, 780, 860, 897, 1825, 1804, 1351, 1364, 1758, 1916, 1557, 1560, 1964, 1733, 1745, 1797, 1848, 2190, 2198, 2245, 90, 91, 335, 155, 407, 96, 95, 118, 212, 70, 71, 72, 164, 201, 362, 221, 219, 218, 372, 1976, 1978, 380, 381, 382, 239, 240, 322, 301, 876, 275, 2236, 2217, 2216, 333, 2148, 1858, 1859, 781, 787, 1826, 1829, 1807, 1356, 2116, 1961, 1561, 1696, 2126, 1739, 1746, 1823, 2191, 92, 93, 157, 416, 99, 98, 211, 268, 74, 75, 76, 185, 348, 364, 367, 363, 366, 376, 1979, 2119, 383, 384, 385, 2202, 323, 877, 2237, 918, 2149, 782, 788, 1832, 1831, 1810, 1694, 1700, 1841, 1747, 1827, 2192, 342, 1802, 165, 417, 106, 105, 266, 125, 126, 127, 195, 368, 371, 365, 2154, 2118, 388, 389, 390, 2230, 691, 893, 2150, 2164, 783, 789, 1835, 1945, 1813, 1695, 1738, 1917, 1748, 1830, 1803, 1805, 186, 891, 109, 108, 204, 205, 206, 278, 373, 375, 369, 393, 394, 395, 1147, 2151, 2221, 784, 800, 1847, 1981, 1816, 1698, 1743, 1949, 1749, 1833, 1806, 1808, 192, 2157, 112, 111, 312, 313, 314, 386, 1955, 1953, 374, 396, 397, 398, 1842, 2156, 2163, 785, 855, 1946, 2260, 1734, 1840, 1950, 1750, 1846, 1809, 1811, 269, 2158, 121, 114, 316, 315, 391, 1956, 1958, 1954, 2220, 786, 2261, 1737, 1915, 2219, 1759, 1944, 1812, 1814, 277, 2235, 189, 122, 399, 1960, 1957, 790, 1740, 1918, 2244, 1921, 1980, 1815, 1817, 287, 199, 190, 409, 2153, 1959, 799, 1839, 1963, 1922, 2259, 1818, 387, 210, 200, 2115, 2152, 801, 1914, 2125, 1975, 392, 263, 209, 2161, 853, 1951, 402, 346, 264, 2162, 861, 1952, 408, 350, 347, 898, 1962, 415, 378, 351, 899, 2124, 418, 379, 900, 2218, 892, 2159, 2160, 2233)) AND (t_d.attribute_id IN (45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))