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]