如何用sql語句統(tǒng)計dede欄目的文章數(shù)

    1、共有文章：** 篇
    {dede:sql sql=select count(*) as c from dede_archives where channel=1}·共有文章：[field:c /]篇{/dede:sql}
    2、共有圖集：** 個
    {dede:sql sql=select count(*) as c from dede_archives where channel=2}·共有圖集：[field:c /]個{/dede:sql}
    3、共有軟件：** 個
    {dede:sql sql=select count(*) as c from dede_archives where channel=3}·共有軟件：[field:c /]個{/dede:sql}
    4、共有評論：**條
    {dede:sql sql=select count(*) as c from dede_feedback}·共有評論：[field:c /]條{/dede:sql}
    5、共有會員：**名
    {dede:sql sql=select count(mid) as c from dede_member }·共有會員：[field:c /]名{/dede:sql}
    6、文章閱讀：** 人次
    {dede:sql sql=select sum(click) as c from dede_archives}文章閱讀：[field:c /]人次{/dede:sql}
    7、今日更新：**篇
    {dede:sql sql=select count( * ) as c from dede_archives where pubdate > unix_timestamp( curdate( ) ) }今日更新：[field:c /]篇{/dede:sql}
    8、總共留言：
    {dede:sql sql=select count(*) as cc from dede_guestbook}[field:cc/]{/dede:sql}條