select top 50 * from( select x.barname_c,x.click_i,x.starorder_i,x.autoid,count(barid_i) as num from barinfo(nolock) x,barcomment where ifdisp_B='1' and x.autoid=barcomment.barid_i group by x.BarName_C,click_i,starorder_i,x.autoid,Type_C,barid_i) a order by click_i desc
from(
select x.barname_c,x.click_i,x.starorder_i,x.autoid,count(barid_i) as num
from barinfo(nolock) x,barcomment
where ifdisp_B='1' and x.autoid=barcomment.barid_i
group by x.BarName_C,click_i,starorder_i,x.autoid,Type_C,barid_i) a
order by click_i desc