SQL代码收集

1、调用包含子栏目的信息。

select top 5 id,title,PhotoUrl,Price from KS_Product where tid in(select id from ks_class where ts like '%{$Param(0)}%')  and deltf=0 and verific=1 order by id

使用时：{SQL_首页各品牌最新产品(20209884894801)} 

2、取得当前栏目ID下的栏目和子栏目（两个SQL联用）

 一、通用分类外：select ClassID,ID,FolderName from KS_Class where tn='{$CurrClassID}' AND classtype=1 and TopFlag=1 order by folderorder,classid

[loop=12]

<li>

 <div class="classtitle" style="font-weight:bold"><a href="{$Field(classid,GetInfoUrl,100,1)}" target="_blank">{$Field(foldername,Text,0,...,0,)}</a>

</div>

 <div class="list">

   {SQL_通用分类内({$Field(id,GetInfoUrl,100,2)})}

 </div>

</li>

[/loop]

二、通用分类内select top 20 ClassID,ID,FolderName from KS_Class where tn='{$Param(0)}' order by folderorder,classid

[loop=20]

<a href="{$Field(id,GetInfoUrl,100,1)}" target="_blank">{$Field(foldername,Text,0,...,0,)}</a>

[/loop]

使用时：{SQL_通用分类外()}