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

Author: Jay S. S. Albanese

Support
Jay Albanese is a professor in the Wilder School of Government & Public Affairs at Virginia Commonwealth University. He is the first Ph.D. graduate from the Rutgers University School of Criminal Justice. He served as Chief of the International Center at the National Institute of Justice, the research arm of the U.S. Department of Justice.  Dr. Albanese is author and editor of 20 books on organized crime, ethics, corruption, transnational crime, and criminal justice. He is recipient of the Distinguished Teaching Award from Virginia Commonwealth University, the Gerhard Mueller Award for research contributions from the Academy of Criminal Justice Sciences International Section, and the Distinguished Scholar Award from the International Association for the Study of Organized Crime. He is a past president and fellow of the Academy of Criminal Justice Sciences, and co-founder of Criminologists without Borders. www.jayalbanese.com




2 Ebooks by Jay S. S. Albanese

Philip L. Reichel & Jay S. Albanese: Handbook of Transnational Crime and Justice
Transnational crime and justice will characterize the 21st century in same way that traditional street crimes dominated the 20th century. In the Handbook of Transnational Crime and Justice, Philip Re …
EPUB
English
DRM
€77.99
Jay S. Albanese & Philip L. Reichel: Transnational Organized Crime
This unique text explores the expansive topic of transnational organized crime, incorporating expert perspectives found throughout the world’s six inhabited continents: North America, Central and Sou …
EPUB
English
DRM
€52.99