当前栏目品牌标签输出重复，谁能帮忙解决一下啊？







查询语句：select c.classid,a.id,a.brandname from (ks_classbrand a inner join ks_classbrandr b on a.id=b.brandid)  inner join ks_class c on b.classid=c.id where b.classid in({$CurrClassChildID}) order by a.id



[loop=20]

<li class="s_brand"><a href="/shop/Search_list.asp?id={$Field(classid,GetInfoUrl,100,2)}&brandid={$Field(id,GetInfoUrl,100,2)}">{$Field(brandname,Text,0,...,0,)}</a></li>

[/loop]

期待高手解答