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 = 1 WHERE (e.entity_id IN (10281, 3, 4, 26, 5, 27, 10003, 10120, 10272, 28, 10140, 10277, 30, 76, 131, 93, 109, 10380, 10121, 10416, 10425, 74, 132, 94, 119, 10266, 10007, 10122, 10417, 10426, 54, 10102, 10100, 10099, 127, 153, 10004, 10123, 10418, 10427, 10098, 81, 142, 105, 154, 10006, 10124, 10420, 10428, 68, 167, 138, 100, 155, 10218, 10363, 10419, 10429, 59, 78, 133, 95, 156, 10365, 10171, 10421, 66, 77, 97, 10422, 55, 57, 134, 10091, 222, 10294, 10107, 135, 10329, 136, 96, 10377, 10311, 137, 98, 10376, 10199, 56, 223, 139, 10009, 10431, 10162, 10196, 10245, 80, 99, 82, 141, 102, 10012, 10106, 90, 10038, 10217, 10216, 103, 10101, 10243, 64, 106, 65, 10105, 10110, 67, 70, 168, 48, 10386, 51, 10413, 10401, 10079, 10179, 10142, 10151, 10185, 10094, 10036, 10180, 10152, 10361, 10221, 10301, 10184, 217, 10334, 53, 83, 10096, 50, 10215, 10241, 10310, 10061, 10059, 10269, 10141, 10237, 10064, 10423, 89, 10054, 10403, 10050, 207, 183, 10406, 10192, 10268, 10404, 115, 10051, 10270, 10407, 10397, 208, 10405, 123, 10408, 10432, 85, 10371, 112, 121, 10232, 10315, 10370, 113, 122, 10328, 88, 10341, 10108, 116, 125, 213, 10247, 117, 126, 10393, 10330, 215)) AND (t_d.attribute_id IN ('139', '57', '253', '67', '148', '149', '258', '263', '59', '64', '47', '259', '235', '277', '260', '261', '238', '140', '142', '143', '51', '50', '254', '224', '138', '58', '146', '150', '151', '189', '252', '279', '147', '223', '249')) 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 (10281, 3, 4, 26, 5, 27, 10003, 10120, 10272, 28, 10140, 10277, 30, 76, 131, 93, 109, 10380, 10121, 10416, 10425, 74, 132, 94, 119, 10266, 10007, 10122, 10417, 10426, 54, 10102, 10100, 10099, 127, 153, 10004, 10123, 10418, 10427, 10098, 81, 142, 105, 154, 10006, 10124, 10420, 10428, 68, 167, 138, 100, 155, 10218, 10363, 10419, 10429, 59, 78, 133, 95, 156, 10365, 10171, 10421, 66, 77, 97, 10422, 55, 57, 134, 10091, 222, 10294, 10107, 135, 10329, 136, 96, 10377, 10311, 137, 98, 10376, 10199, 56, 223, 139, 10009, 10431, 10162, 10196, 10245, 80, 99, 82, 141, 102, 10012, 10106, 90, 10038, 10217, 10216, 103, 10101, 10243, 64, 106, 65, 10105, 10110, 67, 70, 168, 48, 10386, 51, 10413, 10401, 10079, 10179, 10142, 10151, 10185, 10094, 10036, 10180, 10152, 10361, 10221, 10301, 10184, 217, 10334, 53, 83, 10096, 50, 10215, 10241, 10310, 10061, 10059, 10269, 10141, 10237, 10064, 10423, 89, 10054, 10403, 10050, 207, 183, 10406, 10192, 10268, 10404, 115, 10051, 10270, 10407, 10397, 208, 10405, 123, 10408, 10432, 85, 10371, 112, 121, 10232, 10315, 10370, 113, 122, 10328, 88, 10341, 10108, 116, 125, 213, 10247, 117, 126, 10393, 10330, 215)) AND (t_d.attribute_id IN ('71', '70', '141', '209', '54', '145', '53', '239', '159', '240')) 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 = 1 WHERE (e.entity_id IN (10281, 3, 4, 26, 5, 27, 10003, 10120, 10272, 28, 10140, 10277, 30, 76, 131, 93, 109, 10380, 10121, 10416, 10425, 74, 132, 94, 119, 10266, 10007, 10122, 10417, 10426, 54, 10102, 10100, 10099, 127, 153, 10004, 10123, 10418, 10427, 10098, 81, 142, 105, 154, 10006, 10124, 10420, 10428, 68, 167, 138, 100, 155, 10218, 10363, 10419, 10429, 59, 78, 133, 95, 156, 10365, 10171, 10421, 66, 77, 97, 10422, 55, 57, 134, 10091, 222, 10294, 10107, 135, 10329, 136, 96, 10377, 10311, 137, 98, 10376, 10199, 56, 223, 139, 10009, 10431, 10162, 10196, 10245, 80, 99, 82, 141, 102, 10012, 10106, 90, 10038, 10217, 10216, 103, 10101, 10243, 64, 106, 65, 10105, 10110, 67, 70, 168, 48, 10386, 51, 10413, 10401, 10079, 10179, 10142, 10151, 10185, 10094, 10036, 10180, 10152, 10361, 10221, 10301, 10184, 217, 10334, 53, 83, 10096, 50, 10215, 10241, 10310, 10061, 10059, 10269, 10141, 10237, 10064, 10423, 89, 10054, 10403, 10050, 207, 183, 10406, 10192, 10268, 10404, 115, 10051, 10270, 10407, 10397, 208, 10405, 123, 10408, 10432, 85, 10371, 112, 121, 10232, 10315, 10370, 113, 122, 10328, 88, 10341, 10108, 116, 125, 213, 10247, 117, 126, 10393, 10330, 215)) 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 = 1 WHERE (e.entity_id IN (10281, 3, 4, 26, 5, 27, 10003, 10120, 10272, 28, 10140, 10277, 30, 76, 131, 93, 109, 10380, 10121, 10416, 10425, 74, 132, 94, 119, 10266, 10007, 10122, 10417, 10426, 54, 10102, 10100, 10099, 127, 153, 10004, 10123, 10418, 10427, 10098, 81, 142, 105, 154, 10006, 10124, 10420, 10428, 68, 167, 138, 100, 155, 10218, 10363, 10419, 10429, 59, 78, 133, 95, 156, 10365, 10171, 10421, 66, 77, 97, 10422, 55, 57, 134, 10091, 222, 10294, 10107, 135, 10329, 136, 96, 10377, 10311, 137, 98, 10376, 10199, 56, 223, 139, 10009, 10431, 10162, 10196, 10245, 80, 99, 82, 141, 102, 10012, 10106, 90, 10038, 10217, 10216, 103, 10101, 10243, 64, 106, 65, 10105, 10110, 67, 70, 168, 48, 10386, 51, 10413, 10401, 10079, 10179, 10142, 10151, 10185, 10094, 10036, 10180, 10152, 10361, 10221, 10301, 10184, 217, 10334, 53, 83, 10096, 50, 10215, 10241, 10310, 10061, 10059, 10269, 10141, 10237, 10064, 10423, 89, 10054, 10403, 10050, 207, 183, 10406, 10192, 10268, 10404, 115, 10051, 10270, 10407, 10397, 208, 10405, 123, 10408, 10432, 85, 10371, 112, 121, 10232, 10315, 10370, 113, 122, 10328, 88, 10341, 10108, 116, 125, 213, 10247, 117, 126, 10393, 10330, 215)) 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 = 1 WHERE (e.entity_id IN (10281, 3, 4, 26, 5, 27, 10003, 10120, 10272, 28, 10140, 10277, 30, 76, 131, 93, 109, 10380, 10121, 10416, 10425, 74, 132, 94, 119, 10266, 10007, 10122, 10417, 10426, 54, 10102, 10100, 10099, 127, 153, 10004, 10123, 10418, 10427, 10098, 81, 142, 105, 154, 10006, 10124, 10420, 10428, 68, 167, 138, 100, 155, 10218, 10363, 10419, 10429, 59, 78, 133, 95, 156, 10365, 10171, 10421, 66, 77, 97, 10422, 55, 57, 134, 10091, 222, 10294, 10107, 135, 10329, 136, 96, 10377, 10311, 137, 98, 10376, 10199, 56, 223, 139, 10009, 10431, 10162, 10196, 10245, 80, 99, 82, 141, 102, 10012, 10106, 90, 10038, 10217, 10216, 103, 10101, 10243, 64, 106, 65, 10105, 10110, 67, 70, 168, 48, 10386, 51, 10413, 10401, 10079, 10179, 10142, 10151, 10185, 10094, 10036, 10180, 10152, 10361, 10221, 10301, 10184, 217, 10334, 53, 83, 10096, 50, 10215, 10241, 10310, 10061, 10059, 10269, 10141, 10237, 10064, 10423, 89, 10054, 10403, 10050, 207, 183, 10406, 10192, 10268, 10404, 115, 10051, 10270, 10407, 10397, 208, 10405, 123, 10408, 10432, 85, 10371, 112, 121, 10232, 10315, 10370, 113, 122, 10328, 88, 10341, 10108, 116, 125, 213, 10247, 117, 126, 10393, 10330, 215)) AND (t_d.attribute_id IN ('72')) AND (t_d.store_id = IFNULL(t_s.store_id, 0))