SQL Prepare Error

Error Number: 42000

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 find_in_set('hienthi',b.status) GROUP BY b.id, b.namevi, b.photo ORDER ...' at line 1

select b.namevi, b.slugvi, b.slugen, b.id, b.photo, COUNT(p.id) AS total_products from table_product_brand as b LEFT JOIN table_product p ON p.id_brand = b.id and p.id_list=? where b.id in () and find_in_set('hienthi',b.status) GROUP BY b.id, b.namevi, b.photo ORDER BY b.numb,b.id desc