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 ')
ORDER BY pd.products_viewed DESC LIMIT 0, 10' at line 5
SELECT p.products_id, p.products_quantity, p.products_model, p.manufacturers_id, p.products_image, p.products_price, p.products_retail_price, p.products_delivery, p.products_tax_class_id, pd.products_name, pd.products_description FROM products p
LEFT JOIN products_description pd ON p.products_id = pd.products_id
LEFT JOIN products_to_categories pc ON p.products_id = pc.products_id
WHERE p.products_status = '1'
AND ()
ORDER BY pd.products_viewed DESC LIMIT 0, 10
