日期:2014-05-16 浏览次数:20771 次
SELECT date( from_unixtime( pubdate ) ) AS date, count( * ) AS num FROM dede_archives GROUP BY date( from_unixtime( pubdate ) )