jp change bankredemption campaign

select * from voucher where prefix='JP10' and voucher_no between 67870 and 67872;

select * from voucher_campaign where campaign_code like '%Keppel%';

select * from voucher_campaign_issue where voucher_id in (363962,363963,363964);

select * from voucher_action where voucher_id in (363962,363963,363964) and action_id = 30;


select * from voucher_campaign_issue_request where request_id = 61549;

select * from voucher_request_approve where request_id = 61549;

select * from voucher_receipt_numbers where voucher_ids like '%363962%';

=========================================================================================================

select group_concat(voucher_id) from voucher where prefix='JP10' and voucher_no between 51161 and 51162


select group_concat(voucher_id) from voucher where prefix='JP10' and voucher_no between 50115 and 50124


select group_concat(voucher_id) from voucher where prefix='JP10' and voucher_no between 48000 and 48009


select group_concat(voucher_id) from voucher where prefix='JP10' and voucher_no between 47941 and 47942


select* from voucher_campaign
#189

select * from voucher_campaign_issue where voucher_id in (347253,347254,346207,346208,346209,346210,346211,346212,346213,346214,346215,346216,344092,344093,344094,344095,344096,344097,344098,344099,344100,344101,344033,344034)
#update voucher_campaign_issue set campaign_id = 189 where voucher_id in (347253,347254,346207,346208,346209,346210,346211,346212,346213,346214,346215,346216,344092,344093,344094,344095,344096,344097,344098,344099,344100,344101,344033,344034)

select * from voucher_request_approve where request_id in (58643,58653,58740,58885)
#update voucher_request_approve set request_remarks = REPLACE (request_remarks, 'Campaign: UOB Redemption', 'Campaign: NS50 Recognition Package') where request_id in (58643,58653,58740,58885)

select * from voucher_campaign_issue_request where request_id in (58643,58653,58740,58885)
#update voucher_campaign_issue_request set campaign_id = 189 where request_id in (58643,58653,58740,58885)

select * from voucher_action where voucher_id in (347253,347254,346207,346208,346209,346210,346211,346212,346213,346214,346215,346216,344092,344093,344094,344095,344096,344097,344098,344099,344100,344101,344033,344034) and action_id = 30
#update voucher_action set remarks=REPLACE (remarks, 'Campaign: UOB Redemption', 'Campaign: NS50 Recognition Package') where voucher_id in (347253,347254,346207,346208,346209,346210,346211,346212,346213,346214,346215,346216,344092,344093,344094,344095,344096,344097,344098,344099,344100,344101,344033,344034) and action_id = 30