サポート #28
ラパルレレポート調整
| ステータス: | 終了 | 開始日: | 2013/11/20 | |
|---|---|---|---|---|
| 優先度: | 通常 | 期日: | ||
| 担当者: | - | 進捗 %: | 0% | |
| カテゴリ: | データ調整 | 予定工数: | 1.00時間 | |
| 対象バージョン: | - | 作業時間の記録: | 1.00時間 |
説明
ラパルレ
広告ID: 902
承認済み→承認待ちに戻す
履歴
#1 山本 義治 が約11年前に更新
- ステータス を 新規 から 終了 に変更
select * from action_log_201311 where aff_id = 'uh5QlD8H84709385'
update action_log_201311 set
commission_cost = 0,
commission_cost_cl = 0,
status = 0,
admit_date = ''
where aff_id = 'uh5QlD8H84709385'
select * from stat_log_201311 where m_id = 619 and c_id = 902 and item_id = 1508 and p_id = 1 and stat_date = '2013-11-18'
update stat_log_201311 set
admit_count_pc = admit_count_pc - 1,
admit_item_count_pc = admit_item_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 10137
select * from stat_log_media_201311 where m_id = 619 and stat_date = '2013-11-18'
update stat_log_media_201311 set
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 764
select * from stat_log_client_201311 where c_id = 902 and stat_date = '2013-11-18'
update stat_log_client_201311 set
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 4366
select * from stat_log_item_201311 where c_id = 902 and item_id = 1508 and stat_date = '2013-11-18'
update stat_log_item_201311 set
admit_count_pc = admit_count_pc - 1,
admit_item_count_pc = admit_item_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 1222
select * from action_log_201311 where aff_id = 'i3zG03I984732673'
update action_log_201311 set
commission_cost = 0,
commission_cost_cl = 0,
status = 0,
admit_date = ''
where aff_id = 'i3zG03I984732673'
select * from stat_log_201311 where m_id = 619 and c_id = 902 and item_id = 1508 and p_id = 1 and stat_date = '2013-11-18'
update stat_log_201311 set
admit_count_pc = admit_count_pc - 1,
admit_item_count_pc = admit_item_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 10137
select * from stat_log_media_201311 where m_id = 619 and stat_date = '2013-11-18'
update stat_log_media_201311 set
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 764
select * from stat_log_client_201311 where c_id = 902 and stat_date = '2013-11-18'
update stat_log_client_201311 set
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 4366
select * from stat_log_item_201311 where c_id = 902 and item_id = 1508 and stat_date = '2013-11-18'
update stat_log_item_201311 set
admit_count_pc = admit_count_pc - 1,
admit_item_count_pc = admit_item_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 1222
select * from action_log_201311 where aff_id = '0Eg4nbZK84730050'
update action_log_201311 set
commission_cost = 0,
commission_cost_cl = 0,
status = 0,
admit_date = ''
where aff_id = '0Eg4nbZK84730050'
select * from stat_log_201311 where m_id = 619 and c_id = 902 and item_id = 1508 and p_id = 1 and stat_date = '2013-11-18'
update stat_log_201311 set
admit_count_pc = admit_count_pc - 1,
admit_item_count_pc = admit_item_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 10137
select * from stat_log_media_201311 where m_id = 619 and stat_date = '2013-11-18'
update stat_log_media_201311 set
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 764
select * from stat_log_client_201311 where c_id = 902 and stat_date = '2013-11-18'
update stat_log_client_201311 set
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 4366
select * from stat_log_item_201311 where c_id = 902 and item_id = 1508 and stat_date = '2013-11-18'
update stat_log_item_201311 set
admit_count_pc = admit_count_pc - 1,
admit_item_count_pc = admit_item_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 1222
select * from action_log_201311 where aff_id = '2QpPCLOO84728444'
update action_log_201311 set
commission_cost = 0,
commission_cost_cl = 0,
status = 0,
admit_date = ''
where aff_id = '2QpPCLOO84728444'
select * from stat_log_201311 where m_id = 619 and c_id = 902 and item_id = 1508 and p_id = 1 and stat_date = '2013-11-18'
update stat_log_201311 set
admit_count_pc = admit_count_pc - 1,
admit_item_count_pc = admit_item_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 10137
select * from stat_log_media_201311 where m_id = 619 and stat_date = '2013-11-18'
update stat_log_media_201311 set
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 764
select * from stat_log_client_201311 where c_id = 902 and stat_date = '2013-11-18'
update stat_log_client_201311 set
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 4366
select * from stat_log_item_201311 where c_id = 902 and item_id = 1508 and stat_date = '2013-11-18'
update stat_log_item_201311 set
admit_count_pc = admit_count_pc - 1,
admit_item_count_pc = admit_item_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 1222
select * from action_log_201311 where aff_id = 'zb2YIl0284703323'
update action_log_201311 set
commission_cost = 0,
commission_cost_cl = 0,
status = 0,
admit_date = ''
where aff_id = 'zb2YIl0284703323'
select * from stat_log_201311 where m_id = 619 and c_id = 902 and item_id = 1508 and p_id = 1 and stat_date = '2013-11-18'
update stat_log_201311 set
admit_count_pc = admit_count_pc - 1,
admit_item_count_pc = admit_item_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 10137
select * from stat_log_media_201311 where m_id = 619 and stat_date = '2013-11-18'
update stat_log_media_201311 set
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 764
select * from stat_log_client_201311 where c_id = 902 and stat_date = '2013-11-18'
update stat_log_client_201311 set
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 4366
select * from stat_log_item_201311 where c_id = 902 and item_id = 1508 and stat_date = '2013-11-18'
update stat_log_item_201311 set
admit_count_pc = admit_count_pc - 1,
admit_item_count_pc = admit_item_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 1222
select * from action_log_201311 where aff_id = 'Rq07h2Zf84702475'
update action_log_201311 set
commission_cost = 0,
commission_cost_cl = 0,
status = 0,
admit_date = ''
where aff_id = 'Rq07h2Zf84702475'
select * from stat_log_201311 where m_id = 619 and c_id = 902 and item_id = 1508 and p_id = 1 and stat_date = '2013-11-18'
update stat_log_201311 set
admit_count_pc = admit_count_pc - 1,
admit_item_count_pc = admit_item_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 10137
select * from stat_log_media_201311 where m_id = 619 and stat_date = '2013-11-18'
update stat_log_media_201311 set
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 764
select * from stat_log_client_201311 where c_id = 902 and stat_date = '2013-11-18'
update stat_log_client_201311 set
admit_count_pc = admit_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 4366
select * from stat_log_item_201311 where c_id = 902 and item_id = 1508 and stat_date = '2013-11-18'
update stat_log_item_201311 set
admit_count_pc = admit_count_pc - 1,
admit_item_count_pc = admit_item_count_pc - 1,
action_cost_pc = action_cost_pc - 5000,
action_cost_cl_pc = action_cost_cl_pc - 7000
where stat_log_id = 1222