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 (56, 23, 25, 48, 26, 27, 3, 213, 5, 95, 73, 207, 83, 7, 96, 74, 136, 38, 13, 97, 75, 62, 218, 6, 98, 76, 49, 60, 61, 219, 9, 99, 77, 58, 221, 100, 78, 59, 205, 11, 79, 195, 12, 80, 89, 144, 17, 81, 90, 223, 8, 82, 142, 15, 63, 224, 10, 72, 137, 225, 19, 226, 21, 209, 227, 146, 47, 228, 20, 231, 187, 22, 169, 112, 229, 230, 140, 168, 232, 233, 212, 234, 235, 236, 167, 177, 145, 181, 104, 101, 166, 147, 237, 238, 214, 204, 239, 172, 173, 216, 148, 241, 138, 242, 243, 149, 244, 217, 245, 192, 246, 189, 247, 248, 249, 182, 250, 251, 252, 253, 191, 254, 215, 255, 257, 151, 185, 260, 261, 152, 262, 153, 263, 102, 256, 198, 210, 208, 190, 163, 222, 155, 188, 178, 186, 157, 179, 156, 193, 174, 259, 161, 171, 170, 184, 175, 159, 105, 158, 160, 150, 106, 180, 162, 197, 183, 240, 107, 194, 258, 29, 65, 203, 50, 114, 199, 122, 127, 41, 30, 69, 206, 51, 200, 121, 128, 35, 36, 37, 31, 70, 52, 116, 201, 129, 45, 14, 71, 53, 117, 154, 130, 39, 16, 66, 118, 42, 67, 55, 202, 44, 32, 68, 141, 43, 164, 165, 113)) AND (t_d.attribute_id IN (45, 182, 189, 190, 191, 192, 193, 194, 195, 196, 391, 387, 394, 397, 422)) 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_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 (56, 23, 25, 48, 26, 27, 3, 213, 5, 95, 73, 207, 83, 7, 96, 74, 136, 38, 13, 97, 75, 62, 218, 6, 98, 76, 49, 60, 61, 219, 9, 99, 77, 58, 221, 100, 78, 59, 205, 11, 79, 195, 12, 80, 89, 144, 17, 81, 90, 223, 8, 82, 142, 15, 63, 224, 10, 72, 137, 225, 19, 226, 21, 209, 227, 146, 47, 228, 20, 231, 187, 22, 169, 112, 229, 230, 140, 168, 232, 233, 212, 234, 235, 236, 167, 177, 145, 181, 104, 101, 166, 147, 237, 238, 214, 204, 239, 172, 173, 216, 148, 241, 138, 242, 243, 149, 244, 217, 245, 192, 246, 189, 247, 248, 249, 182, 250, 251, 252, 253, 191, 254, 215, 255, 257, 151, 185, 260, 261, 152, 262, 153, 263, 102, 256, 198, 210, 208, 190, 163, 222, 155, 188, 178, 186, 157, 179, 156, 193, 174, 259, 161, 171, 170, 184, 175, 159, 105, 158, 160, 150, 106, 180, 162, 197, 183, 240, 107, 194, 258, 29, 65, 203, 50, 114, 199, 122, 127, 41, 30, 69, 206, 51, 200, 121, 128, 35, 36, 37, 31, 70, 52, 116, 201, 129, 45, 14, 71, 53, 117, 154, 130, 39, 16, 66, 118, 42, 67, 55, 202, 44, 32, 68, 141, 43, 164, 165, 113)) AND (t_d.attribute_id IN (180, 183, 184, 185, 186, 187, 188, 377, 378, 381, 395, 396, 398, 421)) 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 (56, 23, 25, 48, 26, 27, 3, 213, 5, 95, 73, 207, 83, 7, 96, 74, 136, 38, 13, 97, 75, 62, 218, 6, 98, 76, 49, 60, 61, 219, 9, 99, 77, 58, 221, 100, 78, 59, 205, 11, 79, 195, 12, 80, 89, 144, 17, 81, 90, 223, 8, 82, 142, 15, 63, 224, 10, 72, 137, 225, 19, 226, 21, 209, 227, 146, 47, 228, 20, 231, 187, 22, 169, 112, 229, 230, 140, 168, 232, 233, 212, 234, 235, 236, 167, 177, 145, 181, 104, 101, 166, 147, 237, 238, 214, 204, 239, 172, 173, 216, 148, 241, 138, 242, 243, 149, 244, 217, 245, 192, 246, 189, 247, 248, 249, 182, 250, 251, 252, 253, 191, 254, 215, 255, 257, 151, 185, 260, 261, 152, 262, 153, 263, 102, 256, 198, 210, 208, 190, 163, 222, 155, 188, 178, 186, 157, 179, 156, 193, 174, 259, 161, 171, 170, 184, 175, 159, 105, 158, 160, 150, 106, 180, 162, 197, 183, 240, 107, 194, 258, 29, 65, 203, 50, 114, 199, 122, 127, 41, 30, 69, 206, 51, 200, 121, 128, 35, 36, 37, 31, 70, 52, 116, 201, 129, 45, 14, 71, 53, 117, 154, 130, 39, 16, 66, 118, 42, 67, 55, 202, 44, 32, 68, 141, 43, 164, 165, 113)) AND (t_d.attribute_id IN (181, 197, 379, 380, 390, 389, 388)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))