SELECT a.id as id,a.orderid,a.picurl,a.linkurl,a.title as title,a.brandpid,a.brandid,a.year,a.delstate,a.checkinfo,b.id as bid,b.gid as gid FROM `#@__goods` as a LEFT JOIN `#@__goods_list` as b on a.id=b.gid where (a.typeid=3 OR a.typepstr LIKE '%,3,%') AND a.delstate='' AND a.checkinfo=true GROUP BY a.title ORDER BY a.title DESC, a.id DESC,b.id DESC