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 = 8 AND categories_id = 000) AS cat1, (SELECT categories_id FROM categories_description WHERE language_id = 8 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2, (SELECT categories_id FROM categories_description WHERE language_id = 8 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3, (SELECT categories_id FROM categories_description WHERE language_id = 8 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categories_name FROM categories_description WHERE language_id = 8 AND categories_id = 000) AS cat1name, (SELECT categories_name FROM categories_description WHERE language_id = 8 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name, (SELECT categories_name FROM categories_description WHERE language_id = 8 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name, (SELECT categories_name FROM categories_description WHERE language_id = 8 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

Eva Pils 
China”s Human Rights Lawyers [PDF ebook] 
Advocacy and Resistance

Wsparcie

This book offers a unique insight into the role of human rights lawyers in Chinese law and politics. In her extensive account, Eva Pils shows how these practitioners are important as legal advocates for victims of injustice and how bureaucratic systems of control operate to subdue and marginalise them. The book also discusses how human rights lawyers and the social forces they work for and with challenge the system. In conditions where organised political opposition is prohibited, rights lawyers have begun to articulate and coordinate demands for legal and political change.

Drawing on hundreds of anonymised conversations, the book analyses in detail human rights lawyers’ legal advocacy in the face of severe institutional limitations and their experiences of repression at the hands of the police and state security apparatus, along with the intellectual, political and moral resources lawyers draw upon to survive and resist. Key concerns include the interaction between the lawyers and their bureaucratic, professional and social environments and the forms and long term political impact of resistance. In addressing these issues, Pils offers a rare evaluative perspective on China’s legal and political system, and proposes new ways to assess domestic advocacy’s relationship with international human rights and rule of law promotion.

This book will be of great interest and use to students and scholars of law, Chinese studies, socio-legal studies, political studies, international relations, and sociology. It is also of direct value to people working in the fields of human rights advocacy, law, politics, international relations, and journalism.

€59.18
Metody Płatności
Kup ten ebook, a 1 kolejny otrzymasz GRATIS!
Format PDF ● Strony 312 ● ISBN 9781134450619 ● Wydawca Taylor and Francis ● Opublikowany 2014 ● Do pobrania 3 czasy ● Waluta EUR ● ID 3475008 ● Ochrona przed kopiowaniem Adobe DRM
Wymaga czytnika ebooków obsługującego DRM

Więcej książek elektronicznych tego samego autora (ów) / Redaktor

116 530 Ebooki w tej kategorii