Query Error 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 'and p.price >= 2080 and p.price <= 3120 AND p.status = 1 ORDER BY p.cre' at line 4 Query: SELECT p.*,p.id FROM shop_product p WHERE p.category_id = and p.price >= 2080 and p.price <= 3120 AND p.status = 1 ORDER BY p.create_datetime DESC, p.id LIMIT 10