SQLÓï¾äÖ´ÐдíÎó£ºSELECT xtzrc_company_info.zpstate as zpstate, xtzrc_company_info.company_name as company , xtzrc_jobs.job  as job, xtzrc_jobs.ID as jobID, xtzrc_jobs.pub_time as pubtime, xtzrc_jobs.money as money   ,xtzrc_jobs.work_addr as workaddr,xtzrc_jobs.job_type as job_type,xtzrc_jobs.job_details as job_details,xtzrc_jobs.other_msg as other_msg,xtzrc_jobs.job_experience as job_experience, xtzrc_company_info.ID as comid,xtzrc_jobs.edu as edu ,xtzrc_jobs.state as state FROM xtzrc_jobs INNER JOIN xtzrc_company_info ON xtzrc_jobs.company_ID = xtzrc_company_info.ID WHERE  xtzrc_jobs.state in(0,3) and   xtzrc_company_info.vip<>1 and xtzrc_jobs.company_ID Is Not  Null and  zpstate<>1  and (xtzrc_jobs.job_class like'%0108%' or xtzrc_jobs.job_class like ',0108%' or xtzrc_jobs.job_class like ',0109%' or xtzrc_jobs.job_class like ',0109%') <br />Table '.\tehr_db\xtzrc_jobs' is marked as crashed and should be repaired