tfw select FROM_UNIXTIME( CEILING( UNIX_TIMESTAMP(saved_date) / (60*60) ) * (60*60), '%Y-%m-%d %H:%i:%S' ) AS ts_CEILING, count(if(error_type=0,1,NULL)) as count_0, count(if(error_type=1,1,NULL)) as count_1, count(if(error_type=2,1,NULL)) as count_2, count(if(error_type=3,1,NULL)) as count_3, count(if(error_type=4,1,NULL)) as count_4 from master_ru.log where (saved_date >=cast(cast( '2014-12-12 00:00:00' as date) as datetime) and saved_date<(cast(cast( '2014-12-12 00:00:00' as date) as datetime)+ INTERVAL 1 DAY)) and module_id= 3 GROUP BY FROM_UNIXTIME( CEILING( UNIX_TIMESTAMP(saved_date) / (60*60) ) * (60*60),'%Y-%m-%d %H:%i:%S' ) ORDER BY FROM_UNIXTIME( CEILING( UNIX_TIMESTAMP(saved_date) / (60*60) ) * (60*60),'%Y-%m-%d %H:%i:%S' ) ASC