ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '625780' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '625780' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '625780' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '625780' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '625780']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '625780'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 625780 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 625780]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 625780 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 625780

Título del libro: The Encyclopedia Of Bacteriology Research Developments
Título del capítulo: Antimicrobial bacteriocins and peptidoglycan hydrolases: Beneficial metabolites produced by lactic acid bacteria

Autores UNAM:
ISRAEL GARCIA CANO; EDITH PONCE ALQUICIRA;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2021

---

Resumen:

Lactic acid bacteria (LAB) involve a diverse group of gram-positive bacteria that primarily produce lactic acid. For centuries LAB have been recognized as safe and employed for food processing due to their ability to control the adventurous microbiota in the elaboration of dairy products, vegetables, meats, coffee, cocoa, silages and fermented beverages; but also because of their contribution to the taste, flavor and texture. Moreover, probiotic LAB may offer health benefits by acting in the modulation of the immune system, helping to manage allergies and lactose intolerance; in addition to the prevention of gastrointestinal and urinary infections by reduction of pathogens. The ability of LAB to inhibit spoilage and pathogenic microorganisms is based on several mechanisms that include acidification, production of antimicrobials and competition for nutrients and adhesion niches. Antimicrobials include the lactic and acetic acids, but also a complex range of metabolites like hydrogen peroxide, diacetyl, antifungal short-chain fatty acids, pyroglutamic acid, as well as, antimicrobial peptides known as bacteriocins and antibacterial peptidoglycan hydrolases (PGHs). Bacteriocins refer to a diverse group of ribosomal antimicrobial peptides mainly active against closely-related and sensitive bacterial strains by formation of pores in the cytoplasmic membrane causing reduction of microbial competitors. Among them, nisin and other bacteriocins have been applied in the food and pharmaceutical industry to control Listeria monocytogenes and Staphylococcus aureus. On the other hand, PGH are proteins capable to cleave the peptidoglycan cell wall of gram-positive and gram-negative bacteria, examples include lysostaphin and lysozyme, which are highly active against Staphylococcus aureus. The objective of this chapter is to offer an overview of the characteristics and applications of bacteriocins and peptidoglycan hydrolases as part of the beneficial metabolites produced by LAB. © 2021 by Nova Science Publishers, Inc. All rights reserved.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781536193169
Editorial:
Nova Science Publishers, Inc. Nombre de la publicación:
Antimicrobial bacteriocins and peptidoglycan hydrolases: Beneficial metabolites produced by lactic acid bacteria
Página inicial:
165
Página final:
196

Tipo de producto:
Capítulo de un Libro