ERROR

Het spijt ons - hoewel we ons best hebben gedaan: er is een fout opgetreden
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 = 18 AND categories_id = 000) AS cat1, (SELECT categories_id FROM categories_description WHERE language_id = 18 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2, (SELECT categories_id FROM categories_description WHERE language_id = 18 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3, (SELECT categories_id FROM categories_description WHERE language_id = 18 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categories_name FROM categories_description WHERE language_id = 18 AND categories_id = 000) AS cat1name, (SELECT categories_name FROM categories_description WHERE language_id = 18 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name, (SELECT categories_name FROM categories_description WHERE language_id = 18 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name, (SELECT categories_name FROM categories_description WHERE language_id = 18 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: Sikhulekile Duma

Support
Nicky Prins is a freelance analyst, focusing on understanding ‘business unusual’ practices in South Africa’s state-owned entities, in support of efforts to combat corruption. She is a former chief director of the Capital Projects Appraisal Unit at the National Treasury in South Africa.




2 Ebooks by Sikhulekile Duma

Cover of Ivor Chipkin & Mark Swilling: Shadow State
Ivor Chipkin & Mark Swilling: Shadow State
The 2017 publication of Betrayal of the Promise, the report that detailed the systematic nature of state capture, marked a key moment in South Africa’s most recent struggle for democracy. In the face …
EPUB
English
DRM
€28.99
Cover of Haroon Bhorat & Mbongiseni Buthelezi: Shadow State
Haroon Bhorat & Mbongiseni Buthelezi: Shadow State
The 2017 publication of Betrayal of the Promise, the report that detailed the systematic nature of state capture, marked a key moment in South Africa’s most recent struggle for democracy. In the face …
PDF
English
DRM
€19.28