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

Autor: Eduardo N. Sanchez

Ajutor

4 Ebooks de Eduardo N. Sanchez

Copertina de Eduardo N Sanchez: Excel and the World Wide Web Straight to the Point
Eduardo N Sanchez: Excel and the World Wide Web Straight to the Point
If you have an Excel workbook that needs to regularly harvest data from a web page, this book is for you. The book covers various methods for getting data from the web, from VBA to Selenium to Power …
EPUB
Engleză
DRM
€7.73
Copertina de Eduardo N Sanchez: Programming PowerPoint With VBA Straight to the Point
Eduardo N Sanchez: Programming PowerPoint With VBA Straight to the Point
This book assumes you already use Power Point and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, th …
EPUB
Engleză
DRM
€9.01
Copertina de MrExcel's Holy Macro! Books & Eduardo N Sanchez: Excel and the World Wide Web Straight to the Point
MrExcel’s Holy Macro! Books & Eduardo N Sanchez: Excel and the World Wide Web Straight to the Point
This book is a comprehensive guide for integrating web data into Excel, ideal for both beginners and experienced users. It begins by introducing essential concepts like HTML and JSON, laying the foun …
EPUB
Engleză
€4.99
Copertina de MrExcel's Holy Macro! Books & Eduardo N Sanchez: Programming PowerPoint With VBA Straight to the Point
MrExcel’s Holy Macro! Books & Eduardo N Sanchez: Programming PowerPoint With VBA Straight to the Point
This book dives deep into the world of Power Point VBA with this practical guide. Starting with basic operations, the book moves through advanced automation techniques, covering themes, layouts, and …
EPUB
Engleză
€5.99