¿µÇ¿Ò½ÁÆÈ˲ÅÍø-ÈÃÈ«ÇòÒ½ÁÆÈËÇáËÉÕÒ¹¤×÷
»áÔ±µÇ¼|»áÔ±×¢²á|appÏÂÔØ
ÕÐƸְλ | ÕÐƸ¹«Ë¾ | ¹¤×÷µØµã | ·¢²¼ÈÕÆÚ
ÔÝÎÞÏà¹ØÐÅÏ¢
¹²(600)Ìõ
ÉÏÒ»Ò³ÉÏÒ»Ò³

¸½½ü³ÇÊÐËÑË÷

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 City_id = 65 and (F_P_Job like ''%×ø°à¼æÖ°%'') and (charindex('',99,'','',''+cast(classII_id as varchar(10))+'',''+ClassII_ID_1+'','')>0 or charindex('',130,'','',''+cast(classII_id as varchar(10))+'',''+ClassII_ID_1+'','')>0) order by isTop desc,UpdateTime desc
Ò³ÃæÖ´ÐÐʱ¼ä£º54,963,560.00ºÁÃë