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 ') group by id order by stt desc' at line 1syntax error: select p.* from table_product p where 1 and p.hienthi = 1 and id_cat in () group by id order by stt desc