SELECT left(click_time,10) as  dt,count(*) as ct,h_clicks.* FROM `h_clicks` where click_time > '2012-04-17' group by 1,click_type,click_info desc order by 1 desc,click_type desc,click_domain<table><tr><td colspan=5><tr><th><th>URL<th>Date<th>Click Type<th>Count<th>Info</table>