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="雷蒙磨" 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