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="MLCC" 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="潮州三环" 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