{dede:sql sql="SELECT count( * ) AS c FROM cmsxx_archives WHERE pubdate > UNIX_TIMESTAMP( CURDATE( ) ) "}
            <li class="count">今日更新：<span>[field:c/]</span> 篇</li>
            {/dede:sql}
            {dede:sql sql="Select count(ID) as c From cmsxx_archives WHERE FROM_UNIXTIME(pubdate,'%m')=month(curdate())"}
            <li class="count">当月更新：<span>[field:c/]</span> 篇</li>
            {/dede:sql}
              {dede:sql sql="select count(*) as c from cmsxx_archives}
            <li class="count">共有文章：<span>[field:c/]</span> 篇</li>
            {/dede:sql}
            {dede:sql sql="select sum(click) as c from cmsxx_archives"}
            <li class="count">总共阅读：<span>[field:c/]</span> 人次</li>
            {/dede:sql}
            {dede:sql sql="select count(mid) as c from cmsxx_member "}
            <li class="count">共有会员：<span>[field:c/]</span> 名</li>
            {/dede:sql}

还可以指定栏目ID，例如：
              {dede:sql sql="select count(*) as c from cmsxx_archives where channel in(1,2,3,5,6,9)"}
            <li class="count">共有文章：<span>[field:c/]</span> 篇</li>
            {/dede:sql}