select c.classid,a.id,a.brandname,PhotoUrl 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><a href="/shop/Search_list.asp?id=1&brandid={$Field(id,GetInfoUrl,100,2)}"><img src="{$Field(PhotoUrl,Text,0,...,0,)}">{$Field(brandname,Text,0,...,0,)}</a></li>[/loop]