SELECT DATE(FROM_UNIXTIME(ts)) as date, count(ts) as cnt FROM log GROUP BY DAY(date) ORDER BY ts desc;