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 = '614789' 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 = '614789' 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 = '614789' 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 = '614789' 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 = '614789']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '614789'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 614789 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= 614789]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 614789 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= 614789

Título del libro: Pgpr: Biocontrol And Biofertilization
Título del capítulo: Bacterial biofertilizers

Autores UNAM:
JOSE DE JESUS CABALLERO MELLADO;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2006

---

Palabras clave:

Bacterial inoculation; Endophytic bacteria; Nitrogen fixation; Phytohormones; Plant growth promoting rhizobacteria; Rhizosphere bacteria

---

Resumen:

Many bacteria and fungi can enhance plant growth. The present review is limited to plant growth promoting rhizobacteria (PGPR). However, it includes endophytic bacteria that show plant growth enhancing activity as well. Also the best studied bacterial mechanisms of plant growth promotion are discussed, with a special emphasis on biological nitrogen fixation and synthesis of phytohormones, including less understood mechanisms like inhibition of plant ethylene synthesis, degradation of organic-P compounds, phenazine-related mineral solubilization, and synthesis of lumichrome. In addition, examples of PGPR genes that show activation in the interaction with plants, and beneficial events resulting from plant-bacterial interactions like stress relief and enhancement of other ecological associations are presented. Plant growth promoting activity and more precisely, crop yield enhancement are the final effects of the different mechanisms that PGPR possess and are the applicative goal of the agricultural microbiology research. Despite the undoubted economic and ecological benefits of utilizing some PGPR species as biofertilizers, the application of such a species must be very carefully assessed because of their importance as opportunistic pathogens in nosocomial infections and in patients with other diseases. On this basis, PGPR species must be selected for producing safe biofertilizers. Strain selection, as also the number of the bacterial cells, and characteristics of the bacterial cultures used in the production of biofertilizers, as well as, results of inoculation of different crops and cultivars with Azospirillum under field conditions are also included in the discussion. © 2006 Springer.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
1402040024
Editorial:
Springer Netherlands Nombre de la publicación:
Bacterial biofertilizers
Página inicial:
143
Página final:
172

Tipo de producto:
Capítulo de un Libro

DOI:
10.1007/1-4020-4152-7_5