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 = '696668' 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 = '696668' 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 = '696668']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 696668 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= 696668]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Applicative Morphology: Neglected Syntactic And Non-Syntactic Functions Título del capítulo: Applicative periphrastic constructions in the Colombian Spanish from The Andes
Autores UNAM: SERGIO IBAÑEZ CERDA;
Autores externos: Idioma: Año de publicación: 2022Resumen:
This paper focuses on an applicative construction in Colombian Andean Spanish, specifically the variant spoken in Ipiales-Narino, a city in southwestern Colombia. The structure is an applicative periphrastic construction (APC), i.e., it is a bi-verbal structure where one of the verbs is the main semantic predicate and the other one, DAR 'give', functions as an applicative marker. The APC has several non-canonical features: first, it is mostly specialized in the introduction of a deputative-beneficiary applied phrase, which although coded as an object, does not increase the (semantic) valence of the root. Second, the applied phrase can also be a prepositional phrase (PP); in this case, the AP does not bear the role of deputative, but that of recipient-beneficiary or possessor. Third, the presence of the applicative DAR, besides allowing the introduction of the AP, entails a particular semantic feature in the clause agent: its referent must be involved in the denoted event in an unexpected fashion, as a special favor to the deputative-beneficiary introduced by the AP, to the speaker, or to someone else. This type of semantic effect has not been described for applicative morphology in other languages.
