ERROR

Lo sentimos, aunque hicimos todo lo posible: ocurrió un error
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 = 3 AND categories_id = 000) AS cat1, (SELECT categories_id FROM categories_description WHERE language_id = 3 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2, (SELECT categories_id FROM categories_description WHERE language_id = 3 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3, (SELECT categories_id FROM categories_description WHERE language_id = 3 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categories_name FROM categories_description WHERE language_id = 3 AND categories_id = 000) AS cat1name, (SELECT categories_name FROM categories_description WHERE language_id = 3 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name, (SELECT categories_name FROM categories_description WHERE language_id = 3 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name, (SELECT categories_name FROM categories_description WHERE language_id = 3 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

Karsten Altenhain & Reinhold Görling 
Die Wiederkehr der Folter? [PDF ebook] 
Interdisziplinäre Studien über eine extreme Form der Gewalt, ihre mediale Darstellung und ihre Ächtung

สนับสนุน

Since the signing of the international conventions prohibiting torture, this extreme form of violence seemed to remain a problem only in individual dictatorships. Discussions over the permissibility of ‘preventive’ torture or torture to save people’s lives and methods practised in the ‘war on terror’ question this assumption. Since the mid-1990s there has been an increase in the portrayal of torture on television, in films and computer games, and even in its use by positive heroes. At the same time medical and psychological evidence testifies to the serious psychological consequences of torture for the victims. Torture not only threatens individuals but also the fundamental social cohesion of human life.The contributions to this volume discuss various aspects of torture. They range from media law provisions to the visual representation of torture, how torture is dealt with in the context of legal residential status procedures, and how medicine and psychology relate to torture and historical and current legal discourse.

€75.00
วิธีการชำระเงิน

เกี่ยวกับผู้แต่ง

Prof. Dr. Johannes Kruse lehrt an den Universitäten Gießen und Marburg und ist Direktor der Klinik für Psychosomatische Medizin und Psychotherapie des Universitätsklinikums Gießen und Marburg.

ซื้อ eBook เล่มนี้และรับฟรีอีก 1 เล่ม!
ภาษา เยอรมัน ● รูป PDF ● หน้า 379 ● ISBN 9783847000082 ● ขนาดไฟล์ 2.4 MB ● บรรณาธิการ Karsten Altenhain & Reinhold Görling ● สำนักพิมพ์ V&R unipress ● เมือง Göttingen ● ประเทศ DE ● การตีพิมพ์ 2012 ● ฉบับ 1 ● ที่สามารถดาวน์โหลดได้ 24 เดือน ● เงินตรา EUR ● ID 3051123 ● ป้องกันการคัดลอก ไม่มี

หนังสืออิเล็กทรอนิกส์เพิ่มเติมจากผู้แต่งคนเดียวกัน / บรรณาธิการ

79,312 หนังสืออิเล็กทรอนิกส์ในหมวดหมู่นี้