select * from update_db where update_db.value='1' and update_db.group_id ='2' order by update_db.table_name
Select==> SELECT * FROM al_com_branch_customer WHERE log_status in ('e','a') limit 0,500

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='502',trans_price ='200.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '502';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '502'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#502#@trans_price =#200.00#@cust_status =#0#@log_status = #p#@log_date =#0000-00-00#@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #502#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='FB2',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'FB2';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'FB2'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#FB2#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#0000-00-00#@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #FB2#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='FB4',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'FB4';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'FB4'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#FB4#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#0000-00-00#@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #FB4#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='FB5',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'FB5';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'FB5'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#FB5#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#0000-00-00#@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #FB5#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='504',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '504';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '504'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#504#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#0000-00-00#@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #504#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='KITI',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'KITI';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'KITI'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#KITI#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#0000-00-00#@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #KITI#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='PCS',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'PCS';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'PCS'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#PCS#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#0000-00-00#@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #PCS#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='506',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '506';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '506'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#506#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#0000-00-00#@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #506#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='517',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '517';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '517'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#517#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#0000-00-00#@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #517#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='510',trans_price ='100.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '510';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '510'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#510#@trans_price =#100.00#@cust_status =#0#@log_status = #p#@log_date =#0000-00-00#@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #510#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='SWT',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'SWT';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'SWT'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#SWT#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#0000-00-00#@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #SWT#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='518',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '518';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '518'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#518#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =#0000-00-00#@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #518#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='523',trans_price ='200.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '523';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '523'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#523#@trans_price =#200.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #523#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='529',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '529';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '529'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#529#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #529#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='530',trans_price ='100.00',cust_status ='1',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '530';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '530'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#530#@trans_price =#100.00#@cust_status =#1#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #530#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='528',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '528';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '528'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#528#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #528#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='MBT',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'MBT';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'MBT'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#MBT#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #MBT#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='534',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '534';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '534'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#534#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #534#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='TWC',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'TWC';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'TWC'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#TWC#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #TWC#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='WA',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'WA';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'WA'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#WA#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #WA#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='ѭ',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'ѭ';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'ѭ'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#ѭ#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #ѭ#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='ԭ',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'ԭ';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'ԭ'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#ԭ#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #ԭ#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='533',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '533';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '533'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#533#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #533#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='537',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '537';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '537'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#537#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #537#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='536',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '536';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '536'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#536#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #536#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='535',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '535';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '535'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#535#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #535#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='ACP_BB',trans_price ='111.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'ACP_BB';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'ACP_BB'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#ACP_BB#@trans_price =#111.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #ACP_BB#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='539',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '539';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '539'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#539#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #539#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='541',trans_price ='200.00',cust_status ='1',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '541';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '541'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#541#@trans_price =#200.00#@cust_status =#1#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #541#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='543',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '543';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '543'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#543#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #543#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='544',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '544';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '544'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#544#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #544#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='542',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '542';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '542'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#542#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #542#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='505',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '505';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '505'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#505#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #505#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='546',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '546';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '546'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#546#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #546#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='527',trans_price ='100.00',cust_status ='1',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '527';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '527'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#527#@trans_price =#100.00#@cust_status =#1#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #527#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='AA',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'AA';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'AA'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#AA#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #AA#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='AD',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'AD';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'AD'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#AD#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #AD#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='AGF',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'AGF';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'AGF'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#AGF#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #AGF#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='552',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '552';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '552'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#552#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #552#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='FB1',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'FB1';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'FB1'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#FB1#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #FB1#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='FB3',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'FB3';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'FB3'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#FB3#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #FB3#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='KTW',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'KTW';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'KTW'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#KTW#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #KTW#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='LK',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'LK';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'LK'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#LK#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #LK#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='PSD',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'PSD';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'PSD'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#PSD#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #PSD#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='SWN',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'SWN';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = 'SWN'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#SWN#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #SWN#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='503',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '503';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '503'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#503#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #503#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='551',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '551';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '551'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#551#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #551#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='9999',cust_id ='553',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '553';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '9999' and cust_id = '553'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#9999#@cust_id =#553#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #9999# and cust_id = #553#;')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','CHC','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'CHC'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#CHC#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','KBR','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'KBR'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#KBR#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','KCN','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'KCN'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#KCN#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','KHK','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'KHK'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#KHK#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','KSW','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'KSW'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#KSW#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','LHS','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'LHS'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#LHS#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','ND','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'ND'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#ND#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','NP','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'NP'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#NP#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','PEN','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'PEN'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#PEN#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','BBG','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'BBG'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#BBG#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','POT','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'POT'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#POT#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','PS','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'PS'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#PS#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','PSP','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'PSP'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#PSP#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','SBL','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'SBL'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#SBL#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','SCM','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'SCM'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#SCM#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','SKS','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'SKS'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#SKS#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','SRT','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'SRT'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#SRT#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com insert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','TEN','0.00','0','p','2015-12-08','SYSTEM',now());

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = 'TEN'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'insert into al_com_branch_customer (branch_id@cust_id@trans_price@cust_status@log_status@log_date@log_user@date_time_ex) VALUES ( #1847#@#TEN#@#0.00#@#0#@#p#@#2015-12-08#@#SYSTEM#@now());')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='551',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '551';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '551'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#551#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #551#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='530',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '530';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '530'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#530#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #530#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='553',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '553';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '553'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#553#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #553#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='529',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '529';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '529'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#529#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #529#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='539',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '539';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '539'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#539#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #539#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='528',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '528';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '528'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#528#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #528#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='523',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '523';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '523'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#523#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #523#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='541',trans_price ='0.00',cust_status ='1',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '541';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '541'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#541#@trans_price =#0.00#@cust_status =#1#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #541#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='535',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '535';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '535'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#535#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #535#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='543',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '543';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '543'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#543#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #543#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='534',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '534';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '534'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#534#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #534#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='533',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '533';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '533'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#533#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #533#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='552',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '552';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '552'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#552#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #552#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='527',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '527';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '527'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#527#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #527#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='506',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '506';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '506'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#506#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #506#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='537',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '537';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '537'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#537#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #537#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='536',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '536';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '536'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#536#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #536#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='542',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '542';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '542'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#542#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #542#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='517',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '517';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '517'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#517#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #517#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='518',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '518';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '518'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#518#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #518#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='546',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '546';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '546'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#546#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #546#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='503',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '503';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '503'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#503#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #503#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='505',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '505';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '505'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#505#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #505#;')

Query k62.chaiyo-aa.com update al_com_branch_customer set branch_id ='1847',cust_id ='544',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '544';

Query k82.chaiyo-aa.com UPDATE al_com_branch_customer SET log_status= 'p' WHERE branch_id = '1847' and cust_id = '544'

Query k82.chaiyo-aa.com INSERT INTO `log_export` (type_desc ,branch_id,date_time,desc_sql) VALUES ('COMPLETE', 'BK81-BK62',now(), 'update al_com_branch_customer set branch_id =#1847#@cust_id =#544#@trans_price =#0.00#@cust_status =#0#@log_status = #p#@log_date =##@log_user =##@date_time_ex = now() WHERE branch_id = #1847# and cust_id = #544#;')

#STOP # Total Record = 90
Select==> SELECT * FROM al_com_prod_price_center WHERE log_status in ('e','a') limit 0,500

#STOP # Total Record = 0
Select==> SELECT * FROM al_com_prod_spin_center WHERE log_status in ('e','a') limit 0,500

#STOP # Total Record = 0
################## End ##################
ѹ 2019-12-12 06:15:44 Group 2
ʶҹQuery
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='502',trans_price ='200.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '502';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='FB2',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'FB2';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='FB4',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'FB4';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='FB5',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'FB5';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='504',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '504';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='KITI',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'KITI';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='PCS',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'PCS';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='506',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '506';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='517',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '517';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='510',trans_price ='100.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '510';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='SWT',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'SWT';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='518',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='0000-00-00',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '518';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='523',trans_price ='200.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '523';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='529',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '529';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='530',trans_price ='100.00',cust_status ='1',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '530';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='528',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '528';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='MBT',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'MBT';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='534',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '534';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='TWC',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'TWC';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='WA',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'WA';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='ѭ',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'ѭ';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='ԭ',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'ԭ';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='533',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '533';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='537',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '537';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='536',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '536';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='535',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '535';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='ACP_BB',trans_price ='111.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'ACP_BB';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='539',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '539';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='541',trans_price ='200.00',cust_status ='1',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '541';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='543',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '543';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='544',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '544';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='542',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '542';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='505',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '505';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='546',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '546';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='527',trans_price ='100.00',cust_status ='1',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '527';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='AA',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'AA';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='AD',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'AD';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='AGF',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'AGF';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='552',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '552';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='FB1',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'FB1';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='FB3',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'FB3';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='KTW',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'KTW';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='LK',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'LK';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='PSD',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'PSD';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='SWN',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = 'SWN';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='503',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '503';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='551',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '551';
COMPLETEupdate al_com_branch_customer set branch_id ='9999',cust_id ='553',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '9999' and cust_id = '553';
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','CHC','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','KBR','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','KCN','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','KHK','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','KSW','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','LHS','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','ND','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','NP','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','PEN','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','BBG','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','POT','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','PS','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','PSP','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','SBL','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','SCM','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','SKS','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','SRT','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEinsert into al_com_branch_customer (branch_id,cust_id,trans_price,cust_status,log_status,log_date,log_user,date_time_ex) VALUES ( '1847','TEN','0.00','0','p','2015-12-08','SYSTEM',now());
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='551',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '551';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='530',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '530';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='553',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '553';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='529',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '529';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='539',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '539';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='528',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '528';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='523',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '523';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='541',trans_price ='0.00',cust_status ='1',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '541';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='535',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '535';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='543',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '543';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='534',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '534';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='533',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '533';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='552',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '552';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='527',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '527';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='506',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '506';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='537',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '537';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='536',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '536';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='542',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '542';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='517',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '517';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='518',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '518';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='546',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '546';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='503',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '503';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='505',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '505';
COMPLETEupdate al_com_branch_customer set branch_id ='1847',cust_id ='544',trans_price ='0.00',cust_status ='0',log_status = 'p',log_date ='',log_user ='',date_time_ex = now() WHERE branch_id = '1847' and cust_id = '544';

success