因?yàn)樵诹斜砟０逯胁恢С?自定義列表的字段"，所以用"自定義列表的字段"as "列表模板支持的字段"變量名。

1、調(diào)用所有專題
統(tǒng)計(jì)：select count(*) as total from [!db.pre!]enewszt
查詢：select ztname as title,ztpath as titleurl,ztimg as titlepic,addtime as newstime,intro as smalltext,ztpagekey as pagekey,ztid as classid from [!db.pre!]enewszt

2、調(diào)用指定專題下的所有子專題
統(tǒng)計(jì)：select count(*) as total from [!db.pre!]enewszt where zcid=2
查詢：select ztname as title,ztpath as titleurl,ztimg as titlepic,addtime as newstime,intro as smalltext,ztpagekey as pagekey,ztid as classid from [!db.pre!]enewszt where zcid=2

注釋：
因?yàn)?br /> ztname as title, ztpath as titleurl,ztimg as titlepic,addtime as newstime, intro as smalltext,ztpagekey as pagekey, ztid as classid
專題名稱 標(biāo)題 專題鏈接 標(biāo)題鏈接 專題圖片 標(biāo)題圖片 專題創(chuàng)建時(shí)間 文章發(fā)布時(shí)間 專題簡(jiǎn)介 文章簡(jiǎn)介 專題關(guān)鍵字 文章關(guān)鍵字 專題ID 文章ID
所以列表模板中：用"標(biāo)題"代替調(diào)用"專題名稱"其他以此類推

附加排列方式:order by ztid desc 使用方法加到上面查詢語句的最后面
及調(diào)用條數(shù) limit 1 使用方法加到上面排列方式的后面