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 = 7 WHERE (e.entity_id IN (1165, 1190, 1209, 1217, 1234, 1247, 1259, 1281, 1581, 1303, 1376, 1166, 1191, 1210, 1218, 1248, 1260, 1304, 1371, 1593, 1488, 1564, 1171, 1211, 1226, 1253, 1265, 1305, 1372, 1592, 1489, 1565, 1175, 1198, 1373, 1547, 1178, 1201, 1374, 1548, 1182, 1469, 1246, 1235, 1236, 1493, 1167, 1172, 1176, 1179, 1183, 1192, 1196, 1202, 1212, 1214, 1219, 1227, 1237, 1241, 1249, 1254, 1261, 1266, 1299, 1457, 1571, 1549, 1554, 1168, 1173, 1177, 1180, 1184, 1193, 1197, 1213, 1215, 1228, 1238, 1242, 1250, 1255, 1267, 1300, 1458, 1572, 1550, 1555, 1169, 1174, 1181, 1185, 1194, 1216, 1229, 1239, 1243, 1251, 1256, 1263, 1495, 1551, 1556, 1170, 1186, 1205, 1230, 1240, 1244, 1252, 1257, 1264, 1269, 1496, 1552, 1557, 1187, 1231, 1245, 1297, 1258, 1270, 1553, 1558, 1207, 1459, 1464, 1497, 1502, 1460, 1465, 1498, 1503, 1461, 1466, 1499, 1504, 1462, 1501, 1505, 1463, 1500, 1506)) 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 = 7 WHERE (e.entity_id IN (1165, 1190, 1209, 1217, 1234, 1247, 1259, 1281, 1581, 1303, 1376, 1166, 1191, 1210, 1218, 1248, 1260, 1304, 1371, 1593, 1488, 1564, 1171, 1211, 1226, 1253, 1265, 1305, 1372, 1592, 1489, 1565, 1175, 1198, 1373, 1547, 1178, 1201, 1374, 1548, 1182, 1469, 1246, 1235, 1236, 1493, 1167, 1172, 1176, 1179, 1183, 1192, 1196, 1202, 1212, 1214, 1219, 1227, 1237, 1241, 1249, 1254, 1261, 1266, 1299, 1457, 1571, 1549, 1554, 1168, 1173, 1177, 1180, 1184, 1193, 1197, 1213, 1215, 1228, 1238, 1242, 1250, 1255, 1267, 1300, 1458, 1572, 1550, 1555, 1169, 1174, 1181, 1185, 1194, 1216, 1229, 1239, 1243, 1251, 1256, 1263, 1495, 1551, 1556, 1170, 1186, 1205, 1230, 1240, 1244, 1252, 1257, 1264, 1269, 1496, 1552, 1557, 1187, 1231, 1245, 1297, 1258, 1270, 1553, 1558, 1207, 1459, 1464, 1497, 1502, 1460, 1465, 1498, 1503, 1461, 1466, 1499, 1504, 1462, 1501, 1505, 1463, 1500, 1506)) 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 = 7 WHERE (e.entity_id IN (1165, 1190, 1209, 1217, 1234, 1247, 1259, 1281, 1581, 1303, 1376, 1166, 1191, 1210, 1218, 1248, 1260, 1304, 1371, 1593, 1488, 1564, 1171, 1211, 1226, 1253, 1265, 1305, 1372, 1592, 1489, 1565, 1175, 1198, 1373, 1547, 1178, 1201, 1374, 1548, 1182, 1469, 1246, 1235, 1236, 1493, 1167, 1172, 1176, 1179, 1183, 1192, 1196, 1202, 1212, 1214, 1219, 1227, 1237, 1241, 1249, 1254, 1261, 1266, 1299, 1457, 1571, 1549, 1554, 1168, 1173, 1177, 1180, 1184, 1193, 1197, 1213, 1215, 1228, 1238, 1242, 1250, 1255, 1267, 1300, 1458, 1572, 1550, 1555, 1169, 1174, 1181, 1185, 1194, 1216, 1229, 1239, 1243, 1251, 1256, 1263, 1495, 1551, 1556, 1170, 1186, 1205, 1230, 1240, 1244, 1252, 1257, 1264, 1269, 1496, 1552, 1557, 1187, 1231, 1245, 1297, 1258, 1270, 1553, 1558, 1207, 1459, 1464, 1497, 1502, 1460, 1465, 1498, 1503, 1461, 1466, 1499, 1504, 1462, 1501, 1505, 1463, 1500, 1506)) 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 = 7 WHERE (e.entity_id IN (1165, 1190, 1209, 1217, 1234, 1247, 1259, 1281, 1581, 1303, 1376, 1166, 1191, 1210, 1218, 1248, 1260, 1304, 1371, 1593, 1488, 1564, 1171, 1211, 1226, 1253, 1265, 1305, 1372, 1592, 1489, 1565, 1175, 1198, 1373, 1547, 1178, 1201, 1374, 1548, 1182, 1469, 1246, 1235, 1236, 1493, 1167, 1172, 1176, 1179, 1183, 1192, 1196, 1202, 1212, 1214, 1219, 1227, 1237, 1241, 1249, 1254, 1261, 1266, 1299, 1457, 1571, 1549, 1554, 1168, 1173, 1177, 1180, 1184, 1193, 1197, 1213, 1215, 1228, 1238, 1242, 1250, 1255, 1267, 1300, 1458, 1572, 1550, 1555, 1169, 1174, 1181, 1185, 1194, 1216, 1229, 1239, 1243, 1251, 1256, 1263, 1495, 1551, 1556, 1170, 1186, 1205, 1230, 1240, 1244, 1252, 1257, 1264, 1269, 1496, 1552, 1557, 1187, 1231, 1245, 1297, 1258, 1270, 1553, 1558, 1207, 1459, 1464, 1497, 1502, 1460, 1465, 1498, 1503, 1461, 1466, 1499, 1504, 1462, 1501, 1505, 1463, 1500, 1506)) 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 = 7 WHERE (e.entity_id IN (1165, 1190, 1209, 1217, 1234, 1247, 1259, 1281, 1581, 1303, 1376, 1166, 1191, 1210, 1218, 1248, 1260, 1304, 1371, 1593, 1488, 1564, 1171, 1211, 1226, 1253, 1265, 1305, 1372, 1592, 1489, 1565, 1175, 1198, 1373, 1547, 1178, 1201, 1374, 1548, 1182, 1469, 1246, 1235, 1236, 1493, 1167, 1172, 1176, 1179, 1183, 1192, 1196, 1202, 1212, 1214, 1219, 1227, 1237, 1241, 1249, 1254, 1261, 1266, 1299, 1457, 1571, 1549, 1554, 1168, 1173, 1177, 1180, 1184, 1193, 1197, 1213, 1215, 1228, 1238, 1242, 1250, 1255, 1267, 1300, 1458, 1572, 1550, 1555, 1169, 1174, 1181, 1185, 1194, 1216, 1229, 1239, 1243, 1251, 1256, 1263, 1495, 1551, 1556, 1170, 1186, 1205, 1230, 1240, 1244, 1252, 1257, 1264, 1269, 1496, 1552, 1557, 1187, 1231, 1245, 1297, 1258, 1270, 1553, 1558, 1207, 1459, 1464, 1497, 1502, 1460, 1465, 1498, 1503, 1461, 1466, 1499, 1504, 1462, 1501, 1505, 1463, 1500, 1506)) AND (t_d.attribute_id IN ('72')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))