select stat_date,asp_id,c_id,item_id,p_id,count(stat_log_id) as cnt, sum(pv_count_pc)+sum(action_click_count_pc)+sum(click_count_pc)+sum(click_unique_count_pc)+sum(action_count_pc)+sum(admit_count_pc)+sum(cancel_count_pc)+sum(click_cost_pc)+sum(click_cost_cl_pc)+sum(action_cost_pc)+sum(action_cost_cl_pc)+sum(resign_count_pc)+sum(this_month_resign_count_pc) as pc, sum(pv_count_d)+sum(action_click_count_d)+sum(click_count_d)+sum(click_unique_count_d)+sum(action_count_d)+sum(admit_count_d)+sum(cancel_count_d)+sum(click_cost_d)+sum(click_cost_cl_d)+sum(action_cost_d)+sum(action_cost_cl_d)+sum(resign_count_d)+sum(this_month_resign_count_d) as d, sum(pv_count_v)+sum(action_click_count_v)+sum(click_count_v)+sum(click_unique_count_v)+sum(action_count_v)+sum(admit_count_v)+sum(cancel_count_v)+sum(click_cost_v)+sum(click_cost_cl_v)+sum(action_cost_v)+sum(action_cost_cl_v)+sum(resign_count_v)+sum(this_month_resign_count_v) as v, sum(pv_count_e)+sum(action_click_count_e)+sum(click_count_e)+sum(click_unique_count_e)+sum(action_count_e)+sum(admit_count_e)+sum(cancel_count_e)+sum(click_cost_e)+sum(click_cost_cl_e)+sum(action_cost_e)+sum(action_cost_cl_e)+sum(resign_count_e)+sum(this_month_resign_count_e) as e, sum(pv_count_i)+sum(action_click_count_i)+sum(click_count_i)+sum(click_unique_count_i)+sum(action_count_i)+sum(admit_count_i)+sum(cancel_count_i)+sum(click_cost_i)+sum(click_cost_cl_i)+sum(action_cost_i)+sum(action_cost_cl_i)+sum(resign_count_i)+sum(this_month_resign_count_i) as i, sum(pv_count_a)+sum(action_click_count_a)+sum(click_count_a)+sum(click_unique_count_a)+sum(action_count_a)+sum(admit_count_a)+sum(cancel_count_a)+sum(click_cost_a)+sum(click_cost_cl_a)+sum(action_cost_a)+sum(action_cost_cl_a)+sum(resign_count_a)+sum(this_month_resign_count_a) as a from stat_log_asp_201310 where stat_date = '2013-10-01' group by stat_date,asp_id,c_id,item_id,p_id order by cnt desc ,stat_date,asp_id,c_id,item_id,p_id

select * from stat_log_asp_201310 where stat_date = '2013-10-11' and asp_id = 11 and c_id = 129 and item_id = 0 and p_id = 1

delete from stat_log_asp_201310 where stat_log_id = 5934
update stat_log_asp_201310 set
action_count_d = 3,
action_count_a = 2,
action_count_i	= 2
where stat_log_id = 5933

select * from stat_log_asp_201310 where stat_date = '2013-10-07' and asp_id = 11 and c_id = 129 and item_id = 0 and p_id = 1

delete from stat_log_asp_201310 where stat_log_id = 3767
update stat_log_asp_201310 set
action_count_v	 = action_count_v	 + 1
where stat_log_id = 3766

select * from stat_log_asp_201310 where stat_date = '2013-10-02' and asp_id = 11 and c_id = 627 and item_id = 0 and p_id = 0

delete from stat_log_asp_201310 where stat_log_id = 1027
update stat_log_asp_201310 set
action_click_count_d	 = 3,
click_count_d	 = 3	
where stat_log_id = 1026

select * from stat_log_asp_201310 where stat_date = '2013-10-17' and asp_id = 39 and c_id = 129 and item_id = 159 and p_id = 0
delete from stat_log_asp_201310 where stat_log_id = 8620

select stat_date,m_id,c_id,item_id,p_id,count(stat_log_id) as cnt, sum(pv_count_pc)+sum(action_click_count_pc)+sum(click_count_pc)+sum(click_unique_count_pc)+sum(action_count_pc)+sum(admit_count_pc)+sum(cancel_count_pc)+sum(click_cost_pc)+sum(click_cost_cl_pc)+sum(action_cost_pc)+sum(action_cost_cl_pc)+sum(resign_count_pc)+sum(this_month_resign_count_pc) as pc, sum(pv_count_d)+sum(action_click_count_d)+sum(click_count_d)+sum(click_unique_count_d)+sum(action_count_d)+sum(admit_count_d)+sum(cancel_count_d)+sum(click_cost_d)+sum(click_cost_cl_d)+sum(action_cost_d)+sum(action_cost_cl_d)+sum(resign_count_d)+sum(this_month_resign_count_d) as d, sum(pv_count_v)+sum(action_click_count_v)+sum(click_count_v)+sum(click_unique_count_v)+sum(action_count_v)+sum(admit_count_v)+sum(cancel_count_v)+sum(click_cost_v)+sum(click_cost_cl_v)+sum(action_cost_v)+sum(action_cost_cl_v)+sum(resign_count_v)+sum(this_month_resign_count_v) as v, sum(pv_count_e)+sum(action_click_count_e)+sum(click_count_e)+sum(click_unique_count_e)+sum(action_count_e)+sum(admit_count_e)+sum(cancel_count_e)+sum(click_cost_e)+sum(click_cost_cl_e)+sum(action_cost_e)+sum(action_cost_cl_e)+sum(resign_count_e)+sum(this_month_resign_count_e) as e, sum(pv_count_i)+sum(action_click_count_i)+sum(click_count_i)+sum(click_unique_count_i)+sum(action_count_i)+sum(admit_count_i)+sum(cancel_count_i)+sum(click_cost_i)+sum(click_cost_cl_i)+sum(action_cost_i)+sum(action_cost_cl_i)+sum(resign_count_i)+sum(this_month_resign_count_i) as i, sum(pv_count_a)+sum(action_click_count_a)+sum(click_count_a)+sum(click_unique_count_a)+sum(action_count_a)+sum(admit_count_a)+sum(cancel_count_a)+sum(click_cost_a)+sum(click_cost_cl_a)+sum(action_cost_a)+sum(action_cost_cl_a)+sum(resign_count_a)+sum(this_month_resign_count_a) as a from stat_log_201310 where stat_date = '2013-10-01' group by stat_date,m_id,c_id,item_id,p_id order by cnt desc ,stat_date,m_id,c_id,item_id,p_id

select * from stat_log_201310 where stat_date = '2013-10-03' and m_id = 207 and c_id = 1003 and item_id = 0 and p_id = 1

delete from stat_log_201310 where stat_log_id = 1386
update stat_log_201310 set
action_click_count_a	 = 2,
action_count_a	 = 2,
action_item_count_a	 = 2,
admit_count_a = 2,
admit_item_count_a = 2,
action_cost_a = 2000,
action_cost_cl_a = 3000	
where stat_log_id = 1385

select * from stat_log_201310 where stat_date = '2013-10-06' and m_id = 202 and c_id = 846 and item_id = 0 and p_id = 0

delete from stat_log_201310 where stat_log_id = 3646
update stat_log_201310 set
action_click_count_a	= 2,
click_count_a = 2
where stat_log_id = 3645

select * from stat_log_201310 where stat_date = '2013-10-07' and m_id = 204 and c_id = 361 and item_id = 0 and p_id = 1

delete from stat_log_201310 where stat_log_id = 3731
update stat_log_201310 set
action_click_count_a	= 7,
action_count_a = 7,
action_item_count_a	= 7,
admit_count_a = 7,
admit_item_count_a = 7,
action_cost_a = 1000 * 7,
action_cost_cl_a = 1400 * 7
where stat_log_id = 3730

select * from stat_log_201310 where stat_date = '2013-10-07' and m_id = 204 and c_id = 514 and item_id = 0 and p_id = 1
delete from stat_log_201310 where stat_log_id = 3757
update stat_log_201310 set
action_click_count_a	= 7,
action_count_a = 7,
action_item_count_a	= 7,
admit_count_a = 7,
admit_item_count_a = 7,
action_cost_a = 1080 * 7,
action_cost_cl_a = 1200 * 7
where stat_log_id = 3756

select * from stat_log_201310 where stat_date = '2013-10-07' and m_id = 204 and c_id = 516 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 3729
update stat_log_201310 set
action_click_count_a	= 9,
click_count_a = 9
where stat_log_id = 3728

select * from stat_log_201310 where stat_date = '2013-10-07' and m_id = 204 and c_id = 517 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 3740
update stat_log_201310 set
action_click_count_a	= 4,
click_count_a = 4
where stat_log_id = 3738

select * from stat_log_201310 where stat_date = '2013-10-07' and m_id = 204 and c_id = 642 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 3733
update stat_log_201310 set
action_click_count_a	= 7,
click_count_a = 7
where stat_log_id = 3732

select * from stat_log_201310 where stat_date = '2013-10-07' and m_id = 204 and c_id = 706 and item_id = 0 and p_id = 1
delete from stat_log_201310 where stat_log_id = 3759
update stat_log_201310 set
action_click_count_a	= 7,
action_count_a = 7,
action_item_count_a	= 7,
admit_count_a = 7,
admit_item_count_a = 7,
action_cost_a = 1080 * 7,
action_cost_cl_a = 1200 * 7
where stat_log_id = 3758

select * from stat_log_201310 where stat_date = '2013-10-07' and m_id = 204 and c_id = 779 and item_id = 0 and p_id = 1
delete from stat_log_201310 where stat_log_id = 3755
update stat_log_201310 set
action_click_count_a	= 7,
action_count_a = 7,
action_item_count_a	= 7,
admit_count_a = 7,
admit_item_count_a = 7,
action_cost_a = 1050 * 7,
action_cost_cl_a = 1200 * 7
where stat_log_id = 3754

select * from stat_log_201310 where stat_date = '2013-10-07' and m_id = 204 and c_id = 849 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 3742
update stat_log_201310 set
action_click_count_a	= 7,
click_count_a = 7
where stat_log_id = 3741

select * from stat_log_201310 where stat_date = '2013-10-07' and m_id = 285 and c_id = 779 and item_id = '' and p_id = ''
delete from stat_log_201310 where stat_log_id = 4056
update stat_log_201310 set
resign_count_pc	= 6
where stat_log_id = 4055

select * from stat_log_201310 where stat_date = '2013-10-08' and m_id = 204 and c_id = 642 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 4343
update stat_log_201310 set
action_click_count_a	= 2,
click_count_a = 2
where stat_log_id = 4342

select * from stat_log_201310 where stat_date = '2013-10-09' and m_id = 589 and c_id = 1033 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 4931
update stat_log_201310 set
action_click_count_a	= 8,
click_count_a = 8,
action_click_count_i	= 27,
click_count_i = 27
where stat_log_id = 4930

select * from stat_log_201310 where stat_date = '2013-10-10' and m_id = 203 and c_id = 514 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 5526
update stat_log_201310 set
action_click_count_a	= 2,
click_count_a = 2
where stat_log_id = 5525

select * from stat_log_201310 where stat_date = '2013-10-10' and m_id = 203 and c_id = 706 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 5529
update stat_log_201310 set
action_click_count_a	= 3,
click_count_a = 3
where stat_log_id = 5528

select * from stat_log_201310 where stat_date = '2013-10-10' and m_id = 203 and c_id = 779 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 5524
update stat_log_201310 set
action_click_count_a	= 2,
click_count_a = 2
where stat_log_id = 5523

select * from stat_log_201310 where stat_date = '2013-10-10' and m_id = 285 and c_id = 779 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 5341
update stat_log_201310 set
action_click_count_a	= 5,
click_count_a = 5
where stat_log_id = 5339

select * from stat_log_201310 where stat_date = '2013-10-11' and m_id = 199 and c_id = 517 and item_id = '' and p_id = ''
delete from stat_log_201310 where stat_log_id = 5854
update stat_log_201310 set
resign_count_pc = 2
where stat_log_id = 5853

select * from stat_log_201310 where stat_date = '2013-10-11' and m_id = 199 and c_id = 657
delete from stat_log_201310 where stat_log_id = 6222
update stat_log_201310 set
resign_count_pc = 2
where stat_log_id = 6221

select * from stat_log_201310 where stat_date = '2013-10-11' and m_id = 201 and c_id = 849 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 6212
update stat_log_201310 set
action_click_count_a = 2,
click_count_a = 2
where stat_log_id = 6211

select * from stat_log_201310 where stat_date = '2013-10-11' and m_id = 206 and c_id = 516 and item_id = '' and p_id = ''
delete from stat_log_201310 where stat_log_id = 5773

select * from stat_log_201310 where stat_date = '2013-10-12' and m_id = 199 and c_id = 948 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 6867
update stat_log_201310 set
action_click_count_a	= 2,
click_count_a = 2
where stat_log_id = 6866

select * from stat_log_201310 where stat_date = '2013-10-12' and m_id = 589 and c_id = 779 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 6703
update stat_log_201310 set
action_click_count_a	= 4,
click_count_a = 4,
action_click_count_i	= 8,
click_count_i = 8
where stat_log_id = 6702

select * from stat_log_201310 where stat_date = '2013-10-13' and m_id = 589 and c_id = 948 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 7184
update stat_log_201310 set
action_click_count_a	= 143,
click_count_a = 143,
action_click_count_i	= 8,
click_count_i = 8
where stat_log_id = 7183

select * from stat_log_201310 where stat_date = '2013-10-14' and m_id = 207 and c_id = 1010 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 8106
update stat_log_201310 set
action_click_count_a	= 5,
click_count_a = 5
where stat_log_id = 8105

select * from stat_log_201310 where stat_date = '2013-10-15' and m_id = 204 and c_id = 361 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 8640
update stat_log_201310 set
action_click_count_a	= 4,
click_count_a = 4
where stat_log_id = 8639

select * from stat_log_201310 where stat_date = '2013-10-15' and m_id = 204 and c_id = 1024 and item_id = 0 and p_id = 1
delete from stat_log_201310 where stat_log_id = 8628
update stat_log_201310 set
action_click_count_a	= 3,
action_count_a = 3,
action_item_count_a	= 3,
admit_count_a = 3,
admit_item_count_a = 3,
action_cost_a = 1000 * 3,
action_cost_cl_a = 1500 * 3
where stat_log_id = 8627

select * from stat_log_201310 where stat_date = '2013-10-15' and m_id = 207 and c_id = 929 and item_id = 0 and p_id = 1
delete from stat_log_201310 where stat_log_id = 8603
update stat_log_201310 set
action_click_count_a	= 3,
action_count_a = 2,
action_item_count_a	= 2,
admit_count_a = 2,
admit_item_count_a = 2,
action_cost_a = 900 * 2,
action_cost_cl_a = 1200 * 2,
action_click_count_i	= 2,
action_count_i = 2,
action_item_count_i	= 2,
admit_count_i = 2,
admit_item_count_i = 2,
action_cost_i = 900 * 2,
action_cost_cl_i = 1200 * 2
where stat_log_id = 8602

select * from stat_log_201310 where stat_date = '2013-10-15' and m_id = 207 and c_id = 1018 and item_id = 0 and p_id = 1
delete from stat_log_201310 where stat_log_id = 8605
update stat_log_201310 set
action_click_count_i	= 2,
action_count_i = 2,
action_item_count_i	= 2,
admit_count_i = 2,
admit_item_count_i = 2,
action_cost_i = 900 * 2,
action_cost_cl_i = 1200 * 2
where stat_log_id = 8604

select * from stat_log_201310 where stat_date = '2013-10-15' and m_id = 207 and c_id = 1019 and item_id = 0 and p_id = 0
delete from stat_log_201310 where stat_log_id = 8956
update stat_log_201310 set
action_click_count_a	= 5,
click_count_a = 5
where stat_log_id = 8955

select stat_date,listing_id,c_id,keyword_id,p_id,count(stat_log_id) as cnt, sum(pv_count_pc)+sum(action_click_count_pc)+sum(click_count_pc)+sum(click_unique_count_pc)+sum(action_count_pc)+sum(admit_count_pc)+sum(cancel_count_pc)+sum(click_cost_pc)+sum(click_cost_cl_pc)+sum(action_cost_pc)+sum(action_cost_cl_pc)+sum(resign_count_pc)+sum(this_month_resign_count_pc) as pc, sum(pv_count_d)+sum(action_click_count_d)+sum(click_count_d)+sum(click_unique_count_d)+sum(action_count_d)+sum(admit_count_d)+sum(cancel_count_d)+sum(click_cost_d)+sum(click_cost_cl_d)+sum(action_cost_d)+sum(action_cost_cl_d)+sum(resign_count_d)+sum(this_month_resign_count_d) as d, sum(pv_count_v)+sum(action_click_count_v)+sum(click_count_v)+sum(click_unique_count_v)+sum(action_count_v)+sum(admit_count_v)+sum(cancel_count_v)+sum(click_cost_v)+sum(click_cost_cl_v)+sum(action_cost_v)+sum(action_cost_cl_v)+sum(resign_count_v)+sum(this_month_resign_count_v) as v, sum(pv_count_e)+sum(action_click_count_e)+sum(click_count_e)+sum(click_unique_count_e)+sum(action_count_e)+sum(admit_count_e)+sum(cancel_count_e)+sum(click_cost_e)+sum(click_cost_cl_e)+sum(action_cost_e)+sum(action_cost_cl_e)+sum(resign_count_e)+sum(this_month_resign_count_e) as e, sum(pv_count_i)+sum(action_click_count_i)+sum(click_count_i)+sum(click_unique_count_i)+sum(action_count_i)+sum(admit_count_i)+sum(cancel_count_i)+sum(click_cost_i)+sum(click_cost_cl_i)+sum(action_cost_i)+sum(action_cost_cl_i)+sum(resign_count_i)+sum(this_month_resign_count_i) as i, sum(pv_count_a)+sum(action_click_count_a)+sum(click_count_a)+sum(click_unique_count_a)+sum(action_count_a)+sum(admit_count_a)+sum(cancel_count_a)+sum(click_cost_a)+sum(click_cost_cl_a)+sum(action_cost_a)+sum(action_cost_cl_a)+sum(resign_count_a)+sum(this_month_resign_count_a) as a from stat_log_listing_201310 where stat_date = '2013-10-01' group by stat_date,listing_id,c_id,keyword_id,p_id order by cnt desc ,stat_date,listing_id,c_id,keyword_id,p_id

select stat_date,m_id,count(stat_log_id) as cnt, sum(pv_count_pc)+sum(action_click_count_pc)+sum(click_count_pc)+sum(click_unique_count_pc)+sum(action_count_pc)+sum(admit_count_pc)+sum(cancel_count_pc)+sum(click_cost_pc)+sum(click_cost_cl_pc)+sum(action_cost_pc)+sum(action_cost_cl_pc) as pc, sum(pv_count_d)+sum(action_click_count_d)+sum(click_count_d)+sum(click_unique_count_d)+sum(action_count_d)+sum(admit_count_d)+sum(cancel_count_d)+sum(click_cost_d)+sum(click_cost_cl_d)+sum(action_cost_d)+sum(action_cost_cl_d) as d, sum(pv_count_v)+sum(action_click_count_v)+sum(click_count_v)+sum(click_unique_count_v)+sum(action_count_v)+sum(admit_count_v)+sum(cancel_count_v)+sum(click_cost_v)+sum(click_cost_cl_v)+sum(action_cost_v)+sum(action_cost_cl_v) as v, sum(pv_count_e)+sum(action_click_count_e)+sum(click_count_e)+sum(click_unique_count_e)+sum(action_count_e)+sum(admit_count_e)+sum(cancel_count_e)+sum(click_cost_e)+sum(click_cost_cl_e)+sum(action_cost_e)+sum(action_cost_cl_e) as e  from stat_log_media_201310 where stat_date = '2013-10-01' group by stat_date,m_id order by cnt desc ,stat_date,m_id

select * from stat_log_media_201310 where stat_date = '2013-10-06' and m_id = 204
delete from stat_log_media_201310 where stat_log_id = 217
update stat_log_media_201310 set
action_click_count_pc	= 86,
click_count_pc = 86
where stat_log_id = 216

select stat_date,c_id,count(stat_log_id) as cnt, sum(pv_count_pc)+sum(action_click_count_pc)+sum(click_count_pc)+sum(click_unique_count_pc)+sum(action_count_pc)+sum(admit_count_pc)+sum(cancel_count_pc)+sum(click_cost_pc)+sum(click_cost_cl_pc)+sum(action_cost_pc)+sum(action_cost_cl_pc) as pc, sum(pv_count_d)+sum(action_click_count_d)+sum(click_count_d)+sum(click_unique_count_d)+sum(action_count_d)+sum(admit_count_d)+sum(cancel_count_d)+sum(click_cost_d)+sum(click_cost_cl_d)+sum(action_cost_d)+sum(action_cost_cl_d) as d, sum(pv_count_v)+sum(action_click_count_v)+sum(click_count_v)+sum(click_unique_count_v)+sum(action_count_v)+sum(admit_count_v)+sum(cancel_count_v)+sum(click_cost_v)+sum(click_cost_cl_v)+sum(action_cost_v)+sum(action_cost_cl_v) as v, sum(pv_count_e)+sum(action_click_count_e)+sum(click_count_e)+sum(click_unique_count_e)+sum(action_count_e)+sum(admit_count_e)+sum(cancel_count_e)+sum(click_cost_e)+sum(click_cost_cl_e)+sum(action_cost_e)+sum(action_cost_cl_e) as e  from stat_log_client_201310 where stat_date = '2013-10-01' group by stat_date,c_id order by cnt desc ,stat_date,c_id

select * from stat_log_client_201310 where stat_date = '2013-10-07' and c_id = 516
delete from stat_log_client_201310 where stat_log_id = 1715
update stat_log_client_201310 set
action_click_count_pc	= 30,
click_count_pc = 30
where stat_log_id = 1714

select * from stat_log_client_201310 where stat_date = '2013-10-07' and c_id = 642
delete from stat_log_client_201310 where stat_log_id = 1717
update stat_log_client_201310 set
action_click_count_pc	= 18,
click_count_pc = 18
where stat_log_id = 1716

select * from stat_log_client_201310 where stat_date = '2013-10-08' and c_id = 648
delete from stat_log_client_201310 where stat_log_id = 2050
update stat_log_client_201310 set
action_click_count_d		= 1,
click_count_d = 1
where stat_log_id = 2049

select * from stat_log_client_201310 where stat_date = '2013-10-11' and c_id = 1015
delete from stat_log_client_201310 where stat_log_id = 2873
update stat_log_client_201310 set
action_click_count_pc = 39,
click_count_pc = 39
where stat_log_id = 2872

select * from stat_log_client_201310 where stat_date = '2013-10-15' and c_id = 584
delete from stat_log_client_201310 where stat_log_id = 3768
update stat_log_client_201310 set
action_click_count_pc = 9,
click_count_pc = 9
where stat_log_id = 3767

select stat_date,c_id,count(stat_log_id) as cnt from stat_log_banner_201310 where stat_date = '2013-10-01' group by stat_date,c_id order by cnt desc ,stat_date,c_id

select * from stat_log_banner_201310 where stat_date = '2013-10-07' and c_id = 516
delete from stat_log_banner_201310 where stat_log_id = 1675

select * from stat_log_banner_201310 where stat_date = '2013-10-07' and c_id = 517
delete from stat_log_banner_201310 where stat_log_id = 1682

select * from stat_log_banner_201310 where stat_date = '2013-10-07' and c_id = 642
delete from stat_log_banner_201310 where stat_log_id = 1677

select * from stat_log_banner_201310 where stat_date = '2013-10-07' and c_id = 849
delete from stat_log_banner_201310 where stat_log_id = 1685

select * from stat_log_banner_201310 where stat_date = '2013-10-07' and c_id = 997
delete from stat_log_banner_201310 where stat_log_id = 1665

select * from stat_log_banner_201310 where stat_date = '2013-10-08' and c_id = 648
delete from stat_log_banner_201310 where stat_log_id = 2006

select * from stat_log_banner_201310 where stat_date = '2013-10-11' and c_id = 1015
delete from stat_log_banner_201310 where stat_log_id = 2812

select * from stat_log_banner_201310 where stat_date = '2013-10-15' and c_id = 584
delete from stat_log_banner_201310 where stat_log_id = 3685

select * from stat_log_banner_201310 where stat_date = '2013-10-15' and c_id = 774
delete from stat_log_banner_201310 where stat_log_id = 3719

select stat_date,m_id,asp_id,c_id,item_id,count(stat_log_id) as cnt, sum(pv_count_pc)+sum(action_click_count_pc)+sum(click_count_pc)+sum(click_unique_count_pc)+sum(action_count_pc)+sum(admit_count_pc)+sum(cancel_count_pc)+sum(click_cost_pc)+sum(click_cost_cl_pc)+sum(action_cost_pc)+sum(action_cost_cl_pc)+sum(resign_count_pc)+sum(this_month_resign_count_pc) as pc, sum(pv_count_d)+sum(action_click_count_d)+sum(click_count_d)+sum(click_unique_count_d)+sum(action_count_d)+sum(admit_count_d)+sum(cancel_count_d)+sum(click_cost_d)+sum(click_cost_cl_d)+sum(action_cost_d)+sum(action_cost_cl_d)+sum(resign_count_d)+sum(this_month_resign_count_d) as d, sum(pv_count_v)+sum(action_click_count_v)+sum(click_count_v)+sum(click_unique_count_v)+sum(action_count_v)+sum(admit_count_v)+sum(cancel_count_v)+sum(click_cost_v)+sum(click_cost_cl_v)+sum(action_cost_v)+sum(action_cost_cl_v)+sum(resign_count_v)+sum(this_month_resign_count_v) as v, sum(pv_count_e)+sum(action_click_count_e)+sum(click_count_e)+sum(click_unique_count_e)+sum(action_count_e)+sum(admit_count_e)+sum(cancel_count_e)+sum(click_cost_e)+sum(click_cost_cl_e)+sum(action_cost_e)+sum(action_cost_cl_e)+sum(resign_count_e)+sum(this_month_resign_count_e) as e from stat_log_item_201310 where stat_date = '2013-10-01' group by stat_date,m_id,asp_id,c_id,item_id order by cnt desc ,stat_date,m_id,asp_id,c_id,item_id

select stat_date,m_id,c_id,shop_id,count(stat_log_id) as cnt, sum(pv_count_pc)+sum(action_click_count_pc)+sum(click_count_pc)+sum(click_unique_count_pc)+sum(action_count_pc)+sum(admit_count_pc)+sum(cancel_count_pc)+sum(click_cost_pc)+sum(click_cost_cl_pc)+sum(action_cost_pc)+sum(action_cost_cl_pc)+sum(resign_count_pc)+sum(this_month_resign_count_pc) as pc, sum(pv_count_d)+sum(action_click_count_d)+sum(click_count_d)+sum(click_unique_count_d)+sum(action_count_d)+sum(admit_count_d)+sum(cancel_count_d)+sum(click_cost_d)+sum(click_cost_cl_d)+sum(action_cost_d)+sum(action_cost_cl_d)+sum(resign_count_d)+sum(this_month_resign_count_d) as d, sum(pv_count_v)+sum(action_click_count_v)+sum(click_count_v)+sum(click_unique_count_v)+sum(action_count_v)+sum(admit_count_v)+sum(cancel_count_v)+sum(click_cost_v)+sum(click_cost_cl_v)+sum(action_cost_v)+sum(action_cost_cl_v)+sum(resign_count_v)+sum(this_month_resign_count_v) as v, sum(pv_count_e)+sum(action_click_count_e)+sum(click_count_e)+sum(click_unique_count_e)+sum(action_count_e)+sum(admit_count_e)+sum(cancel_count_e)+sum(click_cost_e)+sum(click_cost_cl_e)+sum(action_cost_e)+sum(action_cost_cl_e)+sum(resign_count_e)+sum(this_month_resign_count_e) as e from stat_log_shop_201310 where stat_date = '2013-10-01' group by stat_date,m_id,c_id,shop_id order by cnt desc ,stat_date,m_id,c_id,shop_id