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

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

Título del libro: Conservation Biology: Voices From The Tropics
Título del capítulo: CHALLENGES AND OPPORTUNITIES FOR CONSERVATION OF MEXICAN BIODIVERSITY

Autores UNAM:
GERARDO JORGE CEBALLOS GONZALEZ; ANDRES GARCIA AGUAYO;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2013

---

Palabras clave:

DRY FORESTS; MAMMALS; DIVERSITY; HOTSPOTS

---

Resumen:

The world is clearly at a major turning point. Now, for the first time in human history, scientists are concerned about the possible collapse of global civilization. That is because the local components of the global ecosystem that support our lives and economy are tightly interconnected. In this context, the future of biodiversity largely depends on the future of human population growth, levels of individual consumption, the choice of particular technologies, and the conservation actions we take at national and regional scales. Mexico is one of the top five most biodiverse countries in the world, hosting up to 10% of all living species, many of them endemic to the country. However, the country faces severe environmental problems derived from its rapid human population growth, high poverty levels, and the war on drugs, among other factors. Climate change, habitat fragmentation, illegal hunting, overexploitation of wild populations, pollution, and invasive species are some of the major drivers of biodiversity loss in Mexico. For example, at least 70 vertebrate species in the country have become extinct or extirpated in the last 100 years and deforestation rates remain at about 260,000 hectares (ha) per year. The main conservation challenge is to reduce environmental degradation to maintain biodiversity, ecosystem services, and human well-being. In this context, Mexico has made a heroic effort in the last two decades to preserve its biodiversity despite its economic, social, and political problems. Conservation policies have been focused at both species and ecosystems, and much progress has been achieved in the form of suitable conservation policies, the development of a protected area network, and the identification of endangered and priority species.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9780470658635
Editorial:
JOHN WILEY & SONS LTD

Tipo de producto:
Article