#!/usr/bin/php
# dbname  : sponsorkliks
# host    : 172.28.0.2
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 transactions SET target = 'SK_2984' WHERE 1 AND id = '402259404' ;
UPDATE IGNORE transactions SET commission_net = (commission_gross * (commission_percentage/100)) WHERE 1 AND id = "402259404";
UPDATE IGNORE transactions SET commission_fee = (commission_gross - commission_net) WHERE 1 AND id = "402259404";
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 t FROM transactions t INNER JOIN transactions keep ON keep.network_id = '6yWg' AND keep.order_id = t.order_id AND keep.id <> t.id AND JSON_UNQUOTE(JSON_EXTRACT(keep.transaction_json, '$.connection_id')) <> 'rReO107M' WHERE t.network_id = '6yWg' AND t.transaction_date >= DATE_SUB(NOW(), INTERVAL 120 DAY) AND JSON_UNQUOTE(JSON_EXTRACT(t.transaction_json, '$.connection_id')) = 'rReO107M' AND t.order_id IS NOT NULL AND t.order_id <> '';
UPDATE transactions SET original_target = IFNULL(original_target, target), target = JSON_UNQUOTE(JSON_EXTRACT(transaction_json, '$."0"')) WHERE network_id = '6yWg' AND (target IS NULL OR target = '' OR target = '0') AND JSON_EXTRACT(transaction_json, '$."0"') IS NOT NULL AND JSON_UNQUOTE(JSON_EXTRACT(transaction_json, '$."0"')) NOT IN ('', 'null');
UPDATE transactions SET original_target = IFNULL(original_target, target), target = JSON_UNQUOTE(JSON_EXTRACT(transaction_json, '$.customs[0]')) WHERE network_id = '6yWg' AND (target IS NULL OR target = '' OR target = '0') AND JSON_TYPE(JSON_EXTRACT(transaction_json, '$.customs[0]')) = 'STRING';
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`, `source` = FN_SPLIT(`target`, '$', 2), `target` = FN_SPLIT(`target`, '$', 1) WHERE `id` >= 300000000 AND `target` LIKE '%$%';
UPDATE `transactions` SET `original_target` = `target`, `source` = FN_SPLIT(`target`, '~', 2), `target` = FN_SPLIT(`target`, '~', 1) WHERE `id` >= 300000000 AND `target` LIKE '%~%' AND `target` NOT LIKE '%$%';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'FB78DH2X', `target` = TRIM(TRAILING 'FB78DH2X' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+FB78DH2X$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'dyn-bnnr-bol', `target` = TRIM(TRAILING 'dyn-bnnr-bol' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+dyn-bnnr-bol$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'app-bnnr-bol', `target` = TRIM(TRAILING 'app-bnnr-bol' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+app-bnnr-bol$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'dyn-bnnr', `target` = TRIM(TRAILING 'dyn-bnnr' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+dyn-bnnr$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'app-bnnr', `target` = TRIM(TRAILING 'app-bnnr' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+app-bnnr$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'pv-popup', `target` = TRIM(TRAILING 'pv-popup' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+pv-popup$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'whatsapp', `target` = TRIM(TRAILING 'whatsapp' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+whatsapp$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'homepage', `target` = TRIM(TRAILING 'homepage' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+homepage$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'website', `target` = TRIM(TRAILING 'website' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+website$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'widget', `target` = TRIM(TRAILING 'widget' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+widget$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'start', `target` = TRIM(TRAILING 'start' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+start$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'app', `target` = TRIM(TRAILING 'app' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+app$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'sig', `target` = TRIM(TRAILING 'sig' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+sig$';
UPDATE `transactions` SET `original_target` = IFNULL(`original_target`, `target`), `source` = 'api', `target` = TRIM(TRAILING 'api' FROM `target`) WHERE `id` >= 300000000 AND (`source` IS NULL OR `source` = '') AND `target` REGEXP '^(SK_)?[0-9]+api$';
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 '%$%' AND `target` NOT LIKE '%~%';
UPDATE `transactions` SET `original_target` = `target`, `target` = CONCAT('SK_', SUBSTRING_INDEX(SUBSTRING_INDEX(`target`, '?', 1), 'SK_', -1)) WHERE `target` LIKE '%?src=%';
UPDATE `transactions` SET `paid` = 1, `paid_on` = COALESCE(`paid_on`, `transaction_date`) WHERE `shop` = 'Sponsorkliks HM' AND `network_id` = 'gWkk' AND `transaction_status` = 'accepted' AND (IFNULL(`paid`, 0) = 0 OR `paid_on` IS NULL);