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

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

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

2024-01-0125模板标签

标签:

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

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

2024-01-0122模板标签

标签:

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

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

2024-01-0123模板标签

标签:

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

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

2024-01-0121模板标签

标签:

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

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

2024-01-0122模板标签

标签:

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

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

2024-01-0127模板标签

标签:

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

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

2024-01-0124模板标签

标签:

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

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

2024-01-0125模板标签

标签:

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

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

2024-01-0127模板标签

标签:

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

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

2024-01-0119模板标签

标签: