i-generation

[root@web1 20140110]# /www/aff/maintenance/20140110/stat_convert.php
select * from click_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and click_date < '2014-01-04 00:00:00'
update click_log_201401 set
m_id = 206
where aff_id = '0ioj2H8588739593'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '0ioj2H8588739593'
update action_log_201401 set
m_id = 206
where action_log_id = '20940'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1109' and p_id = 0
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
action_count_a = action_count_a - 1,
action_item_count_a = action_item_count_a - 1,
admit_count_a = admit_count_a - 1,
admit_item_count_a = admit_item_count_a - 1,
action_cost_a = action_cost_a - 1400,
action_cost_cl_a = action_cost_cl_a - 2000
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1109' and p_id = 1
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1400,
action_cost_cl_pc = action_cost_cl_pc - 2000
where stat_date = '2014-01-03' and c_id = '1109'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1,
action_count_t1 = action_count_t1 - 1,
action_item_count_t1 = action_item_count_t1 - 1,
admit_count_t1 = admit_count_t1 - 1,
admit_item_count_t1 = admit_item_count_t1 - 1,
action_cost_t1 = action_cost_t1 - 1400,
action_cost_cl_t1 = action_cost_cl_t1 - 2000
where stat_date = '2014-01-03' and c_id = '1109'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1400,
action_cost_cl_pc = action_cost_cl_pc - 2000
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = 'a5JAtSQj88739702'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = 'a5JAtSQj88739702'
update action_log_201401 set
m_id = 206
where action_log_id = '20946'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1121' and p_id = 0
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
action_count_a = action_count_a - 1,
action_item_count_a = action_item_count_a - 1,
admit_count_a = admit_count_a - 1,
admit_item_count_a = admit_item_count_a - 1,
action_cost_a = action_cost_a - 1400,
action_cost_cl_a = action_cost_cl_a - 2000
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1121' and p_id = 1
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1400,
action_cost_cl_pc = action_cost_cl_pc - 2000
where stat_date = '2014-01-03' and c_id = '1121'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1,
action_count_t1 = action_count_t1 - 1,
action_item_count_t1 = action_item_count_t1 - 1,
admit_count_t1 = admit_count_t1 - 1,
admit_item_count_t1 = admit_item_count_t1 - 1,
action_cost_t1 = action_cost_t1 - 1400,
action_cost_cl_t1 = action_cost_cl_t1 - 2000
where stat_date = '2014-01-03' and c_id = '1121'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1400,
action_cost_cl_pc = action_cost_cl_pc - 2000
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = '9t2Q0a1M88739762'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '9t2Q0a1M88739762'
update action_log_201401 set
m_id = 206
where action_log_id = '20953'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1122' and p_id = 0
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
action_count_a = action_count_a - 1,
action_item_count_a = action_item_count_a - 1,
admit_count_a = admit_count_a - 1,
admit_item_count_a = admit_item_count_a - 1,
action_cost_a = action_cost_a - 1000,
action_cost_cl_a = action_cost_cl_a - 1400
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1122' and p_id = 1
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1000,
action_cost_cl_pc = action_cost_cl_pc - 1400
where stat_date = '2014-01-03' and c_id = '1122'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1,
action_count_t1 = action_count_t1 - 1,
action_item_count_t1 = action_item_count_t1 - 1,
admit_count_t1 = admit_count_t1 - 1,
admit_item_count_t1 = admit_item_count_t1 - 1,
action_cost_t1 = action_cost_t1 - 1000,
action_cost_cl_t1 = action_cost_cl_t1 - 1400
where stat_date = '2014-01-03' and c_id = '1122'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1000,
action_cost_cl_pc = action_cost_cl_pc - 1400
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = '7HSW132188739827'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '7HSW132188739827'
update action_log_201401 set
m_id = 206
where action_log_id = '20962'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1015' and p_id = 0
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
action_count_a = action_count_a - 1,
action_item_count_a = action_item_count_a - 1,
admit_count_a = admit_count_a - 1,
admit_item_count_a = admit_item_count_a - 1,
action_cost_a = action_cost_a - 800,
action_cost_cl_a = action_cost_cl_a - 1100
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1015' and p_id = 1
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 800,
action_cost_cl_pc = action_cost_cl_pc - 1100
where stat_date = '2014-01-03' and c_id = '1015'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1,
action_count_t1 = action_count_t1 - 1,
action_item_count_t1 = action_item_count_t1 - 1,
admit_count_t1 = admit_count_t1 - 1,
admit_item_count_t1 = admit_item_count_t1 - 1,
action_cost_t1 = action_cost_t1 - 800,
action_cost_cl_t1 = action_cost_cl_t1 - 1100
where stat_date = '2014-01-03' and c_id = '1015'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 800,
action_cost_cl_pc = action_cost_cl_pc - 1100
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = 'F2QI3H2p88739869'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = 'F2QI3H2p88739869'
update action_log_201401 set
m_id = 206
where action_log_id = '20985'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '846' and p_id = 0
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
action_count_a = action_count_a - 1,
action_item_count_a = action_item_count_a - 1,
admit_count_a = admit_count_a - 1,
admit_item_count_a = admit_item_count_a - 1,
action_cost_a = action_cost_a - 1000,
action_cost_cl_a = action_cost_cl_a - 1500
where stat_date = '2014-01-03' and m_id = 205 and c_id = '846' and p_id = 1
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1000,
action_cost_cl_pc = action_cost_cl_pc - 1500
where stat_date = '2014-01-03' and c_id = '846'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1,
action_count_t1 = action_count_t1 - 1,
action_item_count_t1 = action_item_count_t1 - 1,
admit_count_t1 = admit_count_t1 - 1,
admit_item_count_t1 = admit_item_count_t1 - 1,
action_cost_t1 = action_cost_t1 - 1000,
action_cost_cl_t1 = action_cost_cl_t1 - 1500
where stat_date = '2014-01-03' and c_id = '846'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1000,
action_cost_cl_pc = action_cost_cl_pc - 1500
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = '4BAD23sj88739948'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '4BAD23sj88739948'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1074' and p_id = 0
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and c_id = '1074'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1
where stat_date = '2014-01-03' and c_id = '1074'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = '5cX9Cf6S88739992'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '5cX9Cf6S88739992'
update action_log_201401 set
m_id = 206
where action_log_id = '21009'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1074' and p_id = 0
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
action_count_a = action_count_a - 1,
action_item_count_a = action_item_count_a - 1,
admit_count_a = admit_count_a - 1,
admit_item_count_a = admit_item_count_a - 1,
action_cost_a = action_cost_a - 1000,
action_cost_cl_a = action_cost_cl_a - 1300
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1074' and p_id = 1
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1000,
action_cost_cl_pc = action_cost_cl_pc - 1300
where stat_date = '2014-01-03' and c_id = '1074'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1,
action_count_t1 = action_count_t1 - 1,
action_item_count_t1 = action_item_count_t1 - 1,
admit_count_t1 = admit_count_t1 - 1,
admit_item_count_t1 = admit_item_count_t1 - 1,
action_cost_t1 = action_cost_t1 - 1000,
action_cost_cl_t1 = action_cost_cl_t1 - 1300
where stat_date = '2014-01-03' and c_id = '1074'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1000,
action_cost_cl_pc = action_cost_cl_pc - 1300
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = '4oRYYUzx88740031'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '4oRYYUzx88740031'
update action_log_201401 set
m_id = 206
where action_log_id = '21016'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1110' and p_id = 0
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
action_count_a = action_count_a - 1,
action_item_count_a = action_item_count_a - 1,
admit_count_a = admit_count_a - 1,
admit_item_count_a = admit_item_count_a - 1,
action_cost_a = action_cost_a - 1000,
action_cost_cl_a = action_cost_cl_a - 1300
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1110' and p_id = 1
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1000,
action_cost_cl_pc = action_cost_cl_pc - 1300
where stat_date = '2014-01-03' and c_id = '1110'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1,
action_count_t1 = action_count_t1 - 1,
action_item_count_t1 = action_item_count_t1 - 1,
admit_count_t1 = admit_count_t1 - 1,
admit_item_count_t1 = admit_item_count_t1 - 1,
action_cost_t1 = action_cost_t1 - 1000,
action_cost_cl_t1 = action_cost_cl_t1 - 1300
where stat_date = '2014-01-03' and c_id = '1110'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1000,
action_cost_cl_pc = action_cost_cl_pc - 1300
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = '8BxZb30q88740078'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '8BxZb30q88740078'
update action_log_201401 set
m_id = 206
where action_log_id = '21027'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1127' and p_id = 0
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
action_count_a = action_count_a - 1,
action_item_count_a = action_item_count_a - 1,
admit_count_a = admit_count_a - 1,
admit_item_count_a = admit_item_count_a - 1,
action_cost_a = action_cost_a - 970,
action_cost_cl_a = action_cost_cl_a - 1200
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1127' and p_id = 1
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 970,
action_cost_cl_pc = action_cost_cl_pc - 1200
where stat_date = '2014-01-03' and c_id = '1127'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1,
action_count_t1 = action_count_t1 - 1,
action_item_count_t1 = action_item_count_t1 - 1,
admit_count_t1 = admit_count_t1 - 1,
admit_item_count_t1 = admit_item_count_t1 - 1,
action_cost_t1 = action_cost_t1 - 970,
action_cost_cl_t1 = action_cost_cl_t1 - 1200
where stat_date = '2014-01-03' and c_id = '1127'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 970,
action_cost_cl_pc = action_cost_cl_pc - 1200
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = 'VzJJlC3y88740112'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = 'VzJJlC3y88740112'
update action_log_201401 set
m_id = 206
where action_log_id = '21026'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '361' and p_id = 0
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
action_count_a = action_count_a - 1,
action_item_count_a = action_item_count_a - 1,
admit_count_a = admit_count_a - 1,
admit_item_count_a = admit_item_count_a - 1,
action_cost_a = action_cost_a - 1000,
action_cost_cl_a = action_cost_cl_a - 1400
where stat_date = '2014-01-03' and m_id = 205 and c_id = '361' and p_id = 1
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1000,
action_cost_cl_pc = action_cost_cl_pc - 1400
where stat_date = '2014-01-03' and c_id = '361'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1,
action_count_t1 = action_count_t1 - 1,
action_item_count_t1 = action_item_count_t1 - 1,
admit_count_t1 = admit_count_t1 - 1,
admit_item_count_t1 = admit_item_count_t1 - 1,
action_cost_t1 = action_cost_t1 - 1000,
action_cost_cl_t1 = action_cost_cl_t1 - 1400
where stat_date = '2014-01-03' and c_id = '361'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 1000,
action_cost_cl_pc = action_cost_cl_pc - 1400
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = 'Zyq4a1rk88740147'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = 'Zyq4a1rk88740147'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '515' and p_id = 0
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and c_id = '515'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1
where stat_date = '2014-01-03' and c_id = '515'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = '6x58Bj6s88740164'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '6x58Bj6s88740164'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '515' and p_id = 0
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and c_id = '515'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1
where stat_date = '2014-01-03' and c_id = '515'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = 'Op1ZxY2388740171'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = 'Op1ZxY2388740171'
update action_log_201401 set
m_id = 206
where action_log_id = '21039'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1025' and p_id = 0
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
action_count_a = action_count_a - 1,
action_item_count_a = action_item_count_a - 1,
admit_count_a = admit_count_a - 1,
admit_item_count_a = admit_item_count_a - 1,
action_cost_a = action_cost_a - 900,
action_cost_cl_a = action_cost_cl_a - 1200
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1025' and p_id = 1
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 900,
action_cost_cl_pc = action_cost_cl_pc - 1200
where stat_date = '2014-01-03' and c_id = '1025'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1,
action_count_t1 = action_count_t1 - 1,
action_item_count_t1 = action_item_count_t1 - 1,
admit_count_t1 = admit_count_t1 - 1,
admit_item_count_t1 = admit_item_count_t1 - 1,
action_cost_t1 = action_cost_t1 - 900,
action_cost_cl_t1 = action_cost_cl_t1 - 1200
where stat_date = '2014-01-03' and c_id = '1025'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 900,
action_cost_cl_pc = action_cost_cl_pc - 1200
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = '9g0q06jt88740367'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '9g0q06jt88740367'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1018' and p_id = 0
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and c_id = '1018'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1
where stat_date = '2014-01-03' and c_id = '1018'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = 'o475S3d988740383'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = 'o475S3d988740383'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1018' and p_id = 0
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and c_id = '1018'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1
where stat_date = '2014-01-03' and c_id = '1018'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = 'j3VbwXqf88740413'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = 'j3VbwXqf88740413'
update action_log_201401 set
m_id = 206
where action_log_id = '21050'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1018' and p_id = 0
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
action_count_a = action_count_a - 1,
action_item_count_a = action_item_count_a - 1,
admit_count_a = admit_count_a - 1,
admit_item_count_a = admit_item_count_a - 1,
action_cost_a = action_cost_a - 900,
action_cost_cl_a = action_cost_cl_a - 1200
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1018' and p_id = 1
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 900,
action_cost_cl_pc = action_cost_cl_pc - 1200
where stat_date = '2014-01-03' and c_id = '1018'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1,
action_count_t1 = action_count_t1 - 1,
action_item_count_t1 = action_item_count_t1 - 1,
admit_count_t1 = admit_count_t1 - 1,
admit_item_count_t1 = admit_item_count_t1 - 1,
action_cost_t1 = action_cost_t1 - 900,
action_cost_cl_t1 = action_cost_cl_t1 - 1200
where stat_date = '2014-01-03' and c_id = '1018'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 900,
action_cost_cl_pc = action_cost_cl_pc - 1200
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = '0o0519h088740432'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '0o0519h088740432'
update action_log_201401 set
m_id = 206
where action_log_id = '21068'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1019' and p_id = 0
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
action_count_a = action_count_a - 1,
action_item_count_a = action_item_count_a - 1,
admit_count_a = admit_count_a - 1,
admit_item_count_a = admit_item_count_a - 1,
action_cost_a = action_cost_a - 900,
action_cost_cl_a = action_cost_cl_a - 1200
where stat_date = '2014-01-03' and m_id = 205 and c_id = '1019' and p_id = 1
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 900,
action_cost_cl_pc = action_cost_cl_pc - 1200
where stat_date = '2014-01-03' and c_id = '1019'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1,
action_count_t1 = action_count_t1 - 1,
action_item_count_t1 = action_item_count_t1 - 1,
admit_count_t1 = admit_count_t1 - 1,
admit_item_count_t1 = admit_item_count_t1 - 1,
action_cost_t1 = action_cost_t1 - 900,
action_cost_cl_t1 = action_cost_cl_t1 - 1200
where stat_date = '2014-01-03' and c_id = '1019'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1,
action_count_pc = action_count_pc - 1,
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 900,
action_cost_cl_pc = action_cost_cl_pc - 1200
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = '19zbI8wR88740452'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '19zbI8wR88740452'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '516' and p_id = 0
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and c_id = '516'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1
where stat_date = '2014-01-03' and c_id = '516'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = 'rnu2ILwK88740479'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = 'rnu2ILwK88740479'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '516' and p_id = 0
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and c_id = '516'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1
where stat_date = '2014-01-03' and c_id = '516'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = '4avinWo688740518'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '4avinWo688740518'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '706' and p_id = 0
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and c_id = '706'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1
where stat_date = '2014-01-03' and c_id = '706'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = '8kUUmN4z88740527'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = '8kUUmN4z88740527'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '516' and p_id = 0
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and c_id = '516'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1
where stat_date = '2014-01-03' and c_id = '516'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and m_id = 205
update click_log_201401 set
m_id = 206
where aff_id = 'mNxSTR9e88740538'
select * from action_log_201401 where m_id = 205 and click_date >= '2014-01-03 00:00:00' and aff_id = 'mNxSTR9e88740538'
update stat_log_201401 set
action_click_count_a = action_click_count_a - 1,
click_count_a = click_count_a - 1
where stat_date = '2014-01-03' and m_id = 205 and c_id = '516' and p_id = 0
update stat_log_client_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and c_id = '516'
update stat_log_banner_201401 set
action_click_count_t1 = action_click_count_t1 - 1,
click_count_t1 = click_count_t1 - 1
where stat_date = '2014-01-03' and c_id = '516'
update stat_log_media_201401 set
action_click_count_pc = action_click_count_pc - 1,
click_count_pc = click_count_pc - 1
where stat_date = '2014-01-03' and m_id = 205

/www/aff/log/2014/20140103/cl_20140103_0000.log¶

cl_20140103_1750.log1:20140103_175953,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1109,t1,0ioj2H8588739593,T8YrwSSJ88739592,http%3A%2F%2Fmobad.jp%2Fad%2Fp%2Fr%3F_site%3D1446%26_article%3D2196%26_link%3D8058%26_image%3D8501%26suid%3D0ioj2H8588739593,0,0
cl_20140103_1800.log8:20140103_180142,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1121,t1,a5JAtSQj88739702,2l27n2li88739702,http%3A%2F%2Fsmapara.jp%2F%3Ftr%3Di-hearts%26af%3Da5JAtSQj88739702,0,0
cl_20140103_1810.log4:20140103_181629,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,182.249.246.140,206,516,t1,mNxSTR9e88740538,k9ohQTA688740537,http%3A%2F%2Ffull.hapiuta.jp%2Findex.php%3Fcamp%3DTaf_full_ihearts_300%26igaf%3DmNxSTR9e88740538,0,0
cl_20140103_1800.log1:20140103_180907,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,515,t1,Zyq4a1rk88740147,Z1z8H3yB88740147,http%3A%2F%2Fm.hapimelo.jp%2Findex.php%3Fcamp%3DTaf_melo_ihearts_300%26igaf%3DZyq4a1rk88740147,0,0
cl_20140103_1800.log1:20140103_180924,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,515,t1,6x58Bj6s88740164,99XWOudl88740164,http%3A%2F%2Fm.hapimelo.jp%2Findex.php%3Fcamp%3DTaf_melo_ihearts_300%26igaf%3D6x58Bj6s88740164,0,0
cl_20140103_1800.log1:20140103_180931,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1025,t1,Op1ZxY2388740171,69S082H188740171,http%3A%2F%2Ffieldsmobile.jp%2Fsmp%2Faf%2F%3Ffrom%3Diht_smp_s%26afid%3DOp1ZxY2388740171,0,0
cl_20140103_1800.log2:20140103_180832,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,361,t1,VzJJlC3y88740112,SEqDw01P88740112,http%3A%2F%2Fsp.yamasa.jp%2F,0,0
cl_20140103_1800.log3:20140103_180711,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1110,t1,4oRYYUzx88740031,Dh03NHm588740031,https%3A%2F%2Fssl.tabelog.com%2Fsmartphone%2Fpremium%2Fpremium_service_guide%2F%3Faf%3D4oRYYUzx88740031,0,0
cl_20140103_1800.log3:20140103_180758,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1127,t1,8BxZb30q88740078,TDaVvGU188740078,http%3A%2F%2Fm.happydeco.jp%2Findex.php%3Fcamp%3DTaf_deco_ihearts_300%26igaf%3D8BxZb30q88740078,0,0
cl_20140103_1800.log4:20140103_180632,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1074,t1,5cX9Cf6S88739992,y0ef5V4Y88739992,http%3A%2F%2F777town-sp.net%2F%3Faf%3D5cX9Cf6S88739992,0,0
cl_20140103_1800.log5:20140103_180548,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1074,t1,4BAD23sj88739948,4337K5u688739947,http%3A%2F%2F777town-sp.net%2F%3Faf%3D4BAD23sj88739948,0,0
cl_20140103_1800.log6:20140103_180429,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,846,t1,F2QI3H2p88739869,TJXuMgI588739869,http%3A%2F%2Fwww.its-mo.com%2Fstc%2Fstart%2Fsc_cid_rd.html%3Faf%3DF2QI3H2p88739869%26cid%3Dihra_00_20130401%26url%3Dmarket%253a%252f%252fdetails%253fid%253dcom%252eits_mo%252enavi%252ekddi,0,0
cl_20140103_1800.log7:20140103_180347,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1015,t1,7HSW132188739827,88HrI2k288739827,http%3A%2F%2Ftouch.tetsu-jin.jp%2F%3Ftr%3Di-hearts%26af%3D7HSW132188739827,0,0
cl_20140103_1800.log8:20140103_180242,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1122,t1,9t2Q0a1M88739762,L9VdjE4C88739762,http%3A%2F%2Ftr.webantenna.info%2Frd%3Fwaad%3D1X4hfJGT%26ga%3DWAce7v-1%26afsid%3D9t2Q0a1M88739762,0,0
cl_20140103_1810.log3:20140103_181629,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,516,t1,19zbI8wR88740452,c0903t1P88740451,http%3A%2F%2Ffull.hapiuta.jp%2Findex.php%3Fcamp%3DTaf_full_ihearts_300%26igaf%3D19zbI8wR88740452,0,0
cl_20140103_1810.log3:20140103_181629,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,516,t1,rnu2ILwK88740479,f496DQl688740479,http%3A%2F%2Ffull.hapiuta.jp%2Findex.php%3Fcamp%3DTaf_full_ihearts_300%26igaf%3Drnu2ILwK88740479,0,0
cl_20140103_1810.log3:20140103_181629,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,516,t1,8kUUmN4z88740527,S76U4IUu88740527,http%3A%2F%2Ffull.hapiuta.jp%2Findex.php%3Fcamp%3DTaf_full_ihearts_300%26igaf%3D8kUUmN4z88740527,0,0
cl_20140103_1810.log3:20140103_181629,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,706,t1,4avinWo688740518,lmK11NF188740518,http%3A%2F%2Fa.happydouga.jp%2Findex.php%3Fcamp%3DTaf_anime_ihearts_300%26igaf%3D4avinWo688740518,0,0
cl_20140103_1810.log4:20140103_181329,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1018,t1,o475S3d988740383,EPtmQ8N188740383,http%3A%2F%2Fsinchan.happy.jp%2Findex.php%3Fcamp%3DTaf_sinchan_ihearts_300%26igaf%3Do475S3d988740383,0,0
cl_20140103_1810.log4:20140103_181329,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1018,t1,9g0q06jt88740367,FMFfT2W288740367,http%3A%2F%2Fsinchan.happy.jp%2Findex.php%3Fcamp%3DTaf_sinchan_ihearts_300%26igaf%3D9g0q06jt88740367,0,0
cl_20140103_1810.log4:20140103_181334,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1018,t1,j3VbwXqf88740413,O1m9p5YH88740406,http%3A%2F%2Fsinchan.happy.jp%2Findex.php%3Fcamp%3DTaf_sinchan_ihearts_300%26igaf%3Dj3VbwXqf88740413,0,0
cl_20140103_1810.log4:20140103_181352,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.1.C.0.467%29+AppleWebKit%2F534.30+%28KHTML%2C+like+Gecko%29+Version%2F4.0+Mobile+Safari%2F534.30,,pc,211.129.87.48,206,1019,t1,0o0519h088740432,4HB6Bkzk88740431,http%3A%2F%2Fp-zukan.happy.jp%2Findex.php%3Fcamp%3DTaf_zukan_ihearts_300%26igaf%3D0o0519h088740432,0,0

/www/aff/log/2014/20140103/ac_20140103_0000.log¶

20140103_180118,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.,,pc,211.129.87.48,206,1109,t1,0ioj2H8588739593,T8YrwSSJ88739592,smart16599299,1,,0,1,,0,
20140103_180745,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.,,pc,211.129.87.48,206,1110,t1,4oRYYUzx88740031,Dh03NHm588740031,ad44532f752f000357124444abcd8fb4,1,,0,1,,0,
20140103_180422,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.,,pc,211.129.87.48,206,1015,t1,7HSW132188739827,88HrI2k288739827,RVHx1ENN6SqZd6CYJSV18TSBz8hQsfEQbnNCburNGAjL2QZEWE,1,,0,1,,0,
20140103_180332,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.,,pc,211.129.87.48,206,1122,t1,9t2Q0a1M88739762,L9VdjE4C88739762,7f5bf4af3c9a41f5226c8c5cf585e0e1,1,,0,1,,0,
20140103_180204,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.,,pc,211.129.87.48,206,1121,t1,a5JAtSQj88739702,2l27n2li88739702,3aa2189713c5c2aa3c14b20b58845c62885ac837d8de0eb046eb01bb529c9433da7753a60def30aa0f8d6740f32804c48b947ab6d0acc72effcd31c98bf0d9e86a7d1965936860259ed352dfc384cd0754a879462ecf88ed,1,,0,1,,0,
20140103_180905,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.,,pc,211.129.87.48,206,1127,t1,8BxZb30q88740078,TDaVvGU188740078,https%3A%2F%2Fconnect.auone.jp%2Fnet%2Fid%2Fhny_rt_net%2Fcca%2Fs%2FsP_hoqJcMvwd1TFM%2FWXIEV1N4Vym3VDvr,1,,0,1,,0,
20140103_180858,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.,,pc,211.129.87.48,206,361,t1,VzJJlC3y88740112,SEqDw01P88740112,Ee0AkEXgoncR4CmA%2FZBezIk3-337DAKZU,1,,0,1,,0,
20140103_180700,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.,,pc,211.129.87.48,206,1074,t1,5cX9Cf6S88739992,y0ef5V4Y88739992,814908,1,,0,1,,0,
20140103_180534,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.,,pc,211.129.87.48,206,846,t1,F2QI3H2p88739869,TJXuMgI588739869,97324,1,,0,1,,0,
20140103_181631,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.,,pc,211.129.87.48,206,1018,t1,j3VbwXqf88740413,O1m9p5YH88740406,https%3A%2F%2Fconnect.auone.jp%2Fnet%2Fid%2Fhny_rt_net%2Fcca%2Fs%2FsP_hoqJcMvwd1TFM%2FWXIEV1N4Vym3VDvr,1,,0,1,,0,
20140103_181658,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.,,pc,211.129.87.48,206,1019,t1,0o0519h088740432,4HB6Bkzk88740431,https%3A%2F%2Fconnect.auone.jp%2Fnet%2Fid%2Fhny_rt_net%2Fcca%2Fs%2FsP_hoqJcMvwd1TFM%2FWXIEV1N4Vym3VDvr,1,,0,1,,0,
20140103_181332,Mozilla%2F5.0+%28Linux%3B+U%3B+Android+4.2.2%3B+ja-jp%3B+SonySOL23+Build%2F14.,,pc,211.129.87.48,206,1025,t1,Op1ZxY2388740171,69S082H188740171,89371,1,,0,1,,0,