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 (53, 15, 16, 14, 17, 127, 1322, 97, 57, 1181, 1297, 1289, 1323, 1357, 1370, 1386, 1422, 107, 118, 103, 1423, 328, 356, 745, 422, 1342, 1324, 1358, 1371, 1409, 112, 123, 106, 149, 115, 355, 586, 1183, 1341, 1325, 1359, 1372, 1388, 321, 121, 1392, 892, 116, 154, 424, 1184, 1340, 1326, 1373, 1389, 1108, 124, 117, 1408, 856, 1185, 1420, 1390, 125, 105, 1094, 1407, 254, 421, 1186, 1391, 392, 652, 479, 423, 1187, 148, 1320, 1188, 250, 1291, 1403, 729, 1189, 1180, 385, 1367, 1254, 395, 1369, 1190, 362, 390, 926, 159, 1192, 111, 161, 1257, 361, 1193, 303, 1086, 1194, 163, 1195, 398, 248, 384, 264, 1196, 109, 144, 1198, 113, 1253, 469, 1199, 1366, 1200, 1368, 1321, 1216, 1201, 270, 1202, 1203, 108, 1226, 1237, 1387, 1204, 1205, 1206, 1207, 1208, 1210, 1256, 1211, 1212, 1217, 1215, 1228, 1232, 1234, 1235, 1255, 1261, 1262, 1280, 1292, 1312, 1313, 1315, 1316, 1317, 1318, 1327, 1328, 1329, 1330, 1332, 1335, 1336, 1337, 1354, 1356, 1406, 409, 413, 415, 527, 656, 946, 835, 837, 971, 969, 485, 420, 618, 716, 675, 888, 681, 776, 152, 1393, 1404, 1398, 1419, 410, 414, 416, 682, 947, 836, 838, 972, 968, 486, 495, 406, 1394, 676, 831, 908, 896, 122, 1405, 1399, 755, 683, 948, 925, 973, 965, 419, 408, 619, 734, 677, 832, 719, 912, 119, 1400, 684, 949, 843, 839, 970, 487, 850, 751, 663, 678, 876, 718, 907, 823, 897, 1401, 655, 1133, 901, 840, 967, 488, 933, 1117, 928, 740, 777, 828, 844, 1106, 1402, 1132, 158, 966, 489, 753, 666, 929, 845, 1107, 659, 126, 717, 885, 846, 1126, 781, 620, 1395, 530, 1113, 847, 1129, 784, 621, 664, 826, 848, 1127, 796, 821, 774, 827, 1128, 657, 1396, 417, 829, 732, 1397, 1353, 654, 1421, 1268, 701, 786, 1413, 931, 623, 667, 665, 685, 624, 728, 658, 625, 878, 661, 927, 660, 630, 797, 805, 715, 738, 680, 752, 705, 1116, 668, 788, 714, 629, 700, 631, 742, 634, 649, 1066, 1283, 1168, 1135, 1167, 1309, 1148, 1377, 1414, 1067, 1172, 1169, 1136, 1269, 1149, 1378, 1415, 1173, 1170, 1137, 1270, 1151, 1379, 1416, 1174, 1171, 1138, 1150, 1380, 1176, 1139, 1152, 1381, 1177, 1140, 1153, 1382, 1175, 1141, 1154, 1383, 1178, 1365, 1384, 1179, 1417, 1385, 1374, 1375, 1376, 1418)) AND (t_d.attribute_id IN (45, 48, 344)) 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 (53, 15, 16, 14, 17, 127, 1322, 97, 57, 1181, 1297, 1289, 1323, 1357, 1370, 1386, 1422, 107, 118, 103, 1423, 328, 356, 745, 422, 1342, 1324, 1358, 1371, 1409, 112, 123, 106, 149, 115, 355, 586, 1183, 1341, 1325, 1359, 1372, 1388, 321, 121, 1392, 892, 116, 154, 424, 1184, 1340, 1326, 1373, 1389, 1108, 124, 117, 1408, 856, 1185, 1420, 1390, 125, 105, 1094, 1407, 254, 421, 1186, 1391, 392, 652, 479, 423, 1187, 148, 1320, 1188, 250, 1291, 1403, 729, 1189, 1180, 385, 1367, 1254, 395, 1369, 1190, 362, 390, 926, 159, 1192, 111, 161, 1257, 361, 1193, 303, 1086, 1194, 163, 1195, 398, 248, 384, 264, 1196, 109, 144, 1198, 113, 1253, 469, 1199, 1366, 1200, 1368, 1321, 1216, 1201, 270, 1202, 1203, 108, 1226, 1237, 1387, 1204, 1205, 1206, 1207, 1208, 1210, 1256, 1211, 1212, 1217, 1215, 1228, 1232, 1234, 1235, 1255, 1261, 1262, 1280, 1292, 1312, 1313, 1315, 1316, 1317, 1318, 1327, 1328, 1329, 1330, 1332, 1335, 1336, 1337, 1354, 1356, 1406, 409, 413, 415, 527, 656, 946, 835, 837, 971, 969, 485, 420, 618, 716, 675, 888, 681, 776, 152, 1393, 1404, 1398, 1419, 410, 414, 416, 682, 947, 836, 838, 972, 968, 486, 495, 406, 1394, 676, 831, 908, 896, 122, 1405, 1399, 755, 683, 948, 925, 973, 965, 419, 408, 619, 734, 677, 832, 719, 912, 119, 1400, 684, 949, 843, 839, 970, 487, 850, 751, 663, 678, 876, 718, 907, 823, 897, 1401, 655, 1133, 901, 840, 967, 488, 933, 1117, 928, 740, 777, 828, 844, 1106, 1402, 1132, 158, 966, 489, 753, 666, 929, 845, 1107, 659, 126, 717, 885, 846, 1126, 781, 620, 1395, 530, 1113, 847, 1129, 784, 621, 664, 826, 848, 1127, 796, 821, 774, 827, 1128, 657, 1396, 417, 829, 732, 1397, 1353, 654, 1421, 1268, 701, 786, 1413, 931, 623, 667, 665, 685, 624, 728, 658, 625, 878, 661, 927, 660, 630, 797, 805, 715, 738, 680, 752, 705, 1116, 668, 788, 714, 629, 700, 631, 742, 634, 649, 1066, 1283, 1168, 1135, 1167, 1309, 1148, 1377, 1414, 1067, 1172, 1169, 1136, 1269, 1149, 1378, 1415, 1173, 1170, 1137, 1270, 1151, 1379, 1416, 1174, 1171, 1138, 1150, 1380, 1176, 1139, 1152, 1381, 1177, 1140, 1153, 1382, 1175, 1141, 1154, 1383, 1178, 1365, 1384, 1179, 1417, 1385, 1374, 1375, 1376, 1418)) AND (t_d.attribute_id IN (46)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))