Cacher is the code snippet organizer for pro developers

select count(log_id), FROM_UNIXTIME(dateline, '%Y-%m-%d') from log where type=6 group by FROM_UNIXTIME(dateline, '%Y-%m-%d');