SELECT FROM_UNIXTIME(published - 28800, '%Y %M') AS `date`, FROM_UNIXTIME(published - 28800, '%Y-%m') AS `date2`, COUNT(1) AS `total` FROM `wei_blog`.`post_index` WHERE (state > '0') AND (type_id IN('1', '3')) GROUP BY `date` ORDER BY `date` DESC LIMIT 15:SQLSTATE[42000]: Syntax error or access violation: 1055 'wei_blog.post_index.published' isn't in GROUP BY
... That didn't work on you? Dang. May we suggest a search, then?