i-generation

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