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 = '621138' 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 = '621138' 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 = '621138']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 621138 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= 621138]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Routledge Handbook Of Spanish Morphology Título del capítulo: The basic infectional structure of verbs (I) Aspect, tense, mood and agreement
The infectional structure of the Spanish verb is complex due to the
confuence of several grammatical categories: tense, aspect and mood on
the one hand, number and person on the other. Spanish, however, is not a
language with concatenative infectional morphology and does not present
specifc morphemes for each of these categories. Because of this, there
are mismatches between the semantic categories and the morphs that
represent them; in other words, there is less phonological material than
semantic categories. This problem means that segmentation in morphemes
is not systematic and that there are various ways to analyse the
structure of the verbal word, depending on the analytical model or the
methodological posture assumed. In this chapter I will show, briefy, the
problems that come with segmentation into morphemes, the most common
generalizations that have been found and the diferent solutions
proposed. Also, after careful analysis of the behaviour of verbal
paradigms, I will propose a split of the tenses according to the way of
representing grammatical categories in infectional morphemes: on the one
hand, tenses where a homogeneous and diferentiated segmentation of
infectional marks is possible; on the other, those where it is not
possible to segment those categories. This analysis allows identifcation
of the regularities that exist in verbal infection and explains, to some
extent, the exceptions.
