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

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

Título del libro: Consequences Of Microbial Interactions With Hydrocarbons, Oils, And Lipids: Production Of Fuels And Chemicals
Título del capítulo: Application of Microorganisms to the Processing and Upgrading of Crude Oil and Fractions

Autores UNAM:
MARCELA AYALA ACEVES; RAFAEL VAZQUEZ DUHALT; MIGUEL ANGEL MORALES MENDOZA;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2017

---

Resumen:

Biotechnology has been successfully applied at the industrial level in the medical, fine chemical, agricultural, and food sectors. Several applications of biotechnology in the oil and energy industry in the future can also be foreseen. The production of biofuels in large volumes is now a reality, although there are some concerns about the use of land, water, and crops to produce fuels. In the oil industry, biotechnology has found its place in bioremediation and microbial enhanced oil recovery (MEOR). There are other opportunities in the processing (biorefining) and upgrading (bio-upgrading) of problematic oil fractions and heavy crude oils. In the context of increasing energy demand, conventional oil depletion, climate change, and increased environmental regulations on atmospheric emissions, biotechnologies such as biodesulfurization, biodenitrogenation, and aromatic ring opening (biodearomatization) and upgrading of heavy oils (degradation of asphaltenes and removal of metals) recover interest. In this chapter we revise the status of current regulations regarding fuel properties that have repercussions on its environmental impact, such as sulfur and nitrogen content, cetane number, and aromatic content, mainly in the EU and USA. We describe the cumulative and highlight the recent scientific and technological advances of these biotechnologies; their advantages and limitations are also discussed. On this basis, the possibility of integration in oil production plants and future oil refineries and biorefineries for the production of oil, fuels, and chemicals is analyzed.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9783319504360
Editorial:
SPRINGER INTERNATIONAL PUBLISHING AG

Tipo de producto:
Article

DOI:
10.1007/978-3-319-50436-0_205