3sql,! sql: select id,croutetitle from packages where id in(select gp.productId from AAE_GP_GroupProduct gp inner join tuanhao_dj t on t.id=gp.groupid where convert(char(10), t.ctsj, 120)>=convert(char(10), getdate(), 120)) and typeid=7 and (fl='52' or fl like '%%')