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 = '454319' 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 = '454319' 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 = '454319']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 454319 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= 454319]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Coral Reefs Of The Eastern Tropical Pacific: Persistence And Loss In A Dynamic Environment Título del capítulo: Marine Biodiversity of Eastern Tropical Pacific Coral Reefs
Autores UNAM: JOSE ANTONIO CRUZ BARRAZA;
Autores externos: Idioma: Año de publicación: 2017Palabras clave:
Reef invertebrates; Fishes; Algae; Plankton; Latin America
Resumen:
The eastern tropical Pacific (ETP) is an isolated oceanic region exposed
to extreme oceanographic conditions, including low salinity, low pH,
high temperatures during El Nino, and low temperatures during La Nina
and seasonal upwelling. The coral reefs in this region have a relatively
limited suite of species compared to other coral reef areas of the
world, but much like more diverse reefs the species present interact in
complex ways. Here we synthezise the knowledge of taxonomic groups of
reef organisms from prokaryotes to vertebrates, including algae,
sponges, cnidarians, annelids and other worms, molluscs, crustaceans,
echinoderms and fishes. We also present summaries on the biodiversity of
associated functional groups and habitats, including (a) reef
zooplankton and cryptic fauna, and (b) soft benthic environments,
rhodolith beds and mesophotic environments. Several factors that
structure the biodiversity of ETP coral reefs are explored, including
biological, physical and chemical controls. ETP coral reefs are
relatively simple systems that can be used as models for studying
biodiversity and interactions among species. We conclude this review by
highlighting pressing research needs, from very basic inventories to
more sophisticated studies of cryptic assemblages, and to investigations
on the impacts of natural and anthropogenic effects on ETP coral reef
biodiversity.