全国椅旁技师/临床支持招聘

select Id,UserId,Job_Title,Valid_Time,Province,City,area,sex,Salary,Per_Count,F_P_Job,Degree_Request,UpdateTime,Salary_rangeid,govjobId,age,Age_Compare,welfare,Work_Years,yingjiesheng,zaijiaosheng from KQ36_Job.dbo.[Com_Job] where Show=1 and isDel=0 and vip_job=4 and Co_verify=1 and (charindex('',250,'','',''+cast(classII_id as varchar(10))+'',''+ClassII_ID_1+'','')>0 or charindex('',160,'','',''+ClassIII_ID_1+'','')>0) order by isTop desc,UpdateTime desc

页面执行时间：62,022,410.00毫秒