Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CNY) BETWEEN 1001 AND 1250
GROUP BY products_id
order by products' at line 37] in EXECUTE("
select COUNT(*) AS prodCount
from (
select b.products_id, products_image, products_name, product_image_thumbnail, categories_parent_name, categories_parent_id,
categories_name, categories_id, description_name,
description, manufacturers_id,
products_code, products_price, products_tax_class_id
from (
select p.products_image, pd.products_name, cp.categories_parent_name, cp.categories_parent_id,
cd.categories_name, cd.categories_id, pd.description_name,
pd.description, p.products_code, p.products_id, p.manufacturers_id, p.product_image_thumbnail,
fqp.price2 AS products_price, p.products_tax_class_id
in /var/www/html/lib/sd_m/dbconn/adodb/adodb-exceptions.inc.php on line 78
|
