Best selling products
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 p.products_ordered DESC LIMIT 4' at line 4 - [SELECT DISTINCT p.products_id FROM products p, orders o, orders_products op, products_to_categories p2c
WHERE p.products_id = op.products_id
AND op.orders_id = o.orders_id
AND p2c.products_id = p.products_id AND p.products_status = 1 AND ()
ORDER BY p.products_ordered DESC LIMIT 4]