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, 6, 8, 10, 12, 14, 20, 22, 26, 28, 30, 32, 36, 42, 55, 57, 60, 63, 67, 69, 71, 81, 89, 91, 96, 98, 225, 227, 236, 273, 300, 313, 328, 351, 354, 377, 402, 617, 684, 1287, 3987, 4, 5, 3788, 7, 25, 34, 76, 334, 376, 383, 405, 464, 465, 503, 517, 582, 602, 612, 613, 616, 620, 627, 628, 629, 630, 680, 970, 1209, 1394, 1550, 1551, 1552, 1555, 1556, 1557, 1558, 1560, 1565, 1793, 1807, 2042, 2599, 2676, 2681, 3082, 3098, 3203, 4720, 5109, 9691, 9704, 9709, 9, 1198, 11, 19, 54, 59, 700, 927, 963, 1399, 1708, 2338, 9669, 9670, 13, 74, 720, 884, 1374, 1717, 2022, 2185, 2847, 9708, 15, 16, 17, 972, 1517, 2292, 4647, 9671, 9705, 21, 1145, 23, 320, 1386, 1712, 1722, 27, 3262, 29, 78, 80, 349, 497, 647, 648, 649, 650, 651, 655, 656, 657, 668, 730, 1390, 2030, 3088, 3467, 3800, 31, 35, 52, 111, 222, 260, 266, 268, 592, 608, 693, 718, 775, 786, 810, 971, 1006, 1221, 1876, 1877, 1908, 1915, 3058, 3672, 4306, 9677, 9678, 9679, 9680, 9681, 9684, 9685, 9686, 9687, 9688, 33, 537, 929, 932, 957, 966, 968, 1410, 1521, 1834, 1999, 2591, 3945, 37, 40, 41, 103, 104, 105, 255, 261, 265, 267, 290, 338, 339, 343, 356, 361, 368, 475, 562, 563, 564, 565, 566, 578, 586, 732, 737, 757, 805, 838, 840, 1013, 1014, 1048, 1081, 1135, 1226, 1235, 1241, 1248, 1262, 1273, 1276, 1290, 1296, 1466, 1471, 1472, 1473, 1474, 1475, 1476, 1481, 1482, 1484, 1485, 1486, 1487, 1488, 1489, 1497, 1498, 1539, 1540, 1541, 1542, 1594, 1604, 1612, 1613, 1614, 1616, 1617, 1618, 1628, 1666, 1669, 1670, 1672, 1674, 1681, 1682, 1907, 2082, 2128, 2151, 2386, 2392, 2652, 2667, 2677, 2951, 3008, 3087, 3371, 3372, 3442, 3532, 3533, 3832, 3837, 3840, 3843, 4438, 4495, 4542, 4574, 4575, 9689, 9690, 9706, 43, 44, 45, 46, 47, 50, 296, 321, 360, 591, 597, 661, 671, 706, 819, 823, 827, 830, 831, 835, 836, 1032, 1104, 1161, 1268, 1335, 1339, 1359, 1585, 1719, 1787, 1792, 1799, 1962, 2100, 2269, 2505, 2604, 2619, 2631, 2635, 2649, 2664, 2671, 3434, 3964, 4154, 4420, 4503, 4518, 4579, 4993, 9707, 9716, 9717, 9718, 9719, 56, 62, 604, 694, 9710, 58, 535, 540, 3772, 3780, 61, 95, 223, 231, 247, 323, 326, 366, 373, 374, 379, 505, 513, 521, 771, 774, 788, 790, 795, 798, 800, 811, 865, 918, 1117, 1140, 1255, 1417, 1418, 1421, 1422, 1426, 1917, 2127, 2131, 2150, 2156, 2157, 2579, 4284, 4285, 4288, 4297, 4298, 4299, 4311, 4313, 4315, 4316, 4705, 9675, 64, 68, 85, 86, 87, 88, 401, 726, 742, 1067, 2234, 70, 240, 280, 284, 291, 303, 312, 330, 336, 341, 342, 346, 358, 385, 409, 410, 414, 417, 422, 423, 425, 482, 678, 681, 712, 715, 716, 723, 896, 1054, 1055, 1056, 1059, 1141, 1154, 1158, 1162, 1166, 1168, 1172, 1173, 1176, 1342, 1347, 1795, 1968, 1993, 2214, 2221, 3023, 3321, 72, 79, 664, 682, 714, 725, 1372, 2040, 82, 83, 9673, 90, 221, 224, 283, 306, 677, 721, 727, 826, 861, 999, 2062, 2532, 3245, 3246, 3247, 92, 93, 106, 107, 249, 252, 269, 272, 302, 451, 539, 606, 609, 812, 841, 1094, 1108, 1125, 1225, 1289, 1860, 1866, 1867, 1873, 1879, 1880, 1881, 1882, 1887, 1890, 2123, 2352, 2353, 2451, 9674, 97, 391, 792, 850, 99, 453, 1451, 1452, 2155, 2169, 2583, 226, 232, 234, 235, 353, 438, 1247, 228, 229, 233, 238, 322, 337, 441, 1000, 1187, 1301, 9676, 237, 278, 287, 294, 307, 309, 315, 318, 327, 340, 347, 357, 459, 461, 476, 478, 525, 600, 769, 1010, 1040, 1282, 1438, 1548, 1940, 1946, 2749, 2792, 3194, 3506, 9666, 9667, 9668, 9682, 274, 2072, 301, 316, 568, 749, 1791, 1932, 2176, 2326, 3700, 314, 555, 557, 596, 632, 843, 919, 1111, 1139, 1143, 1237, 1277, 1348, 1693, 1912, 1914, 1920, 2636, 4034, 4204, 329, 2979, 352, 4560, 355, 395, 636, 637, 638, 639, 1320, 1813, 378, 386, 389, 485, 486, 487, 491, 492, 551, 1284, 1836, 1842, 1843, 2103, 2107, 2114, 2669, 2713, 2970, 2971, 3992, 4343, 4455, 4675, 4787, 4804, 4833, 9683, 403, 670, 880, 1286, 1380, 1782, 1805, 2021, 2523, 2975, 3055, 4175, 4180, 4355, 4493, 4513, 4727, 9672, 618, 871, 872, 873, 685, 688, 1382, 1288, 1407, 1495, 1739, 1774, 1814, 1815, 1822, 2008, 4370, 4371, 4962, 4963, 4964, 4965, 4971, 4978, 3988, 3989, 3995, 4001, 4002, 4003, 4004, 4005, 4006, 4007, 9692, 9693, 9694, 9695, 9696, 9697, 9698, 9699, 9700, 9701, 9702, 9703, 9711, 9712, 9713, 9714, 9715)) AND (t_d.attribute_id IN (45, 48, 137)) 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 (3, 6, 8, 10, 12, 14, 20, 22, 26, 28, 30, 32, 36, 42, 55, 57, 60, 63, 67, 69, 71, 81, 89, 91, 96, 98, 225, 227, 236, 273, 300, 313, 328, 351, 354, 377, 402, 617, 684, 1287, 3987, 4, 5, 3788, 7, 25, 34, 76, 334, 376, 383, 405, 464, 465, 503, 517, 582, 602, 612, 613, 616, 620, 627, 628, 629, 630, 680, 970, 1209, 1394, 1550, 1551, 1552, 1555, 1556, 1557, 1558, 1560, 1565, 1793, 1807, 2042, 2599, 2676, 2681, 3082, 3098, 3203, 4720, 5109, 9691, 9704, 9709, 9, 1198, 11, 19, 54, 59, 700, 927, 963, 1399, 1708, 2338, 9669, 9670, 13, 74, 720, 884, 1374, 1717, 2022, 2185, 2847, 9708, 15, 16, 17, 972, 1517, 2292, 4647, 9671, 9705, 21, 1145, 23, 320, 1386, 1712, 1722, 27, 3262, 29, 78, 80, 349, 497, 647, 648, 649, 650, 651, 655, 656, 657, 668, 730, 1390, 2030, 3088, 3467, 3800, 31, 35, 52, 111, 222, 260, 266, 268, 592, 608, 693, 718, 775, 786, 810, 971, 1006, 1221, 1876, 1877, 1908, 1915, 3058, 3672, 4306, 9677, 9678, 9679, 9680, 9681, 9684, 9685, 9686, 9687, 9688, 33, 537, 929, 932, 957, 966, 968, 1410, 1521, 1834, 1999, 2591, 3945, 37, 40, 41, 103, 104, 105, 255, 261, 265, 267, 290, 338, 339, 343, 356, 361, 368, 475, 562, 563, 564, 565, 566, 578, 586, 732, 737, 757, 805, 838, 840, 1013, 1014, 1048, 1081, 1135, 1226, 1235, 1241, 1248, 1262, 1273, 1276, 1290, 1296, 1466, 1471, 1472, 1473, 1474, 1475, 1476, 1481, 1482, 1484, 1485, 1486, 1487, 1488, 1489, 1497, 1498, 1539, 1540, 1541, 1542, 1594, 1604, 1612, 1613, 1614, 1616, 1617, 1618, 1628, 1666, 1669, 1670, 1672, 1674, 1681, 1682, 1907, 2082, 2128, 2151, 2386, 2392, 2652, 2667, 2677, 2951, 3008, 3087, 3371, 3372, 3442, 3532, 3533, 3832, 3837, 3840, 3843, 4438, 4495, 4542, 4574, 4575, 9689, 9690, 9706, 43, 44, 45, 46, 47, 50, 296, 321, 360, 591, 597, 661, 671, 706, 819, 823, 827, 830, 831, 835, 836, 1032, 1104, 1161, 1268, 1335, 1339, 1359, 1585, 1719, 1787, 1792, 1799, 1962, 2100, 2269, 2505, 2604, 2619, 2631, 2635, 2649, 2664, 2671, 3434, 3964, 4154, 4420, 4503, 4518, 4579, 4993, 9707, 9716, 9717, 9718, 9719, 56, 62, 604, 694, 9710, 58, 535, 540, 3772, 3780, 61, 95, 223, 231, 247, 323, 326, 366, 373, 374, 379, 505, 513, 521, 771, 774, 788, 790, 795, 798, 800, 811, 865, 918, 1117, 1140, 1255, 1417, 1418, 1421, 1422, 1426, 1917, 2127, 2131, 2150, 2156, 2157, 2579, 4284, 4285, 4288, 4297, 4298, 4299, 4311, 4313, 4315, 4316, 4705, 9675, 64, 68, 85, 86, 87, 88, 401, 726, 742, 1067, 2234, 70, 240, 280, 284, 291, 303, 312, 330, 336, 341, 342, 346, 358, 385, 409, 410, 414, 417, 422, 423, 425, 482, 678, 681, 712, 715, 716, 723, 896, 1054, 1055, 1056, 1059, 1141, 1154, 1158, 1162, 1166, 1168, 1172, 1173, 1176, 1342, 1347, 1795, 1968, 1993, 2214, 2221, 3023, 3321, 72, 79, 664, 682, 714, 725, 1372, 2040, 82, 83, 9673, 90, 221, 224, 283, 306, 677, 721, 727, 826, 861, 999, 2062, 2532, 3245, 3246, 3247, 92, 93, 106, 107, 249, 252, 269, 272, 302, 451, 539, 606, 609, 812, 841, 1094, 1108, 1125, 1225, 1289, 1860, 1866, 1867, 1873, 1879, 1880, 1881, 1882, 1887, 1890, 2123, 2352, 2353, 2451, 9674, 97, 391, 792, 850, 99, 453, 1451, 1452, 2155, 2169, 2583, 226, 232, 234, 235, 353, 438, 1247, 228, 229, 233, 238, 322, 337, 441, 1000, 1187, 1301, 9676, 237, 278, 287, 294, 307, 309, 315, 318, 327, 340, 347, 357, 459, 461, 476, 478, 525, 600, 769, 1010, 1040, 1282, 1438, 1548, 1940, 1946, 2749, 2792, 3194, 3506, 9666, 9667, 9668, 9682, 274, 2072, 301, 316, 568, 749, 1791, 1932, 2176, 2326, 3700, 314, 555, 557, 596, 632, 843, 919, 1111, 1139, 1143, 1237, 1277, 1348, 1693, 1912, 1914, 1920, 2636, 4034, 4204, 329, 2979, 352, 4560, 355, 395, 636, 637, 638, 639, 1320, 1813, 378, 386, 389, 485, 486, 487, 491, 492, 551, 1284, 1836, 1842, 1843, 2103, 2107, 2114, 2669, 2713, 2970, 2971, 3992, 4343, 4455, 4675, 4787, 4804, 4833, 9683, 403, 670, 880, 1286, 1380, 1782, 1805, 2021, 2523, 2975, 3055, 4175, 4180, 4355, 4493, 4513, 4727, 9672, 618, 871, 872, 873, 685, 688, 1382, 1288, 1407, 1495, 1739, 1774, 1814, 1815, 1822, 2008, 4370, 4371, 4962, 4963, 4964, 4965, 4971, 4978, 3988, 3989, 3995, 4001, 4002, 4003, 4004, 4005, 4006, 4007, 9692, 9693, 9694, 9695, 9696, 9697, 9698, 9699, 9700, 9701, 9702, 9703, 9711, 9712, 9713, 9714, 9715)) AND (t_d.attribute_id IN (46)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))