Query Error SELECT a.* FROM fs_products as a LEFT JOIN fs_products_comments as c ON a.id = c.product_id WHERE a.category_id_wrapper like '%,4,%' AND a.published = 1 AND a.level = 6 AND a.age = 8 AND a.price >= and < 500000_-_1000000 GROUP BY a.id HAVING COALESCE(ROUND(AVG(c.rating)), 0) = 1 ORDER BY a.created_time DESC, a.id DESC LIMIT 0,9
Array ( [0] => 42000 [1] => 1064 [2] => 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 < 500000_-_1000000 GROUP BY a.id HAVING C...' at line 4 )