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 = '613638' 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 = '613638' 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 = '613638']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 613638 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= 613638]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Proceedings Of The Solar World Congress 2005: Bringing Water To The World, Including Proceedings Of 34th Ases Annual Conference And Proceedings Of 30th National Passive Solar Conference Título del capítulo: Solar energy based water potabilization: Low-cost technologies for isolated regions of Latin America and the Caribbean
Arsenic removal; Heterogeneous photocatalysis; Isolated regions; Latin America and the Caribbean; Low-cost technology; Potabilization; Rural population; Safe drinking water; Solar disinfection; Water matrices; Photocatalysis; Pollution control; Titanium dioxide; Disinfection
Resumen:
Low-cost technologies, based on the use of solar energy, are proposed in the framework of the OAS/AE/141/2001 project to provide safe drinking water in isolated rural populations of Latin America and the Caribbean, with scarce hydric and economical resources. The offered technologies are Solar Disinfection in Individual Units (SODIS-DSAUI), Arsenic Removal by Solar Oxidation (SORAS-RAOS) and Solar Heterogeneous Photocatalysis with Titanium Dioxide (HP). It was found that DSAUI can be applied in all cases for disinfection, although HP can treat simultaneously bacterial and chemical contamination. RAOS is efficient in synthetic samples but the applicability to real waters is very dependent on the water matrix. All results are described and discussed together with actions to impulse the application by disseminating the methods and educating the population.
