27,579
社区成员
发帖
与我相关
我的任务
分享
DECLARE @I INT
SET @I=getdate()-180
select * from duduxiong WHERE active=1 and key1=1 and faburiqi>= @I
and exists(select null from Personlanguage b where smt_id=b.perid and languages0='英语')
order by faburiqi desc