SELECT date( from_unixtime( pubdate ) ) AS date, count( * ) AS num FROM dede_archives GROUP BY date( from_unixtime( pubdate ) )
做dedecms日期归类插件不可少的语句
SELECT date( from_unixtime( pubdate ) ) AS date, count( * ) AS num FROM dede_archives GROUP BY date( from_unixtime( pubdate ) )