3sql,! sql: select top 3 id,croutetitle from packages where id in(select productId from (select gp.productId,convert(datetime,case when isdate(t.ctsj)>0 then t.ctsj else null end) as ctsj from AAE_GP_GroupProduct gp left join tuanhao_dj t on t.id=gp.groupid where t.category=14) as tab where ctsj>'2019/10/21') and typeid=14 order by id desc