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