e800商城

select RW.* from(select PROD.*,rownum r from ( select A.prodid,A.psortid,A.labelid,A.prodname,A.prodseries,A.prodbrief,A.prodprice,A.prodservice,B.prodpricee800,i.imgurl,i.imgminiurl from Tb_prod A,Tb_prod_deal B,Tr_image_prod PI,Tb_image I,Tb_prod_pv PV where B.proddealable = 1 and A.prodid = PV.prodid(+) and PI.imgprodtype ='标准图' and PI.prodid = A.prodid(+) and PI.imgid = I.imgid and A.prodid = B.prodid and A.psortid =10 and A.labelid = 432 order by A.prodmodifydate desc) PROD where rownum <=16)RW where r>0