3sql,! sql: select top 1 id,substring(croutetitle,1,25) as croutetitle1,croutetitle,startcity,(substring(trait,1,114)+'...') as trait,trait as trait1,adultrated,adultrated,radft,chkdd,txtdd from packages where typeid=14 and id in(select p.id from packages p left join AAE_GP_GroupProduct gp on gp.productId=p.id left join tuanhao_dj t on t.id=gp.groupid where t.category=14 and t.ctsj>'2019-09-22') order by id desc