select * from (select id,bt,rq,coverpic,(select newsbkeys.pid from newsbkeys where newsbkeys.pid=newsb.id and (0 or newsbkeys.keyword="砂磨机" or newsbkeys.keyword="研磨" or newsbkeys.keyword="研磨介质" or newsbkeys.keyword="氧化铝" or newsbkeys.keyword="玛瑙" or newsbkeys.keyword="氧化锆" or newsbkeys.keyword="硅酸锆" or newsbkeys.keyword="搅拌磨" or newsbkeys.keyword="耐驰" or newsbkeys.keyword="瑞驰拓维" or newsbkeys.keyword="派勒" or newsbkeys.keyword="密克朗" or newsbkeys.keyword="布勒") limit 0,1) as keypid from newsb where fl=4 and status=2 and isfenxiangtongreport=0 order by id desc limit 0,1000) as tmpage where id=keypid order by id desc limit 0,10