select top 10 a.id,brandname,PhotoUrl from ks_classbrand a inner join ks_classbrandr b on a.id=b.brandid where b.classid='{$CurrClassID}' order by a.orderid

循环体：

[loop=10]
<li><a target="_blank" href="{$GetInstallDir}shop/search_list.asp?brandid={$Field(ID,GetInfoUrl,100,2)}">
<img src="{$Field(PhotoUrl,Text,0,...,0,)}" width="88" height="31"></a>
<div class="clear"></div>
<span class="brandname"><a href="{$Field(ID,GetInfoUrl,100,1)}">{$Field(BrandName,Text,0,...,0,)}</a></span>
</li>
[/loop]