select top 10 mingjiaid,name,pic,niandaiid,zuopincount,introduce,viewnum,adddate from zihua_mingjia where mingjiaid not in (select top 30 mingjiaid from zihua_mingjia where 0=0 order by quanid asc,viewnum desc, recommend desc,mingjiaid desc ) and 0=0 order by quanid asc,viewnum desc, recommend desc,mingjiaid desc