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 = '478625' 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 = '478625' 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 = '478625']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 478625 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= 478625]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Proceedings Of 15th International Conference On Scientometrics And Informetrics Issi 2015 Título del capítulo: Sustained collaboration between researchers in Mexico and France in the field of chemistry
Co-authorship networks; Co-authorships; Collaborative research; Me-xico; Information science
Resumen:
We analyse the co-authorship and publication patterns of 863 mainstream WoS papers in the field of Chemistry co-authored between Mexican and French institutions from 1984 to 2013 with the purpose of identifying and characterizing the dynamics of sustained collaborative research partnerships in the field between the two countries. From a normalized set of the most productive authors with = 5 co-authorships we selected three Mexican scientists for a detailed analysis of their co-authorship network visualized using Gephi software and its development over time. The first was the most productive Mexican author from the main national university whose collaboration with France spanned the period from 1987-2012, while the second and third researchers work in provincial universities and whose collaboration with France is more recent but lasting 10 and 15 years respectively, and also continues up to the present day. Preliminary results suggest that sustained partnerships are driven by a strong central bond between the Mexican researcher and their foreign partner. In the first two cases, the bond is with directly with a French scientist but in the third, is stronger with an Italian rather than with the French counterpart.
