• 密码登录
  • 手机登录
社交账号登录

文章近6个月添加数量统计标签

{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND FROM_UNIXTIME(ADD_TIME) BETWE...

2024-01-0143模板标签

标签:

文章上周添加数量统计标签

{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND YEARWEEK(date_format(FROM_UNI...

2024-01-0136模板标签

标签:

文章本周添加数量统计标签

{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND YEARWEEK(date_format(FROM_UNI...

2024-01-0141模板标签

标签:

文章去年添加数量统计标签

{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND YEAR(FROM_UNIXTIME(ADD_TIME))...

2024-01-0138模板标签

标签:

文章今年添加数量统计标签

{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND YEAR(FROM_UNIXTIME(add_time))...

2024-01-0134模板标签

标签:

文章上季度添加数量统计标签

{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND QUARTER(FROM_UNIXTIME(add_tim...

2024-01-0141模板标签

标签:

文章本季度添加数量统计标签

{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND QUARTER(FROM_UNIXTIME(add_tim...

2024-01-0139模板标签

标签:

文章上个月添加数量统计标签

{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND PERIOD_DIFF( date_format( now...

2024-01-0142模板标签

标签:

文章近本月添加数量统计标签

{eyou:sql sql=‘SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND DATE_FORMAT( FROM_UNIXTIME(add_ti...

2024-01-0145模板标签

标签:

文章近30天添加数量统计标签

{eyou:sql sql='SELECT count(aid) AS count FROM __PREFIX__archives WHERE status = 1 AND date(FROM_UNIXTIME(add_time))...

2024-01-0133模板标签

标签: