Originally Posted by Varius

select from_unixtime(time,"%Y-%m-%d") as date, views, title from test group by time order by date desc, views desc;

EDIT: as sarettah said while I was off taking a shower