select top 16 hybh,ggtp,gsmc from fczhongjie where sftgyz=1 and ggtp<>'' and blz6='浦东' and blz8 like '%碧云%' and hybh in(select a.hybh from cjgl a,tsxz b where a.id=b.cjglid and b.xxlx='商铺租售') order by blz1 asc