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

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

Título del libro: Arid And Semi-Arid Zones Of Mexico: A Comprehensive Exploration Of Biodiversity, Ecology, And Conservation
Título del capítulo: Medicinal flora and their specialized metabolites of arid and semi-arid areas of Mexico

Autores UNAM:
MA. EDITH LOPEZ VILLAFRANCO; SILVIA AGUILAR RODRIGUEZ; PATRICIA GUEVARA FEFER; FELIX KRENGEL; NALLELY ALVAREZ SANTOS; ADRIANA MONTSERRAT ESPINOSA GONZALEZ; EDGAR ANTONIO ESTRELLA PARRA; ISRAEL VALENCIA QUIROZ; ANA MARIA GARCIA BORES;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2025

---

Palabras clave:

Arid and semi-arid areas; Arid zones; Ethnobotanicals; Ethnobotany; Flavonoid; Me-xico; Medicinal plants; Phytochemical; Property; Semiarid zone

---

Resumen:

© 2025 Bentham Science Publishers. All rights reserved.This chapter compiles ethnobotanical records of medicinal flora in arid and semiarid zones of Mexico, covering 18 Mexican states. Phytochemical studies have been conducted on specialized metabolites of some species that, in some cases, attribute their medicinal properties. The flora compilation includes the scientific name, botanical family, popular name, and medicinal use. This review identified 691 records corresponding to 331 registered species, 219 genera, and 72 families. The five families with the highest numbers were Asteraceae (103), Fabaceae (40), Cactaceae (28), Euphorbiaceae (26), and Solanaceae (24). Popular nomenclature is recognized in 371 names in Spanish and/or indigenous languages. The plant most commonly mentioned is árnica (Grindelia inuloides), and some of its variants include árnica amarilla (Haplopappus spinulosus), árnica morada (Xanthisma gymnocephalum), and árnica silvestre (Adenophyllum aurantium). It is common for popular names to be related to the colors, chemical compounds, and/or biological forms of plants. The record of herbal resources associated with the illnesses grouped into systems shows that 122 species are used to treat digestive system conditions, whereas 61 species cure dermatological conditions. The states with the highest numbers of records were Aguascalientes, Puebla, and Sonora. Regarding specialized metabolites, studies have focused on phenolic compounds and terpenes in organic extracts. Mono- and sesquiterpenes are present in essential oils. Some species also have notable alkaloid contents. This chapter provides valuable information about the bioactive principles of plant-based medicinal resources in arid and semi-arid regions and demonstrates the therapeutic potential of Mexico's resources.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9789815322460
Editorial:
Bentham Science Publishers

Tipo de producto:
Book chapter

DOI:
10.2174/9789815322460125010011