聯(lián)系我們
{fzw:sql="select * from sl_sort where id=31" id="p1"}{fzw:p1:u3/}{/fzw:sql}
{fzw:sql="select top 1 * from sl_article where classid=32 order by paixu asc,id asc" id="p1"}
{/fzw:sql}
{fzw:sql="select top 1 * from sl_article where classid=32 and id not in (select top 1 id from sl_article where classid=32 order by paixu asc,id asc) order by paixu asc,id asc" id="p1"}
{/fzw:sql}
{fzw:sql="select top 1 * from sl_article where classid=32 and id not in (select top 2 id from sl_article where classid=32 order by paixu asc,id asc) order by paixu asc,id asc" id="p1"}
{/fzw:sql}
{fzw:sql="select * from sl_sort where id=31" id="p1"}{fzw:p1:u4/}{/fzw:sql}
{fzw:sql="select * from sl_sort where id=31" id="p1"}{fzw:p1:u9/}{/fzw:sql}
{fzw:sql="select * from sl_article where classid=33 order by paixu asc,id asc" id="p1"}
{/fzw:sql}
{/fzw:sql}
