ERROR

Chúng tôi xin lỗi - mặc dù chúng tôi đã cố gắng hết sức: đã xảy ra lỗi
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 = 20 AND categories_id = 000) AS cat1, (SELECT categories_id FROM categories_description WHERE language_id = 20 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2, (SELECT categories_id FROM categories_description WHERE language_id = 20 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3, (SELECT categories_id FROM categories_description WHERE language_id = 20 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categories_name FROM categories_description WHERE language_id = 20 AND categories_id = 000) AS cat1name, (SELECT categories_name FROM categories_description WHERE language_id = 20 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name, (SELECT categories_name FROM categories_description WHERE language_id = 20 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name, (SELECT categories_name FROM categories_description WHERE language_id = 20 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

David Hesse 
Warrior dreams [EPUB ebook] 
Playing Scotsmen in mainland Europe

Support

Why does a Parisian banker re-enact the medieval wars of Wallace and Bruce in his spare time? Why do more than 20, 000 people attend the Schotse Weekend bagpipe competition in Bilzen, Flanders? Why does an entire village in the Italian Alps celebrate a lost Scottish regiment? And why is there a Highland Games circuit of at least 30 kilted strength competitions in Austria, with dedicated athletes tossing hay-balls and pulling tractors?
This is the first study of the self-professed ‘Scots’ of Europe. It follows the many thousands of Europeans who are determined to discover their inner Scotsman, and argues that by imitating the Scots of popular imagination, the self-styled European Highlanders hope to reconnect with their own ancestors – their lost songs, traditions and tribes. They approach Scotland as a site of European memory.
This book explores issues of performance and celebration, memory and nostalgia, heritage and identity, and will be of interest to specialists on Scottish emigration and diaspora, Scottish history and myth, and to the ‘Scots’ of Europe themselves.

€114.99
méthodes de payement

Table des matières

Introduction: The Scots of Europe
1. Context: playing the past
2. The Scottish dreamscape: formation
3. The Scottish dreamscape: spread
4. Marching Scots: pipe bands
5. Only the strong: Highland Games
6. Our Scottish past: commemorations
7. Régiments du passé: re- enactment
8. Homecomings: finding neverland
9. Who’s like us? Scotland as a site of memory
Conclusion: Warrior dreams
Appendix A: Tables
Appendix B: Sample questionnaire
Bibliography
Index

A propos de l’auteur

David Hesse holds a Ph D from the University of Edinburgh and now works as a political correspondent for a Swiss daily newspaper in Washington D.C.

Achetez cet ebook et obtenez-en 1 de plus GRATUITEMENT !
Langue Anglais ● Format EPUB ● Pages 304 ● ISBN 9781847799166 ● Taille du fichier 4.6 MB ● Maison d’édition Manchester University Press ● Lieu Manchester ● Pays GB ● Publié 2014 ● Téléchargeable 24 mois ● Devise EUR ● ID 4822162 ● Protection contre la copie Adobe DRM
Nécessite un lecteur de livre électronique compatible DRM

Plus d’ebooks du même auteur(s) / Éditeur

161 744 Ebooks dans cette catégorie