MYSQL按天统计文档的语句_dede日期归类插件
SELECT date( from_unixtime( pubdate ) ) AS date, count( * ) AS num FROM dede_archives GROUP BY date( from_unixtime( pubdate ) )