ERROR

Vi är ledsna - även om vi gjorde vårt bästa: ett fel inträffade
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 = 17 AND categories_id = 000) AS cat1, (SELECT categories_id FROM categories_description WHERE language_id = 17 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2, (SELECT categories_id FROM categories_description WHERE language_id = 17 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3, (SELECT categories_id FROM categories_description WHERE language_id = 17 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categories_name FROM categories_description WHERE language_id = 17 AND categories_id = 000) AS cat1name, (SELECT categories_name FROM categories_description WHERE language_id = 17 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name, (SELECT categories_name FROM categories_description WHERE language_id = 17 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name, (SELECT categories_name FROM categories_description WHERE language_id = 17 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

مؤلف: Haixun Wang

الدعم

5 كتب إلكترونية بواسطة Haixun Wang

Charu C. Aggarwal & Haixun Wang: Managing and Mining Graph Data
Managing and Mining Graph Data is a comprehensive survey book in graph management and mining. It contains extensive surveys on a variety of important graph topics such as graph languages, indexing, c …
PDF
الإنجليزية
€213.99
James Bailey & Arbee L.P. Chen: Trends and Applications in Knowledge Discovery and Data Mining
This book constitutes the refereed proceedings at PAKDD Workshops 2014, held in conjunction with the 18th Pacific-Asia Conference on Knowledge Discovery and Data Mining (PAKDD) held in Tainan, Taiwan …
PDF
الإنجليزية
DRM
€115.20
Xiaohua Hu & Shijun Li: Web-Age Information Management
This book constitutes the refereed proceedings of the 12th International Conference on Web-Age Information Management, WAIM 2011, held in Wuhan, China in September 2011.The 53 revised full papers pre …
PDF
الإنجليزية
DRM
€104.41
Huajun Chen & Heng Ji: Knowledge Graph and Semantic Computing: Semantic, Knowledge, and Linked Big Data
This book constitutes the refereed proceedings of the first China Conference on Knowledge Graph and Semantic Computing, CCKS, held in Beijing, China, in September 2016.The 19 revised full papers pres …
PDF
الإنجليزية
DRM
€57.90