ERROR

Nous sommes désolés - même si nous avons fait de notre mieux: une erreur est survenue
Typedatabase
MessageYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near "AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categorie..." at line 5
QuerySELECT (SELECT categories_id FROM categories_description WHERE language_id = 4 AND categories_id = 000) AS cat1, (SELECT categories_id FROM categories_description WHERE language_id = 4 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2, (SELECT categories_id FROM categories_description WHERE language_id = 4 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3, (SELECT categories_id FROM categories_description WHERE language_id = 4 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categories_name FROM categories_description WHERE language_id = 4 AND categories_id = 000) AS cat1name, (SELECT categories_name FROM categories_description WHERE language_id = 4 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name, (SELECT categories_name FROM categories_description WHERE language_id = 4 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name, (SELECT categories_name FROM categories_description WHERE language_id = 4 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4name, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 000) AS cat1url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4url, (SELECT wod_count_products FROM categories WHERE categories_id = 000) AS cat1cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3cnt, (SELECT wod_count_products FROM categories WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4cnt

Rocco J. Gennaro 
Disturbed Consciousness [PDF ebook] 
New Essays on Psychopathology and Theories of Consciousness

Support

Essays defend, discuss, and critique specific theories of consciousness with respect to various psychopathologies.In Disturbed Consciousness, philosophers and other scholars examine various psychopathologies in light of specific philosophical theories of consciousness. The contributing authors-some of them discussing or defending their own theoretical work-consider not only how a theory of consciousness can account for a specific psychopathological condition but also how the characteristics of a psychopathology might challenge such a theory. Thus one essay defends the higher-order thought (HOT) theory of consciousness against the charge that it cannot account for somatoparaphrenia (a delusion in which one denies ownership of a limb). Another essay argues that various attempts to explain away such anomalies within subjective theories of consciousness fail.Other essays consider such topics as the application of a model of unified consciousness to cases of brain bisection and dissociative identity disorder; prefrontal and parietal underconnectivity in autism and other psychopathologies; self-deception and the self-model theory of subjectivity; schizophrenia and the vehicle theory of consciousness; and a shift in emphasis away from an internal (or brainbound) approach to psychopathology to an interactive one. Each essay offers a distinctive perspective from the intersection of philosophy, consciousness research, and psychiatry.Contributors Alexandre Billon, Andrew Brook, Paula Droege, Rocco J. Gennaro, Philip Gerrans, William Hirstein, Jakob Hohwy, Uriah Kriegel, Timothy Lane, Thomas Metzinger, Erik Myin, Inez Myin-Germeys, Myrto Mylopoulos, Gerard O’Brien, Jon Opie, J. Kevin O’Regan, Iuliia Pliushch, Robert Van Gulick

€128.59
payment methods
Buy this ebook and get 1 more FREE!
Language English ● Format PDF ● Pages 384 ● ISBN 9780262330213 ● Editor Rocco J. Gennaro ● Publisher The MIT Press ● Published 2015 ● Downloadable 3 times ● Currency EUR ● ID 4852270 ● Copy protection Adobe DRM
Requires a DRM capable ebook reader

More ebooks from the same author(s) / Editor

49,397 Ebooks in this category