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="粉末冶金" or newsbkeys.keyword="烧结" or newsbkeys.keyword="窑炉" or newsbkeys.keyword="3D") 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