mysqli_sql_exception: You 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 display_product_in_cart = 'Y'
AND pc.`...' at line 6 in /home/.sites/site4/wwwroot/.shop/global.php:430
Stack trace:
#0 /home/.sites/site4/wwwroot/.shop/global.php(430): mysqli_query(Object(mysqli), 'SELECT DISTINCT...')
#1 /home/.sites/site4/wwwroot/.shop/index.php(1922): mysql_query_('SELECT DISTINCT...')
#2 {main} SELECT DISTINCT product.id AS id,
pc.category_pc_id AS categoryid,
REPLACE(position(lower('term:Beverages term:Wine') IN lower(product.name)),'0','1000') AS pos
FROM category, product_category pc, product
LEFT JOIN productoption ON product.id = productoption.productid
WHERE (product.is_deleted='N') AND product.id IN ()
AND display_product_in_cart = 'Y'
AND pc.`product_pc_id` = product.`id`
AND category.id=category_pc_id AND category.is_deleted='N' AND (category.category_list = 'Y' OR category.category_list = 'C')
AND product.id=product_pc_id
GROUP BY product.`id`
ORDER BY product.name,pc.category_pc_id
LIMIT 0, 50 You 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 display_product_in_cart = 'Y'
AND pc.`...' at line 6
Search Results for Keyword(s):term:Beverages term:Wine(matching all words)
No matching products found. Please try a different keyword.
