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

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

Título del libro: Advances In Marine Biology
Título del capítulo: Phytoplankton chlorophyll-a concentration associated with hydrographic conditions on the continental shelf in the southern gulf of Mexico

Autores UNAM:
SERGIO LICEA DURAN; RUTH LUNA SORIA; ROBERTO CORTES ALTAMIRANO; ARTEMIO GALLEGOS GARCIA; ISMAEL DE JESUS MARIÑO TAPIA; CECILIA ELIZABETH ENRIQUEZ ORTIZ;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2019

---

Palabras clave:

Bank of campeche; Chlorophyll; Gulf of Mexico; Hydrography; Microalgae; Phytoplankton; Upwelling; Yucatan

---

Resumen:

Phytoplankton chlorophyll-a data obtained on 27 oceanographic cruises in the southern Gulf of Mexico between 1979 and 2000 were analyzed. Four cruises were selected to report variations of chlorophyll-a associated with hydrographic conditions (temperature and salinity) in surface waters, one in April 1983 and three in 1987 in different seasons. The CTD casts were taken from 0 to 150 m depth aboard the R/V "Justo Sierra". Discrete water samples were collected to determine chlorophyll-a concentration by fluorometry. The observations showed that the autumn was characterized by high chlorophyll-a values (0.05 to 6.00 mg m-3), suggesting a real effect of the coastal lagoons and river fronts in late summer - early autumn along with the obvious effect of the Yucatan Current that greatly influences the coastal zone of the southeastern Gulf westward at least to 93oW. In summer the highest chlorophyll-a concentrations (up to 6.50 mg m-3) were observed in the eastern part of the study area. The lowest summer values (0.06 to 0.50 mg m-3) were found in the northeastern region (<0.10 mg m-3). Summer presents a typical stratified condition with most of the sites characterized by strong thermoclines with surface water temperatures from 25.0 to 28.9°C. River runoff contributes to the formation of a surface plume 2-8 m thick that extends seaward. In autumn a mixed water column induced by the effect of the northerlies produces a clear temperature decrease with values from 25.0 to 26.0°C from the surface to 55 m depth and a thermocline below. © 2019 Nova Science Publishers, Inc.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781536150452
Editorial:
Nova Science Publishers, Inc. Nombre de la publicación:
Phytoplankton chlorophyll-a concentration associated with hydrographic conditions on the continental shelf in the southern gulf of Mexico
Página inicial:
33
Página final:
56

Tipo de producto:
Capítulo de un Libro