Mine

update statistic2   set
hits =  hits + (select count(*) from content_hit as h1 where statistic2.user_id=h1.user_id and statistic2.content_id = h1.content_id), 
unique_hits = unique_hits + (select sum(numips) from (select count(distinct(h2.ip)) as numips from content_hit as h2 where content_hit.user_id=statistic2.user_id and content_hit.content_id=s.content_id and posted=1 and valid=1 group by year(created_date), month(created_date), day(created_date)) v1 ),
clicks  =  clicks + (select count(*) from content_click as c1 where statistic2.user_id=c1.user_id and statistic2.content_id = c1.content_id),
unique_clicks = unique_clicks + (select sum(numips) from (select count(distinct(c2.ip)) as numips from content_click as c2 where c2.user_id=statistic2.user_id and c2.content_id=statistic2.content_id and active=1 group by year(created_date), month(created_date), day(created_date) ) v2);


'stat_id', 'int(11) unsigned', 'NO', 'PRI', '', 'auto_increment'
'user_id', 'int(11)', 'NO', 'MUL', '', ''
'content_id', 'int(11) unsigned', 'NO', 'MUL', '', ''
'daysran', 'int(11)', 'NO', '', '0', ''
'duration', 'int(11)', 'NO', '', '0', ''
'hits', 'int(11) unsigned', 'NO', '', '0', ''
'unique_hits', 'int(11) unsigned', 'NO', '', '0', ''
'clicks', 'int(11) unsigned', 'NO', '', '0', ''
'unique_clicks', 'int(11) unsigned', 'NO', '', '0', ''
'amount', 'float', 'NO', '', '0', ''