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_danhmuc = group by id order by stt desc