Cobi
1064 - 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 p.products_delivery = 'ihned'
AND pd.products_name <> ''
AND' at line 13
SELECT DISTINCT p.suppliers_prefered, p.products_id, p.products_delivery, pd.products_name, pd.products_description, p.products_delivery, p.products_image, p.manufacturers_id, p.size, p.age_from, p.age_to,
IFNULL(pp.products_tax_class_id, p.products_tax_class_id) AS products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price
FROM products p LEFT JOIN products_prices pp ON pp.products_id = p.products_id AND pp.language_id = '10'
LEFT JOIN specials s on p.products_id = s.products_id,
products_description pd,
products_to_categories_active p2c, categories c
WHERE
( p2c.categories_id = 474 )
AND pd.language_id = '10'
AND ( )
AND p.products_delivery = 'ihned'
AND pd.products_name <> ''
AND p.products_status = '1'
AND p.products_id = pd.products_id
AND p.products_id = p2c.products_id
AND p2c.categories_id = c.categories_id
ORDER BY p.suppliers_prefered desc, p.products_ordered_last_3_month desc, pd.products_name limit 6
[TEP STOP]