#!/usr/bin/php
# dbname  : sponsorkliks
# host    : 172.28.0.2
UPDATE transactions SET target = 'SK_4990' WHERE 1 AND id = '305880260' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "305880260";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "305880260";
UPDATE transactions SET target = 'SK_4990' WHERE 1 AND id = '309050866' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "309050866";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "309050866";
UPDATE transactions SET target = 'SK_4990' WHERE 1 AND id = '305880259' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "305880259";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "305880259";
UPDATE transactions SET target = 'SK_4990' WHERE 1 AND id = '309050865' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "309050865";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "309050865";
UPDATE transactions SET target = 'SK_12629' WHERE 1 AND id = '304459207' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "304459207";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "304459207";
UPDATE transactions SET target = 'SK_12629' WHERE 1 AND id = '307577953' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "307577953";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "307577953";
UPDATE transactions SET target = 'SK_12629' WHERE 1 AND id = '312493292' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "312493292";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "312493292";
UPDATE transactions SET target = 'SK_12629' WHERE 1 AND id = '304459206' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "304459206";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "304459206";
UPDATE transactions SET target = 'SK_12629' WHERE 1 AND id = '307577952' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "307577952";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "307577952";
UPDATE transactions SET target = 'SK_12629' WHERE 1 AND id = '312493291' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "312493291";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "312493291";
UPDATE transactions SET target = 'SK_12629' WHERE 1 AND id = '304345869' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "304345869";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "304345869";
UPDATE transactions SET target = 'SK_12629' WHERE 1 AND id = '304458457' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "304458457";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "304458457";
UPDATE transactions SET target = 'SK_12629' WHERE 1 AND id = '307577165' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "307577165";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "307577165";
UPDATE transactions SET target = 'SK_12629' WHERE 1 AND id = '312492504' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "312492504";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "312492504";
UPDATE transactions SET target = 'SK_9431' WHERE 1 AND id = '299474230' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "299474230";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "299474230";
UPDATE transactions SET target = 'SK_12941' WHERE 1 AND id = '310344008' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "310344008";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "310344008";
UPDATE transactions SET target = 'SK_12941' WHERE 1 AND id = '325360469' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "325360469";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "325360469";
UPDATE transactions SET target = 'SK_12941' WHERE 1 AND id = '332041987' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "332041987";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "332041987";
UPDATE transactions SET target = 'SK_6343' WHERE 1 AND id = '312902878' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "312902878";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "312902878";
UPDATE transactions SET target = 'SK_6343' WHERE 1 AND id = '320361183' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "320361183";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "320361183";
UPDATE transactions SET target = 'SK_13070' WHERE 1 AND id = '311817681' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "311817681";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "311817681";
UPDATE transactions SET target = 'SK_13070' WHERE 1 AND id = '317810229' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "317810229";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "317810229";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333930142' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333930142";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333930142";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337716189' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337716189";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337716189";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333930143' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333930143";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333930143";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337716190' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337716190";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337716190";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333957771' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333957771";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333957771";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337743827' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337743827";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337743827";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333957772' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333957772";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333957772";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337743828' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337743828";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337743828";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333972548' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333972548";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333972548";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337758610' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337758610";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337758610";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333972550' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333972550";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333972550";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337758612' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337758612";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337758612";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333964682' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333964682";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333964682";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337750196' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337750196";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337750196";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333964683' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333964683";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333964683";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337750197' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337750197";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337750197";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333936957' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333936957";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333936957";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337722272' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337722272";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337722272";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333936958' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333936958";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333936958";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337722273' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337722273";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337722273";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333957003' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333957003";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333957003";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337743059' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337743059";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337743059";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333957002' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333957002";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333957002";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337743058' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337743058";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337743058";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333957000' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333957000";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333957000";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337743056' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337743056";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337743056";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333957001' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333957001";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333957001";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337743057' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337743057";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337743057";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333949010' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333949010";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333949010";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337734489' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337734489";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337734489";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333949011' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333949011";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333949011";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337734490' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337734490";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337734490";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333959523' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333959523";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333959523";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337745582' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337745582";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337745582";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333959524' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333959524";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333959524";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337745583' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337745583";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337745583";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '299602653' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "299602653";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "299602653";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '314233681' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "314233681";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "314233681";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '314233682' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "314233682";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "314233682";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '314233683' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "314233683";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "314233683";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333956296' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333956296";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333956296";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337742354' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337742354";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337742354";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333956297' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333956297";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333956297";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337742352' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337742352";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337742352";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333966344' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333966344";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333966344";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337751766' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337751766";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337751766";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333966345' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333966345";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333966345";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337751767' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337751767";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337751767";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333972547' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333972547";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333972547";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337758609' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337758609";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337758609";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '333972549' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "333972549";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "333972549";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '337758611' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "337758611";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "337758611";
UPDATE transactions SET shop = 'Thuisbezorgd Handmatig' WHERE 1 AND id = '335172280' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "335172280";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "335172280";
UPDATE transactions SET shop = 'Thuisbezorgd Handmatig' WHERE 1 AND id = '336215776' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "336215776";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "336215776";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '303669880' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "303669880";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "303669880";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '311446281' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "311446281";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "311446281";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '311446281' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "311446281";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "311446281";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '298469692' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "298469692";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "298469692";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '307884193' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "307884193";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "307884193";
UPDATE transactions SET target = 'SK_0' WHERE 1 AND id = '307884193' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "307884193";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "307884193";
UPDATE transactions SET commission_fee = '15409' WHERE 1 AND id = '341302233' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "341302233";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "341302233";
UPDATE transactions SET commission_fee = '15409' WHERE 1 AND id = '359777738' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "359777738";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "359777738";
UPDATE transactions SET target = 'SK_2984' WHERE 1 AND id = '390476188' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "390476188";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "390476188";
UPDATE transactions SET target = 'SK_2984' WHERE 1 AND id = '395013323' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "395013323";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "395013323";
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND commission_net IS NULL;
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND commission_fee IS NULL;
DELETE FROM transactions WHERE network_id = '6yWg' AND transaction_date >= DATE_SUB(NOW(), INTERVAL 120 DAY) AND JSON_UNQUOTE(JSON_EXTRACT(transaction_json, '$.connection_id')) = 'rReO107M';
UPDATE `transactions` SET `original_target` = `target`, `target` = REPLACE(REPLACE(`target`, '[', ''),']','') WHERE `target` LIKE '%SK%' AND (`target` LIKE '%[%' OR `target` LIKE '%]%');
UPDATE `transactions` SET `original_target` = `target`, `target` = FN_CLEAN(`target`) WHERE `id` >= 300000000 AND `target` LIKE '%SK%' AND RIGHT(`target`, 1) NOT IN ('0' , '1', '2', '3', '4', '5', '6', '7', '8', '9') AND `target` NOT LIKE '%$%';
UPDATE `transactions` SET `original_target` = `target`, `source` = FN_SPLIT(`target`, '$', 2), `target` = FN_SPLIT(`target`, '$', 1) WHERE `id` >= 300000000 AND `target` LIKE '%$%';