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 = '540923' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '540923' 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 = '540923' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '540923' 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 = '540923']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '540923'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 540923 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= 540923]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 540923 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= 540923

Título del libro: Dysexecutive Syndromes: Clinical And Experimental Perspectives
Título del capítulo: Executive Dysfunction in Violent and Criminal Behavior

Autores UNAM:
FEGGY OSTROSKY SHEJET;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2019

---

Palabras clave:

PSYCHOPATHY; AGGRESSION; CORTEX; NEUROPSYCHOLOGY; EXPERIENCE; SPANISH; ANGER

---

Resumen:

Human behavior, including violent, volitional, and moral acts, are still under study due to the complexity of interaction between biological, cognitive, psychological, and environmental factors. However, damage in regions of the frontal lobe causing executive dysfunction has been consistently associated with difficulties in the regulation of behavior, increasing the probability for committing a violent act. Violence can be conceived as several behaviors (including verbal and psychological violence) in a wide range that goes from anger to homicide. There are also cognitive and affective factors that have been associated with the most serious manifestations of violence. The cognitive factors include low performance in neuropsychological task associated with hot executive functions (inhibition, emotional regulation, risk-benefit processing, and decision-making) related to orbito-frontal cortex functioning and less frequent problems with cold executive functions (working memory, planning, abstraction, cognitive flexibility). Emotional and psychological factors related to violence are high hostility traits, impulsivity and lack of empathy. The combination of these factors increases the possibility of committing a violent act. In this chapter, we discuss the importance of the interaction between the cognitive and the emotional/psychological factors for violent and criminal behavior. © Springer Nature Switzerland AG 2019.

---

Entidades citadas de la UNAM:

---

Fuente:



ISBN:
9783030250775
Editorial:
SPRINGER INTERNATIONAL PUBLISHING AG

Tipo de producto:
Article

DOI:
10.1007/978-3-030-25077-5_10