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 = '382804' 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 = '382804' 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 = '382804']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 382804 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= 382804]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Biotechniques For Air Pollution Control - Proceedings Of The 3rd International Congress On Biotechniques For Air Pollution Control Título del capítulo: Alkaline biofiltration of volatile sulfur compound odors
Autores UNAM: ARMANDO GONZALEZ SANCHEZ;
Autores externos: Idioma: Año de publicación: 2010Palabras clave:
BACKGROUND: An alkaline mineral medium was used previously to enhance the absorption rate of hydrogen sulfide in a odor biofiltration process. In this work a high operating pH (?10) was used to perform the biotrickling filtration of carbon disulfide and ethanethiol odors, here a mathematical model was developed and validated under dynamic operation. RESULTS: The solubility of carbon disulfide and ethanethiol was increased around 50% and 80% respectively by using an alkaline mineral medium instead of pure water. The alkaline biotrickling filter reached maximum elimination capacities for carbon disulfide of 2.3 g m -3 h -1 and 3.5 g m -3 h -1 for ethanethiol case, both with removal efficiencies around 50%. CONCLUSION: The absorption of carbon disulfide and ethanethiol under alkaline condition is enhanced, nonetheless, the elimination capacity of the alkaline biotrickling filter was limited by the bacterial consortium activity, which was corroborated by the mathematical model.