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 = 3 WHERE (e.entity_id IN (6, 7, 16, 311, 562, 17, 312, 278, 499, 950, 1578, 52, 46, 545, 690, 563, 951, 956, 993, 999, 1031, 1406, 734, 47, 1574, 564, 952, 957, 994, 1000, 1032, 1407, 736, 48, 547, 565, 953, 958, 1033, 1408, 932, 50, 58, 548, 566, 954, 1034, 1409, 59, 725, 838, 54, 55, 56, 57, 967, 1160, 1603, 483, 61, 67, 1134, 1150, 976, 959, 484, 681, 939, 692, 772, 800, 1155, 821, 824, 831, 841, 869, 880, 1158, 884, 913, 919, 944, 970, 1014, 1019, 1001, 1009, 1066, 1077, 1073, 1110, 1113, 1126, 1139, 1161, 1279, 1479, 1483, 1521, 1535, 1575, 60, 66, 1135, 1151, 977, 960, 485, 591, 682, 940, 691, 773, 801, 1156, 822, 825, 832, 842, 870, 881, 1159, 885, 914, 921, 945, 971, 1018, 1024, 1002, 1010, 1068, 1078, 1074, 1111, 1114, 1127, 1144, 1162, 1280, 1484, 1522, 1536, 1576, 62, 1136, 1152, 978, 961, 486, 592, 1378, 802, 1015, 1020, 1003, 1011, 1075, 1137, 1153, 979, 962, 487, 1377, 803, 1016, 1021, 1004, 1012, 1076, 65, 69, 1154, 980, 963, 1017, 1022, 1013, 64, 70, 981, 964, 1023, 965, 966, 1379, 1383, 876, 1284, 1291, 1115, 1119, 1140, 1145, 1392, 1398, 1480, 1523, 1528, 1537, 1541, 1387, 877, 1285, 1292, 1116, 1120, 1141, 1146, 1390, 1402, 1481, 1527, 1533, 1538, 1542, 1381, 1384, 1286, 1293, 1117, 1121, 1142, 1147, 1393, 1399, 1524, 1529, 1539, 1543, 1382, 1385, 1287, 1294, 1118, 1122, 1143, 1148, 1395, 1525, 1530, 1540, 1544, 1386, 1288, 1295, 1123, 1149, 1391, 1401, 1526, 1531, 1545, 1389, 1289, 1296, 1394, 1403, 1532, 1290, 1397, 1404)) AND (t_d.attribute_id IN ('140', '57', '246', '67', '151', '152', '254', '262', '59', '64', '47', '255', '146', '267', '256', '257', '160', '141', '143', '144', '51', '50', '247', '157', '139', '58', '149', '153', '154', '155', '245', '266', '150', '156', '241')) 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 = 3 WHERE (e.entity_id IN (6, 7, 16, 311, 562, 17, 312, 278, 499, 950, 1578, 52, 46, 545, 690, 563, 951, 956, 993, 999, 1031, 1406, 734, 47, 1574, 564, 952, 957, 994, 1000, 1032, 1407, 736, 48, 547, 565, 953, 958, 1033, 1408, 932, 50, 58, 548, 566, 954, 1034, 1409, 59, 725, 838, 54, 55, 56, 57, 967, 1160, 1603, 483, 61, 67, 1134, 1150, 976, 959, 484, 681, 939, 692, 772, 800, 1155, 821, 824, 831, 841, 869, 880, 1158, 884, 913, 919, 944, 970, 1014, 1019, 1001, 1009, 1066, 1077, 1073, 1110, 1113, 1126, 1139, 1161, 1279, 1479, 1483, 1521, 1535, 1575, 60, 66, 1135, 1151, 977, 960, 485, 591, 682, 940, 691, 773, 801, 1156, 822, 825, 832, 842, 870, 881, 1159, 885, 914, 921, 945, 971, 1018, 1024, 1002, 1010, 1068, 1078, 1074, 1111, 1114, 1127, 1144, 1162, 1280, 1484, 1522, 1536, 1576, 62, 1136, 1152, 978, 961, 486, 592, 1378, 802, 1015, 1020, 1003, 1011, 1075, 1137, 1153, 979, 962, 487, 1377, 803, 1016, 1021, 1004, 1012, 1076, 65, 69, 1154, 980, 963, 1017, 1022, 1013, 64, 70, 981, 964, 1023, 965, 966, 1379, 1383, 876, 1284, 1291, 1115, 1119, 1140, 1145, 1392, 1398, 1480, 1523, 1528, 1537, 1541, 1387, 877, 1285, 1292, 1116, 1120, 1141, 1146, 1390, 1402, 1481, 1527, 1533, 1538, 1542, 1381, 1384, 1286, 1293, 1117, 1121, 1142, 1147, 1393, 1399, 1524, 1529, 1539, 1543, 1382, 1385, 1287, 1294, 1118, 1122, 1143, 1148, 1395, 1525, 1530, 1540, 1544, 1386, 1288, 1295, 1123, 1149, 1391, 1401, 1526, 1531, 1545, 1389, 1289, 1296, 1394, 1403, 1532, 1290, 1397, 1404)) AND (t_d.attribute_id IN ('242', '243', '244', '71', '70', '142', '54', '148', '53', '161', '145', '162')) 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_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 = 3 WHERE (e.entity_id IN (6, 7, 16, 311, 562, 17, 312, 278, 499, 950, 1578, 52, 46, 545, 690, 563, 951, 956, 993, 999, 1031, 1406, 734, 47, 1574, 564, 952, 957, 994, 1000, 1032, 1407, 736, 48, 547, 565, 953, 958, 1033, 1408, 932, 50, 58, 548, 566, 954, 1034, 1409, 59, 725, 838, 54, 55, 56, 57, 967, 1160, 1603, 483, 61, 67, 1134, 1150, 976, 959, 484, 681, 939, 692, 772, 800, 1155, 821, 824, 831, 841, 869, 880, 1158, 884, 913, 919, 944, 970, 1014, 1019, 1001, 1009, 1066, 1077, 1073, 1110, 1113, 1126, 1139, 1161, 1279, 1479, 1483, 1521, 1535, 1575, 60, 66, 1135, 1151, 977, 960, 485, 591, 682, 940, 691, 773, 801, 1156, 822, 825, 832, 842, 870, 881, 1159, 885, 914, 921, 945, 971, 1018, 1024, 1002, 1010, 1068, 1078, 1074, 1111, 1114, 1127, 1144, 1162, 1280, 1484, 1522, 1536, 1576, 62, 1136, 1152, 978, 961, 486, 592, 1378, 802, 1015, 1020, 1003, 1011, 1075, 1137, 1153, 979, 962, 487, 1377, 803, 1016, 1021, 1004, 1012, 1076, 65, 69, 1154, 980, 963, 1017, 1022, 1013, 64, 70, 981, 964, 1023, 965, 966, 1379, 1383, 876, 1284, 1291, 1115, 1119, 1140, 1145, 1392, 1398, 1480, 1523, 1528, 1537, 1541, 1387, 877, 1285, 1292, 1116, 1120, 1141, 1146, 1390, 1402, 1481, 1527, 1533, 1538, 1542, 1381, 1384, 1286, 1293, 1117, 1121, 1142, 1147, 1393, 1399, 1524, 1529, 1539, 1543, 1382, 1385, 1287, 1294, 1118, 1122, 1143, 1148, 1395, 1525, 1530, 1540, 1544, 1386, 1288, 1295, 1123, 1149, 1391, 1401, 1526, 1531, 1545, 1389, 1289, 1296, 1394, 1403, 1532, 1290, 1397, 1404)) AND (t_d.attribute_id IN ('60', '68', '52', '48', '49', '45', '63', '124', '125')) 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_datetime` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_datetime` 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 = 3 WHERE (e.entity_id IN (6, 7, 16, 311, 562, 17, 312, 278, 499, 950, 1578, 52, 46, 545, 690, 563, 951, 956, 993, 999, 1031, 1406, 734, 47, 1574, 564, 952, 957, 994, 1000, 1032, 1407, 736, 48, 547, 565, 953, 958, 1033, 1408, 932, 50, 58, 548, 566, 954, 1034, 1409, 59, 725, 838, 54, 55, 56, 57, 967, 1160, 1603, 483, 61, 67, 1134, 1150, 976, 959, 484, 681, 939, 692, 772, 800, 1155, 821, 824, 831, 841, 869, 880, 1158, 884, 913, 919, 944, 970, 1014, 1019, 1001, 1009, 1066, 1077, 1073, 1110, 1113, 1126, 1139, 1161, 1279, 1479, 1483, 1521, 1535, 1575, 60, 66, 1135, 1151, 977, 960, 485, 591, 682, 940, 691, 773, 801, 1156, 822, 825, 832, 842, 870, 881, 1159, 885, 914, 921, 945, 971, 1018, 1024, 1002, 1010, 1068, 1078, 1074, 1111, 1114, 1127, 1144, 1162, 1280, 1484, 1522, 1536, 1576, 62, 1136, 1152, 978, 961, 486, 592, 1378, 802, 1015, 1020, 1003, 1011, 1075, 1137, 1153, 979, 962, 487, 1377, 803, 1016, 1021, 1004, 1012, 1076, 65, 69, 1154, 980, 963, 1017, 1022, 1013, 64, 70, 981, 964, 1023, 965, 966, 1379, 1383, 876, 1284, 1291, 1115, 1119, 1140, 1145, 1392, 1398, 1480, 1523, 1528, 1537, 1541, 1387, 877, 1285, 1292, 1116, 1120, 1141, 1146, 1390, 1402, 1481, 1527, 1533, 1538, 1542, 1381, 1384, 1286, 1293, 1117, 1121, 1142, 1147, 1393, 1399, 1524, 1529, 1539, 1543, 1382, 1385, 1287, 1294, 1118, 1122, 1143, 1148, 1395, 1525, 1530, 1540, 1544, 1386, 1288, 1295, 1123, 1149, 1391, 1401, 1526, 1531, 1545, 1389, 1289, 1296, 1394, 1403, 1532, 1290, 1397, 1404)) AND (t_d.attribute_id IN ('61', '62')) 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_decimal` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_decimal` 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 = 3 WHERE (e.entity_id IN (6, 7, 16, 311, 562, 17, 312, 278, 499, 950, 1578, 52, 46, 545, 690, 563, 951, 956, 993, 999, 1031, 1406, 734, 47, 1574, 564, 952, 957, 994, 1000, 1032, 1407, 736, 48, 547, 565, 953, 958, 1033, 1408, 932, 50, 58, 548, 566, 954, 1034, 1409, 59, 725, 838, 54, 55, 56, 57, 967, 1160, 1603, 483, 61, 67, 1134, 1150, 976, 959, 484, 681, 939, 692, 772, 800, 1155, 821, 824, 831, 841, 869, 880, 1158, 884, 913, 919, 944, 970, 1014, 1019, 1001, 1009, 1066, 1077, 1073, 1110, 1113, 1126, 1139, 1161, 1279, 1479, 1483, 1521, 1535, 1575, 60, 66, 1135, 1151, 977, 960, 485, 591, 682, 940, 691, 773, 801, 1156, 822, 825, 832, 842, 870, 881, 1159, 885, 914, 921, 945, 971, 1018, 1024, 1002, 1010, 1068, 1078, 1074, 1111, 1114, 1127, 1144, 1162, 1280, 1484, 1522, 1536, 1576, 62, 1136, 1152, 978, 961, 486, 592, 1378, 802, 1015, 1020, 1003, 1011, 1075, 1137, 1153, 979, 962, 487, 1377, 803, 1016, 1021, 1004, 1012, 1076, 65, 69, 1154, 980, 963, 1017, 1022, 1013, 64, 70, 981, 964, 1023, 965, 966, 1379, 1383, 876, 1284, 1291, 1115, 1119, 1140, 1145, 1392, 1398, 1480, 1523, 1528, 1537, 1541, 1387, 877, 1285, 1292, 1116, 1120, 1141, 1146, 1390, 1402, 1481, 1527, 1533, 1538, 1542, 1381, 1384, 1286, 1293, 1117, 1121, 1142, 1147, 1393, 1399, 1524, 1529, 1539, 1543, 1382, 1385, 1287, 1294, 1118, 1122, 1143, 1148, 1395, 1525, 1530, 1540, 1544, 1386, 1288, 1295, 1123, 1149, 1391, 1401, 1526, 1531, 1545, 1389, 1289, 1296, 1394, 1403, 1532, 1290, 1397, 1404)) AND (t_d.attribute_id IN ('72')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))