亚洲免费乱码视频,日韩 欧美 国产 动漫 一区,97在线观看免费视频播国产,中文字幕亚洲图片

      1. <legend id="ppnor"></legend>

      2. 
        
        <sup id="ppnor"><input id="ppnor"></input></sup>
        <s id="ppnor"></s>

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

        字號(hào):


            1、共有文章:** 篇
            {dede:sql sql=select count(*) as c from dede_archives where channel=1}·共有文章:[field:c /]篇{/dede:sql}
            2、共有圖集:** 個(gè)
            {dede:sql sql=select count(*) as c from dede_archives where channel=2}·共有圖集:[field:c /]個(gè){/dede:sql}
            3、共有軟件:** 個(gè)
            {dede:sql sql=select count(*) as c from dede_archives where channel=3}·共有軟件:[field:c /]個(gè){/dede:sql}
            4、共有評(píng)論:**條
            {dede:sql sql=select count(*) as c from dede_feedback}·共有評(píng)論:[field:c /]條{/dede:sql}
            5、共有會(huì)員:**名
            {dede:sql sql=select count(mid) as c from dede_member }·共有會(huì)員:[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}條