select Id,Title,UpdateTime,Province,City,Addtime,Company,area,Stype,cfrom,jobsid,jobid,sendTime,GID,coLevel,ValidTime,bright,degree from KQ36.dbo.[KQ_govZp] where isCheck=1 and Province_id = 10 and city_id = 111 and area_id = 1019 and datediff(dd,getdate(),SendTime)>0 and stype<>2and Stype = 0 and case when degree is null or degree='不限' then 8 when degree='高中' then 2 when degree='中专' then 3 when degree='大专' then 4 when degree='本科' then 5 when degree='硕士' then 6 when degree='博士' then 7 end<=2 and charindex(',102,',','+ClassIII_ID_1)>0 order by UpdateTime desc,id desc