2024-09-07 01:00:01 -- 將會員中心id寫入data-lake 2024-09-07 01:00:01 -- SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at FROM `purchases` p LEFT JOIN user_relations ur on p.user_relation_id = ur.id LEFT JOIN users u on ur.user_id = u.id WHERE p.order_code LIKE 'P%' and p.created_at like '2024-09-06%'; 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '314728' WHERE ordernumber = 'P630906104017434' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '232484' WHERE ordernumber = 'P420906110310896' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '246686' WHERE ordernumber = 'P180906110330913' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '305154' WHERE ordernumber = 'P190906110538434' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '313319' WHERE ordernumber = 'P420906110623548' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419522' WHERE ordernumber = 'P180906110836143' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '384877' WHERE ordernumber = 'P180906111008887' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '404509' WHERE ordernumber = 'P420906111109639' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '243906' WHERE ordernumber = 'P190906111111199' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '40599' WHERE ordernumber = 'P190906111239816' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419484' WHERE ordernumber = 'P420906111239694' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419524' WHERE ordernumber = 'P420906111354875' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '333459' WHERE ordernumber = 'P180906111359115' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '352047' WHERE ordernumber = 'P180906111439418' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '314514' WHERE ordernumber = 'P190906111501717' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419525' WHERE ordernumber = 'P420906111501564' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '235451' WHERE ordernumber = 'P200906111526199' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419526' WHERE ordernumber = 'P420906111620786' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '346650' WHERE ordernumber = 'P180906111628927' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '378584' WHERE ordernumber = 'P420906111656831' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419527' WHERE ordernumber = 'P420906111824230' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '144058' WHERE ordernumber = 'P180906111906949' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '270291' WHERE ordernumber = 'P200906111930979' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419394' WHERE ordernumber = 'P420906112029424' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '270291' WHERE ordernumber = 'P200906112051987' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '304183' WHERE ordernumber = 'P420906112208745' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '392518' WHERE ordernumber = 'P420906112258263' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419528' WHERE ordernumber = 'P200906112310909' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '239321' WHERE ordernumber = 'P180906112359179' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419345' WHERE ordernumber = 'P420906112412765' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419531' WHERE ordernumber = 'P200906112552616' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419532' WHERE ordernumber = 'P420906112608118' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419533' WHERE ordernumber = 'P420906112710561' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '342992' WHERE ordernumber = 'P180906112711753' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '124614' WHERE ordernumber = 'P190906112835508' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '393917' WHERE ordernumber = 'P420906112908322' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419535' WHERE ordernumber = 'P420906113023571' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '330364' WHERE ordernumber = 'P420906113112989' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419537' WHERE ordernumber = 'P420906113413605' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419538' WHERE ordernumber = 'P420906113517788' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '94226' WHERE ordernumber = 'P200906113548278' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '271209' WHERE ordernumber = 'P420906113633161' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419539' WHERE ordernumber = 'P200906113747129' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '312010' WHERE ordernumber = 'P190906113819441' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '417131' WHERE ordernumber = 'P420906113841935' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '126817' WHERE ordernumber = 'P190906113944807' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '142114' WHERE ordernumber = 'P200906113951289' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '291939' WHERE ordernumber = 'P190906114026397' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '142114' WHERE ordernumber = 'P200906114130526' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '99933' WHERE ordernumber = 'P200906114234858' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '417786' WHERE ordernumber = 'P190906114314501' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419540' WHERE ordernumber = 'P200906114348531' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '284276' WHERE ordernumber = 'P200906114429953' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '137475' WHERE ordernumber = 'P200906114614270' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '222509' WHERE ordernumber = 'P200906114847851' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419540' WHERE ordernumber = 'P200906115000698' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '128611' WHERE ordernumber = 'P180906115123848' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419542' WHERE ordernumber = 'P420906115229416' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '334859' WHERE ordernumber = 'P180906115313423' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419544' WHERE ordernumber = 'P420906115541449' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '147177' WHERE ordernumber = 'P420906115728991' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '278176' WHERE ordernumber = 'P200906120124141' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '414835' WHERE ordernumber = 'P420906120210383' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '299136' WHERE ordernumber = 'P420906120317287' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '393896' WHERE ordernumber = 'P420906120415720' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '275687' WHERE ordernumber = 'P420906120459303' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419545' WHERE ordernumber = 'P200906120630507' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419546' WHERE ordernumber = 'P420906120647347' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '100928' WHERE ordernumber = 'P200906120731386' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '338194' WHERE ordernumber = 'P180906120732349' 2024-09-07 01:00:02 -- UPDATE `omo_order_list` SET userId = '419547' WHERE ordernumber = 'P420906120813508' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419548' WHERE ordernumber = 'P200906120908855' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '306586' WHERE ordernumber = 'P190906121123861' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419550' WHERE ordernumber = 'P420906121231903' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '96489' WHERE ordernumber = 'P420906121314445' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '401189' WHERE ordernumber = 'P200906121510288' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419552' WHERE ordernumber = 'P200906121811983' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '87355' WHERE ordernumber = 'P180906122122905' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '149109' WHERE ordernumber = 'P200906122146525' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419553' WHERE ordernumber = 'P420906122207863' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419556' WHERE ordernumber = 'P420906122520484' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419557' WHERE ordernumber = 'P420906122636893' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '388093' WHERE ordernumber = 'P200906123205199' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '206610' WHERE ordernumber = 'P180906123242223' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '263732' WHERE ordernumber = 'P420906123326379' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '306735' WHERE ordernumber = 'P200906123352781' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '95310' WHERE ordernumber = 'P180906123355349' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419559' WHERE ordernumber = 'P420906123426346' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '418892' WHERE ordernumber = 'P190906123632749' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419560' WHERE ordernumber = 'P420906123635933' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '418892' WHERE ordernumber = 'P190906123707725' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419307' WHERE ordernumber = 'P420906123840390' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419558' WHERE ordernumber = 'P190906123843308' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '405142' WHERE ordernumber = 'P420906123923722' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419307' WHERE ordernumber = 'P420906124104826' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419563' WHERE ordernumber = 'P190906124225348' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419564' WHERE ordernumber = 'P420906124256977' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419561' WHERE ordernumber = 'P190906124336495' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '407596' WHERE ordernumber = 'P180906124340792' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419561' WHERE ordernumber = 'P190906124401238' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '415422' WHERE ordernumber = 'P630906124425447' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419565' WHERE ordernumber = 'P420906124429636' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '407596' WHERE ordernumber = 'P180906124433746' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '83426' WHERE ordernumber = 'P420906124604526' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419567' WHERE ordernumber = 'P420906124736788' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419565' WHERE ordernumber = 'P420906124812232' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '121498' WHERE ordernumber = 'P200906124900812' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '412595' WHERE ordernumber = 'P420906125130278' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419570' WHERE ordernumber = 'P420906125258180' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '355703' WHERE ordernumber = 'P200906125319434' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '194254' WHERE ordernumber = 'P420906125408888' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '390391' WHERE ordernumber = 'P630906125755355' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '281512' WHERE ordernumber = 'P180906125902437' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '412593' WHERE ordernumber = 'P180906130036788' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '355105' WHERE ordernumber = 'P190906130116804' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '133547' WHERE ordernumber = 'P420906130320883' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419575' WHERE ordernumber = 'P200906130938790' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '325074' WHERE ordernumber = 'P180906131011793' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '118743' WHERE ordernumber = 'P200906131019790' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '99506' WHERE ordernumber = 'P180906131145850' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '389071' WHERE ordernumber = 'P200906131223139' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '386182' WHERE ordernumber = 'P180906131406495' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419578' WHERE ordernumber = 'P200906131912458' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419551' WHERE ordernumber = 'P180906131915949' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419551' WHERE ordernumber = 'P180906131944664' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '281889' WHERE ordernumber = 'P180906132035743' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '400352' WHERE ordernumber = 'P200906132128518' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '367994' WHERE ordernumber = 'P180906132243779' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419489' WHERE ordernumber = 'P180906132422148' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419489' WHERE ordernumber = 'P180906132526246' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '414246' WHERE ordernumber = 'P420906132917216' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419581' WHERE ordernumber = 'P420906133044617' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '342564' WHERE ordernumber = 'P420906133111818' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419583' WHERE ordernumber = 'P180906133303114' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419584' WHERE ordernumber = 'P420906133410643' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '302736' WHERE ordernumber = 'P420906134326336' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '288433' WHERE ordernumber = 'P200906134334750' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '418316' WHERE ordernumber = 'P200906134422468' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419588' WHERE ordernumber = 'P420906134521480' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419589' WHERE ordernumber = 'P200906134531123' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '165317' WHERE ordernumber = 'P200906134601615' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '249481' WHERE ordernumber = 'P200906134932721' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '116033' WHERE ordernumber = 'P420906135110678' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '358902' WHERE ordernumber = 'P180906135301779' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419591' WHERE ordernumber = 'P200906135431830' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419442' WHERE ordernumber = 'P200906135544560' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '402584' WHERE ordernumber = 'P420906135815446' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '237169' WHERE ordernumber = 'P180906140041468' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419595' WHERE ordernumber = 'P200906140309176' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '407474' WHERE ordernumber = 'P420906140405789' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419594' WHERE ordernumber = 'P200906140503905' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '212247' WHERE ordernumber = 'P420906140940569' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '154682' WHERE ordernumber = 'P180906141051873' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '419596' WHERE ordernumber = 'P420906141125559' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '337154' WHERE ordernumber = 'P200906141209901' 2024-09-07 01:00:03 -- UPDATE `omo_order_list` SET userId = '337409' WHERE ordernumber = 'P180906141722392' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419599' WHERE ordernumber = 'P200906141859999' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '159019' WHERE ordernumber = 'P180906142050946' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '396097' WHERE ordernumber = 'P180906142121729' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '90212' WHERE ordernumber = 'P200906142339624' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '90212' WHERE ordernumber = 'P200906142731948' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '160798' WHERE ordernumber = 'P200906142838433' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419601' WHERE ordernumber = 'P200906142944908' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P190906143812900' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419605' WHERE ordernumber = 'P200906144145754' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '242042' WHERE ordernumber = 'P190906144237272' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '415875' WHERE ordernumber = 'P420906144242382' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419607' WHERE ordernumber = 'P200906144518704' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '102847' WHERE ordernumber = 'P180906144657130' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '342207' WHERE ordernumber = 'P420906145758182' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '410024' WHERE ordernumber = 'P420906150011887' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419295' WHERE ordernumber = 'P420906150341394' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '417778' WHERE ordernumber = 'P180906150911383' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '118667' WHERE ordernumber = 'P200906150942146' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '224548' WHERE ordernumber = 'P200906151007601' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '417778' WHERE ordernumber = 'P180906151010769' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '331478' WHERE ordernumber = 'P180906151133486' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '396625' WHERE ordernumber = 'P420906151519449' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '337334' WHERE ordernumber = 'P420906151708691' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '84477' WHERE ordernumber = 'P190906151851307' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '405833' WHERE ordernumber = 'P190906152322860' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419611' WHERE ordernumber = 'P200906152355245' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '39674' WHERE ordernumber = 'P630906152538449' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '417735' WHERE ordernumber = 'P200906152603719' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '39674' WHERE ordernumber = 'P630906152614553' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '396167' WHERE ordernumber = 'P200906152816467' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '139551' WHERE ordernumber = 'P180906153019336' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '418405' WHERE ordernumber = 'P200906153140405' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '310632' WHERE ordernumber = 'P180906153231808' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419612' WHERE ordernumber = 'P200906153400412' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419612' WHERE ordernumber = 'P200906153403471' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419613' WHERE ordernumber = 'P420906153719167' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '418705' WHERE ordernumber = 'P420906154045392' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '418705' WHERE ordernumber = 'P420906154141194' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '230264' WHERE ordernumber = 'P180906154324715' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '139551' WHERE ordernumber = 'P180906154350571' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '294695' WHERE ordernumber = 'P200906154426572' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419614' WHERE ordernumber = 'P420906154436314' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419616' WHERE ordernumber = 'P420906154932948' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '402399' WHERE ordernumber = 'P420906155109312' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419395' WHERE ordernumber = 'P200906155508315' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419618' WHERE ordernumber = 'P200906155851271' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '247665' WHERE ordernumber = 'P180906155954786' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '243072' WHERE ordernumber = 'P200906160440757' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '407309' WHERE ordernumber = 'P200906160541560' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419620' WHERE ordernumber = 'P420906160701634' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '344412' WHERE ordernumber = 'P200906160737184' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419621' WHERE ordernumber = 'P420906160852910' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419620' WHERE ordernumber = 'P420906161014140' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419622' WHERE ordernumber = 'P200906161119942' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419622' WHERE ordernumber = 'P200906161217771' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '245453' WHERE ordernumber = 'P420906161458989' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '408905' WHERE ordernumber = 'P420906161537485' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419620' WHERE ordernumber = 'P420906161651398' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '227087' WHERE ordernumber = 'P200906161714169' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419624' WHERE ordernumber = 'P420906162322688' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '403499' WHERE ordernumber = 'P200906162358378' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419624' WHERE ordernumber = 'P420906162446405' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419507' WHERE ordernumber = 'P420906162554956' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '250721' WHERE ordernumber = 'P200906162716316' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '299910' WHERE ordernumber = 'P630906162727340' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419625' WHERE ordernumber = 'P200906162946620' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '299910' WHERE ordernumber = 'P630906163028708' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '302279' WHERE ordernumber = 'P200906163137635' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '352539' WHERE ordernumber = 'P200906163206356' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '299910' WHERE ordernumber = 'P630906163217351' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419051' WHERE ordernumber = 'P200906163529975' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '212463' WHERE ordernumber = 'P180906163653715' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '300269' WHERE ordernumber = 'P200906163744392' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '279214' WHERE ordernumber = 'P420906163856487' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '95975' WHERE ordernumber = 'P200906164020549' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '381071' WHERE ordernumber = 'P200906164137862' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '409757' WHERE ordernumber = 'P200906164214710' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '267619' WHERE ordernumber = 'P200906164822374' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '380695' WHERE ordernumber = 'P420906164920482' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '100292' WHERE ordernumber = 'P180906165130723' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '267619' WHERE ordernumber = 'P200906165238967' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '148560' WHERE ordernumber = 'P200906165321286' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '253210' WHERE ordernumber = 'P180906165525676' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419632' WHERE ordernumber = 'P200906165618415' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '112093' WHERE ordernumber = 'P180906165830968' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419633' WHERE ordernumber = 'P180906170047276' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '405104' WHERE ordernumber = 'P420906170204906' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '380903' WHERE ordernumber = 'P420906170345947' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '311284' WHERE ordernumber = 'P200906170648483' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '403285' WHERE ordernumber = 'P180906170711599' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '95036' WHERE ordernumber = 'P180906170808804' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419638' WHERE ordernumber = 'P420906170829598' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '300829' WHERE ordernumber = 'P200906170929855' 2024-09-07 01:00:04 -- UPDATE `omo_order_list` SET userId = '419627' WHERE ordernumber = 'P420906171022664' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '380394' WHERE ordernumber = 'P420906171321597' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '183604' WHERE ordernumber = 'P200906171448605' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419640' WHERE ordernumber = 'P180906171456927' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '151841' WHERE ordernumber = 'P420906172025804' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '396643' WHERE ordernumber = 'P200906172227414' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419643' WHERE ordernumber = 'P200906172356805' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '374290' WHERE ordernumber = 'P420906172424676' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '244648' WHERE ordernumber = 'P200906172446837' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '418913' WHERE ordernumber = 'P420906172517334' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '377582' WHERE ordernumber = 'P200906172618718' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419644' WHERE ordernumber = 'P420906172626554' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '351288' WHERE ordernumber = 'P180906172711228' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '220955' WHERE ordernumber = 'P200906173107990' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '98869' WHERE ordernumber = 'P200906173148171' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '400678' WHERE ordernumber = 'P180906173238593' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '396061' WHERE ordernumber = 'P590906173539713' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '410221' WHERE ordernumber = 'P420906173842287' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '218040' WHERE ordernumber = 'P180906174144529' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419647' WHERE ordernumber = 'P420906174221609' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419648' WHERE ordernumber = 'P420906174338508' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '418738' WHERE ordernumber = 'P420906174710736' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '353135' WHERE ordernumber = 'P180906174750688' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '55660' WHERE ordernumber = 'P180906174836276' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '416707' WHERE ordernumber = 'P200906175043334' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419650' WHERE ordernumber = 'P200906175315597' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '129091' WHERE ordernumber = 'P180906175622427' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419631' WHERE ordernumber = 'P200906175850821' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419652' WHERE ordernumber = 'P420906180022752' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419654' WHERE ordernumber = 'P420906180631515' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419656' WHERE ordernumber = 'P420906180708352' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '415944' WHERE ordernumber = 'P420906180947503' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419658' WHERE ordernumber = 'P200906181016524' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419659' WHERE ordernumber = 'P180906181129223' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '348665' WHERE ordernumber = 'P180906181241196' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '341738' WHERE ordernumber = 'P180906181507516' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419661' WHERE ordernumber = 'P200906181520467' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '339616' WHERE ordernumber = 'P180906181556114' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419662' WHERE ordernumber = 'P420906181636313' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '336956' WHERE ordernumber = 'P420906181753504' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '403063' WHERE ordernumber = 'P180906181858369' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '402812' WHERE ordernumber = 'P420906181900249' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419623' WHERE ordernumber = 'P180906181950361' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419629' WHERE ordernumber = 'P200906182200907' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419666' WHERE ordernumber = 'P420906182458611' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419629' WHERE ordernumber = 'P200906182510272' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '305261' WHERE ordernumber = 'P200906182603465' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '379918' WHERE ordernumber = 'P180906182717147' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419667' WHERE ordernumber = 'P180906183217630' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '418601' WHERE ordernumber = 'P200906183251457' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '418601' WHERE ordernumber = 'P200906183426889' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419670' WHERE ordernumber = 'P420906183726497' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '237186' WHERE ordernumber = 'P180906183812219' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '132387' WHERE ordernumber = 'P200906183847527' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419359' WHERE ordernumber = 'P200906184102756' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '336422' WHERE ordernumber = 'P180906184135907' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '266731' WHERE ordernumber = 'P200906184224524' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '81299' WHERE ordernumber = 'P180906184325712' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '298329' WHERE ordernumber = 'P420906184342529' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '266731' WHERE ordernumber = 'P200906184428482' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '108067' WHERE ordernumber = 'P180906184429321' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '324810' WHERE ordernumber = 'P420906184434214' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '108067' WHERE ordernumber = 'P180906184435824' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '306150' WHERE ordernumber = 'P180906184557938' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419672' WHERE ordernumber = 'P420906184707732' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '389128' WHERE ordernumber = 'P180906184718771' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419675' WHERE ordernumber = 'P420906185049424' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '408012' WHERE ordernumber = 'P180906185128517' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '282069' WHERE ordernumber = 'P180906185253894' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419676' WHERE ordernumber = 'P420906185349807' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '338257' WHERE ordernumber = 'P200906185351930' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '332698' WHERE ordernumber = 'P180906185453333' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '272337' WHERE ordernumber = 'P200906190326174' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '359921' WHERE ordernumber = 'P190906190557521' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '359921' WHERE ordernumber = 'P190906190644610' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419679' WHERE ordernumber = 'P180906190732447' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419451' WHERE ordernumber = 'P200906190734910' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '119332' WHERE ordernumber = 'P180906190830589' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '413787' WHERE ordernumber = 'P200906191044783' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419682' WHERE ordernumber = 'P200906191420638' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419681' WHERE ordernumber = 'P180906191442207' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '382110' WHERE ordernumber = 'P190906191443842' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419681' WHERE ordernumber = 'P180906191521167' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419680' WHERE ordernumber = 'P190906191528898' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419683' WHERE ordernumber = 'P200906191719973' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419680' WHERE ordernumber = 'P180906191737956' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419684' WHERE ordernumber = 'P200906191903850' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '194753' WHERE ordernumber = 'P200906192057122' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '410687' WHERE ordernumber = 'P180906192504650' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '89714' WHERE ordernumber = 'P190906192533700' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419669' WHERE ordernumber = 'P180906192647444' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '300327' WHERE ordernumber = 'P180906192927275' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '215525' WHERE ordernumber = 'P190906192955630' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419686' WHERE ordernumber = 'P200906193224400' 2024-09-07 01:00:05 -- UPDATE `omo_order_list` SET userId = '419682' WHERE ordernumber = 'P200906193328222' 2024-09-07 01:00:06 -- UPDATE `omo_order_list` SET userId = '419022' WHERE ordernumber = 'P200906193654196' 2024-09-07 01:00:06 -- UPDATE `omo_order_list` SET userId = '258305' WHERE ordernumber = 'P200906193804490' 2024-09-07 01:00:06 -- UPDATE `omo_order_list` SET userId = '97453' WHERE ordernumber = 'P200906194008363' 2024-09-07 01:00:06 -- UPDATE `omo_order_list` SET userId = '409502' WHERE ordernumber = 'P180906194304730' 2024-09-07 01:00:06 -- UPDATE `omo_order_list` SET userId = '318528' WHERE ordernumber = 'P180906194619249' 2024-09-07 01:00:06 -- UPDATE `omo_order_list` SET userId = '186272' WHERE ordernumber = 'P200906194649354' 2024-09-07 01:00:06 -- UPDATE `omo_order_list` SET userId = '114191' WHERE ordernumber = 'P200906194831806' 2024-09-07 01:00:06 -- UPDATE `omo_order_list` SET userId = '114191' WHERE ordernumber = 'P200906194906283' 2024-09-07 01:00:06 -- UPDATE `omo_order_list` SET userId = '375621' WHERE ordernumber = 'P630906194933766' 2024-09-07 01:00:06 -- UPDATE `omo_order_list` SET userId = '130986' WHERE ordernumber = 'P190906195223116'