syntax error: select ten_vi, tenkhongdau_vi, id, thumb from table_category_list INNER JOIN (select group_concat(thuonghieu separator ',') thuonghieu from table_product where type='product' and hienthi = 1 and id_list='53') p ON FIND_IN_SET(id, p.thuonghieu) where hienthi=1 order by stt,id desc