Most posts on a given day

select date_format(time, '<a href="/%Y/%m/%d/">%d/%m/%Y</a>') as Day, count(*) as Posts from columnc group by Day order by Posts desc limit 30

Day Posts
26/03/2004 127
19/04/2005 62
22/04/2005 62
04/08/2005 60
09/08/2005 57
26/05/2004 52
21/07/2005 46
17/05/2004 45
07/03/2005 43
08/08/2005 42
01/11/2005 42
16/09/2005 41
05/09/2005 41
10/04/2006 41
28/02/2005 40
04/03/2005 39
08/03/2006 38
20/10/2005 38
27/05/2004 37
01/09/2005 37
19/10/2005 36
10/08/2005 36
11/08/2005 35
22/02/2005 35
18/07/2005 35
03/12/2003 33
05/01/2006 32
23/02/2005 31
25/07/2005 31
09/03/2005 31