select Id, UserId, Set_Resume, RealName, Sex, Birth_Year, Degree, title, Weight, Height, Work_Years, H_Place, H_Province_v1, Salary, F_P_Jobs, Work_Title, Vip_Per, UpdateTime, Viptime, ClassI_ID, ClassII_ID, ClassII_ID_1,ClassIII_ID_1, Address_Province, Address_City,isImg from KQ36_Per.dbo.[Per_Info] where Off_Work_Time=4 and isvalidsms=1 and ((classI_id=1 and classII_id=10) or (classi_id<>2 and charindex('',10,'','',''+ClassII_ID_1+'','')>0 )) order by Vip_Per desc,UpdateTime desc