サポート #437
クリックログ削除
| ステータス: | 新規 | 開始日: | 2015/09/01 | |
|---|---|---|---|---|
| 優先度: | 通常 | 期日: | ||
| 担当者: | - | 進捗 %: | 0% | |
| カテゴリ: | ログ系 | 予定工数: | 1.00時間 | |
| 対象バージョン: | - | 作業時間の記録: | - |
履歴
#2 山本 義治 が9年以上前に更新
delete from stat_log_asp_201508 where c_id = 582 and stat_date = '2015-8-16' and ((pv_count_pc+action_click_count_pc+click_count_pc+click_unique_count_pc+action_count_pc+action_item_count_pc+action_item_amount_pc+admit_count_pc+admit_item_count_pc+admit_item_amount_pc+cancel_count_pc+cancel_item_count_pc+click_cost_pc+click_cost_cl_pc+action_cost_pc+action_cost_cl_pc+resign_count_pc+this_month_resign_count_pc) + (pv_count_d+action_click_count_d+click_count_d+click_unique_count_d+action_count_d+action_item_count_d+action_item_amount_d+admit_count_d+admit_item_count_d+admit_item_amount_d+cancel_count_d+cancel_item_count_d+click_cost_d+click_cost_cl_d+action_cost_d+action_cost_cl_d+resign_count_d+this_month_resign_count_d) + (pv_count_e+action_click_count_e+click_count_e+click_unique_count_e+action_count_e+action_item_count_e+action_item_amount_e+admit_count_e+admit_item_count_e+admit_item_amount_e+cancel_count_e+cancel_item_count_e+click_cost_e+click_cost_cl_e+action_cost_e+action_cost_cl_e+resign_count_e+this_month_resign_count_e) + (pv_count_v+action_click_count_v+click_count_v+click_unique_count_v+action_count_v+action_item_count_v+action_item_amount_v+admit_count_v+admit_item_count_v+admit_item_amount_v+cancel_count_v+cancel_item_count_v+click_cost_v+click_cost_cl_v+action_cost_v+action_cost_cl_v+resign_count_v+this_month_resign_count_v) + (pv_count_i+action_click_count_i+click_count_i+click_unique_count_i+action_count_i+action_item_count_i+action_item_amount_i+admit_count_i+admit_item_count_i+admit_item_amount_i+cancel_count_i+cancel_item_count_i+click_cost_i+click_cost_cl_i+action_cost_i+action_cost_cl_i+resign_count_i+this_month_resign_count_i) + (pv_count_a+action_click_count_a+click_count_a+click_unique_count_a+action_count_a+action_item_count_a+action_item_amount_a+admit_count_a+admit_item_count_a+admit_item_amount_a+cancel_count_a+cancel_item_count_a+click_cost_a+click_cost_cl_a+action_cost_a+action_cost_cl_a+resign_count_a+this_month_resign_count_a)) = 0