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

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

Título del libro: Fungi: Types, Environmental Impact And Role In Disease

Autores UNAM:
LAURA GABRIELA MORENO COUTIÑO; ROBERTO ARENAS GUZMAN;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2012

---

Resumen:

Ecological changes, human demographic modifications, international travel and commerce as well as fungal adaptation to the environment and its conditions such as antifungal drugs by genetic recombination cause emergence or re-emergence of infectious diseases. Cryptococcus species complex is a large genus, where the pathogenic species C. neoformans (var. neoformans and var. grubii) and C. gatti are the agents of cryptococcosis. This is a ubiquitous fungus, responsible for disease in both immunocompetent and immunocompromised hosts and causes approximately 600,000 deaths/yr in North America. C. neoformans is ubiquitous in the environment due to dissemination by pigeons following migratory and trade routes, and C. gattii is restricted to tropical/subtropical regions because it is not associated to pigeon guano, but to some tree species. Simultaneously, an increase of prevalence has been reported in patients living with HIV/AIDS, receiving aggressive cancer therapy or solid organ transplant recipients. Coccidioides immitis and C. posadasii are responsible for the most common respiratory mycoses. C. immitis is found in California and C. posadasii elsewhere. Although this disease is considered endemic, epidemic outbreaks have been documented, mostly related to droughts, as well as immigration of susceptible individuals. Immunosuppressed patients are the most severely affected, with various clinical manifestations. Some associated factors have been identified regarding the epidemics, while new approaches to treatment and prevention are being applied. Sporotrichosis is a subcutaneous mycosis caused by Sporothrix species complex fundamentally transmitted by traumatic inoculation with contaminated plants, wood, and other vegetable debris. Cases inoculated by animals, particularly cats, have been documented. This is sometimes considered an occupational disease because it commonly presents in gardeners and field workers, but epidemic outbreaks have occurred in several countries affecting people with different occupations, regardless of their immune status. © 2012 Nova Science Publishers, Inc. All rights reserved.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781619426719
Editorial:
Nova Science Publishers, Inc. Nombre de la publicación:
Fungi: Types, environmental impact and role in disease
Página inicial:
41
Página final:
58

Tipo de producto:
Capítulo de un Libro