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

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

Título del libro: Deep-Sea Pycnogonids And Crustaceans Of The Americas
Título del capítulo: Deep-Sea Lobsters (Polychelidae and Nephropidae) from the Continental Slope of the Southern Gulf of Mexico: Distribution and Morphometric Relationships

Autores UNAM:
PATRICIA DOLORES BRIONES FOURZAN; ENRIQUE LOZANO ALVAREZ; ANA ROSA VAZQUEZ BADER; ADOLFO GRACIA GASCA;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2021

---

Palabras clave:

Allometry; Distribution; Megacrustaceans; Morphometric relationships; Nephropidae; Polychelidae; Southern Gulf of Mexico

---

Resumen:

Information on biodiversity from the continental slope of the southern half of the Gulf of Mexico is scarce. Deep-sea lobsters were collected from depths of 300-1090 m (upper continental slope) in all sectors of the southern Gulf of Mexico during several research cruises aimed to survey the benthic biodiversity from this slope. Individuals were sexed, and their carapace length (CL, mm), total length (TL, mm), and weight (W, g) were measured. In all, 3343 lobsters were collected from nine species, four of the family Polychelidae (from more to less abundant: Stereomastis sculpta, Polycheles perarmatus, P. typhlops, Cardus crucifer) and five of the family Nephropidae (Nephropsis aculeata, N. rosea, Acanthacaris caeca, N. neglecta, Thaumastocheles zaleucus). Multivariate analyses revealed differences in the lobster assemblage among 200-m depth strata, mostly due to the depth distribution of the two most abundant species: N. aculeata between 300 and 500 m and S. sculpta below 700 m. Within families, the median size varied significantly with species. In species with sufficient specimens, length-length and length-weight relationships were compared between sexes and tested for departure from isometry. This information is useful for comparing life history traits of individual species between regions and the relative condition of local populations within metapopulations. Deep-sea fisheries are currently nonexistent in the southern Gulf of Mexico and may be particularly difficult to develop over its generally rugged continental slope. Therefore, this area may be conserved as a spatial refugium for local populations of these deep-sea lobsters. © Springer Nature Switzerland AG 2020. All rights reserved.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9783030584108
Editorial:
Springer International Publishing Nombre de la publicación:
Deep-Sea Lobsters (Polychelidae and Nephropidae) from the Continental Slope of the Southern Gulf of Mexico: Distribution and Morphometric Relationships
Página inicial:
311
Página final:
341

Tipo de producto:
Capítulo de un Libro

DOI:
10.1007/978-3-030-58410-8_13