select cyd.IndexNO,InRange,PTStatus,STStatus1,STStatus2,DateDeadLine,DateST1DeadLine,DateST2DeadLine,Priority from cyd where (PTRoom="食品检验部" or STRoom1="食品检验部" or STRoom2="食品检验部") and ((PTStatus="已审核" or PTStatus="已改正" or PTStatus="已批准" or PTStatus="有错误") or (STStatus1="已审核" or STStatus1="已改正" or STStatus1="已批准" or STStatus1="有错误") or (STStatus2="已审核" or STStatus2="已改正" or STStatus2="已批准" or STStatus2="有错误")) order by cyd.indexno desc limit 4000