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

Dmitrij Dobrovol’skij & Elisabeth Piirainen 
Figurative Language [PDF ebook] 
Cross-Cultural and Cross-Linguistic Perspectives

Support

The book develops a Theory of the Figurative Lexicon. Units of the figurative lexicon (conventional figurative units, CFUs for short) differ from all other elements of the language in two points: Firstly, they are conventionalized. That is, they are elements of the mental lexicon – in contrast to freely created figurative expressions. Secondly, they consist of two conceptual levels: they can be interpreted at the level of their literal reading and at the level of their figurative meaning – which both can be activated simultaneously.
New insights into the Theory of Figurative Lexicon relate, on the one hand, to the metaphor theory. Over time, it became increasingly clear that the Conceptual Metaphor Theory in the sense of Lakoff can only partly explain the conventional figurativeness. On the other hand, it became clear that “intertextuality” plays a far greater role in the CFUs of Western cultures than previously assumed.
The book’s main target audience will be linguists, researchers in phraseology, paremiology and metaphor, and cultural studies. The data and explanations of the idioms will provide a welcome textbook in courses on linguistics, culture history, phraseology research and phraseodidactics.

€159.95
payment methods

About the author

Dmitrij Dobrovol’skij, Moscow, Russia.

Buy this ebook and get 1 more FREE!
Language English ● Format PDF ● Pages 503 ● ISBN 9783110702538 ● File size 1.5 MB ● Publisher De Gruyter ● City Basel/Berlin/Boston ● Published 2021 ● Edition 2 ● Downloadable 24 months ● Currency EUR ● ID 8351909 ● Copy protection Adobe DRM
Requires a DRM capable ebook reader

More ebooks from the same author(s) / Editor

53,515 Ebooks in this category