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

Brendan D. Kelly 
Dignity, Mental Health and Human Rights [PDF ebook] 
Coercion and the Law

Support

This book explores the human rights consequences of recent and ongoing revisions of mental health legislation in England and Ireland. Presenting a critical discussion of the World Health Organization”s ”Checklist on Mental Health Legislation” from its Resource Book on Mental Health, Human Rights and Legislation, the author uses this checklist as a frame-work for analysis to examine the extent to which mental health legislation complies with the WHO human rights standards. The author also examines recent case-law from the European Court of Human Rights, and looks in depth at the implications of the United Nations Convention on the Rights of Persons with Disabilities for mental health law in England and Ireland. Focusing on dignity, human rights and mental health law, the work sets out to determine to what extent, if any, human rights concerns have influenced recent revisions of mental health legislation, and to what extent recent developments in mental health law have assisted in protecting and promoting the human rights of the mentally ill. The author seeks to articulate better, clearer and more connected ways to protect and promote the rights of the mentally ill though both law and policy.

€61.77
payment methods
Buy this ebook and get 1 more FREE!
Format PDF ● Pages 232 ● ISBN 9781317150589 ● Publisher Taylor and Francis ● Published 2016 ● Downloadable 3 times ● Currency EUR ● ID 4859941 ● Copy protection Adobe DRM
Requires a DRM capable ebook reader

More ebooks from the same author(s) / Editor

128,769 Ebooks in this category