2024-03-28 01:00:02 -- 將會員中心id寫入data-lake
2024-03-28 01:00:02 -- 
            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-03-27%';
        
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237401'
                WHERE ordernumber = 'P200327110038308' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96884'
                WHERE ordernumber = 'P200327110143177' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218966'
                WHERE ordernumber = 'P180327110213365' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335237'
                WHERE ordernumber = 'P420327110249534' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383280'
                WHERE ordernumber = 'P200327110346166' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305979'
                WHERE ordernumber = 'P190327110605388' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383281'
                WHERE ordernumber = 'P420327110623253' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383282'
                WHERE ordernumber = 'P200327110703989' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383283'
                WHERE ordernumber = 'P190327110937623' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382052'
                WHERE ordernumber = 'P180327111020717' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255814'
                WHERE ordernumber = 'P190327111122788' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118605'
                WHERE ordernumber = 'P200327111312406' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383283'
                WHERE ordernumber = 'P180327111413823' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200327111754476' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338215'
                WHERE ordernumber = 'P180327112040135' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266791'
                WHERE ordernumber = 'P420327112047442' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383285'
                WHERE ordernumber = 'P200327112155287' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180327112242447' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291133'
                WHERE ordernumber = 'P420327112243889' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239481'
                WHERE ordernumber = 'P180327112907799' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337747'
                WHERE ordernumber = 'P420327113020541' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383286'
                WHERE ordernumber = 'P420327113356680' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383287'
                WHERE ordernumber = 'P180327113542898' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318388'
                WHERE ordernumber = 'P420327113556857' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383288'
                WHERE ordernumber = 'P180327114143337' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383290'
                WHERE ordernumber = 'P200327114418620' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236194'
                WHERE ordernumber = 'P180327114449975' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314788'
                WHERE ordernumber = 'P420327114451867' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383291'
                WHERE ordernumber = 'P180327114602698' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102881'
                WHERE ordernumber = 'P200327114717499' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383292'
                WHERE ordernumber = 'P180327114751589' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383292'
                WHERE ordernumber = 'P180327114812575' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344867'
                WHERE ordernumber = 'P180327115030346' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265645'
                WHERE ordernumber = 'P180327115243217' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383293'
                WHERE ordernumber = 'P180327115750949' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342888'
                WHERE ordernumber = 'P180327115934790' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352001'
                WHERE ordernumber = 'P180327120223875' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382372'
                WHERE ordernumber = 'P590327120347406' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383294'
                WHERE ordernumber = 'P200327120415243' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285355'
                WHERE ordernumber = 'P200327120746716' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370868'
                WHERE ordernumber = 'P200327121031992' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285355'
                WHERE ordernumber = 'P200327121121893' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383295'
                WHERE ordernumber = 'P590327121305502' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383296'
                WHERE ordernumber = 'P200327121307751' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339876'
                WHERE ordernumber = 'P420327121854720' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97665'
                WHERE ordernumber = 'P180327122014424' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383297'
                WHERE ordernumber = 'P180327122330619' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219228'
                WHERE ordernumber = 'P180327122506289' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162043'
                WHERE ordernumber = 'P180327122711216' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97865'
                WHERE ordernumber = 'P180327123503573' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285854'
                WHERE ordernumber = 'P200327124227584' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383299'
                WHERE ordernumber = 'P200327124724270' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299923'
                WHERE ordernumber = 'P200327124858760' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372345'
                WHERE ordernumber = 'P180327125216227' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383302'
                WHERE ordernumber = 'P180327125332495' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294795'
                WHERE ordernumber = 'P200327125929439' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383303'
                WHERE ordernumber = 'P420327130007150' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383305'
                WHERE ordernumber = 'P200327131112930' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383305'
                WHERE ordernumber = 'P200327131150429' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383306'
                WHERE ordernumber = 'P180327131209741' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99132'
                WHERE ordernumber = 'P200327131314585' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383307'
                WHERE ordernumber = 'P200327131435352' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377632'
                WHERE ordernumber = 'P420327131446470' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80172'
                WHERE ordernumber = 'P420327131640877' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P180327131746343' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67607'
                WHERE ordernumber = 'P420327131746286' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212315'
                WHERE ordernumber = 'P200327132300925' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317861'
                WHERE ordernumber = 'P420327132617619' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147670'
                WHERE ordernumber = 'P180327132922171' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383310'
                WHERE ordernumber = 'P180327133254647' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263723'
                WHERE ordernumber = 'P180327133640187' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383314'
                WHERE ordernumber = 'P180327134603187' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216898'
                WHERE ordernumber = 'P180327134916839' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66178'
                WHERE ordernumber = 'P200327134959776' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180327135043911' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383119'
                WHERE ordernumber = 'P420327135328129' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258376'
                WHERE ordernumber = 'P180327135810957' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180327140036919' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383316'
                WHERE ordernumber = 'P420327140152931' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383315'
                WHERE ordernumber = 'P200327140304696' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360898'
                WHERE ordernumber = 'P180327140752657' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383317'
                WHERE ordernumber = 'P180327141325587' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133035'
                WHERE ordernumber = 'P180327141702549' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383320'
                WHERE ordernumber = 'P590327143300931' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383322'
                WHERE ordernumber = 'P180327143300660' 
            
2024-03-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383323'
                WHERE ordernumber = 'P200327143902793' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283536'
                WHERE ordernumber = 'P200327144913697' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P200327145720234' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383325'
                WHERE ordernumber = 'P180327145721619' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98582'
                WHERE ordernumber = 'P200327145822502' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383327'
                WHERE ordernumber = 'P180327150320318' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243544'
                WHERE ordernumber = 'P180327150739456' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379914'
                WHERE ordernumber = 'P200327150745147' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383328'
                WHERE ordernumber = 'P180327151439193' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383329'
                WHERE ordernumber = 'P420327151634627' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383301'
                WHERE ordernumber = 'P200327151651748' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253287'
                WHERE ordernumber = 'P180327153231735' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129983'
                WHERE ordernumber = 'P190327153615159' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383330'
                WHERE ordernumber = 'P200327153645193' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383333'
                WHERE ordernumber = 'P200327153808780' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229353'
                WHERE ordernumber = 'P190327154310782' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98396'
                WHERE ordernumber = 'P200327154315311' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383334'
                WHERE ordernumber = 'P180327154357675' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383336'
                WHERE ordernumber = 'P180327154926666' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383270'
                WHERE ordernumber = 'P590327155004549' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383336'
                WHERE ordernumber = 'P180327155328684' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383249'
                WHERE ordernumber = 'P200327155705338' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383337'
                WHERE ordernumber = 'P420327160251311' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92319'
                WHERE ordernumber = 'P420327160518213' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383338'
                WHERE ordernumber = 'P200327160701564' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383339'
                WHERE ordernumber = 'P180327160829587' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383340'
                WHERE ordernumber = 'P200327161016560' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234868'
                WHERE ordernumber = 'P180327161310295' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383342'
                WHERE ordernumber = 'P420327161321244' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329353'
                WHERE ordernumber = 'P180327161457857' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293012'
                WHERE ordernumber = 'P200327161722428' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383344'
                WHERE ordernumber = 'P200327161957532' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383345'
                WHERE ordernumber = 'P180327162031334' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246968'
                WHERE ordernumber = 'P180327162147185' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349590'
                WHERE ordernumber = 'P180327162316375' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383343'
                WHERE ordernumber = 'P180327162427456' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381896'
                WHERE ordernumber = 'P420327162643771' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '71374'
                WHERE ordernumber = 'P180327162708900' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381896'
                WHERE ordernumber = 'P420327162806958' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383346'
                WHERE ordernumber = 'P200327163011287' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208840'
                WHERE ordernumber = 'P180327163145125' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238006'
                WHERE ordernumber = 'P180327163626198' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383331'
                WHERE ordernumber = 'P590327165025218' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383347'
                WHERE ordernumber = 'P180327165051716' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283963'
                WHERE ordernumber = 'P200327165613336' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383349'
                WHERE ordernumber = 'P180327170019134' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383351'
                WHERE ordernumber = 'P180327170308600' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383352'
                WHERE ordernumber = 'P180327170614296' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383353'
                WHERE ordernumber = 'P420327171425334' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383354'
                WHERE ordernumber = 'P420327171544191' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383355'
                WHERE ordernumber = 'P420327172035716' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383357'
                WHERE ordernumber = 'P180327172211515' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383356'
                WHERE ordernumber = 'P200327172226476' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383358'
                WHERE ordernumber = 'P180327172630974' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383359'
                WHERE ordernumber = 'P420327172837162' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118192'
                WHERE ordernumber = 'P200327173155633' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377505'
                WHERE ordernumber = 'P200327173256114' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383361'
                WHERE ordernumber = 'P420327173339342' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364734'
                WHERE ordernumber = 'P420327173509150' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383362'
                WHERE ordernumber = 'P420327173636593' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383363'
                WHERE ordernumber = 'P590327173713895' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383365'
                WHERE ordernumber = 'P180327174113925' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383364'
                WHERE ordernumber = 'P420327174116682' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383366'
                WHERE ordernumber = 'P180327174331598' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379251'
                WHERE ordernumber = 'P420327175141740' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383369'
                WHERE ordernumber = 'P200327175400167' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102422'
                WHERE ordernumber = 'P200327175455706' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383370'
                WHERE ordernumber = 'P190327180025822' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132442'
                WHERE ordernumber = 'P190327180227411' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383371'
                WHERE ordernumber = 'P420327180537594' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272794'
                WHERE ordernumber = 'P200327180745932' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281876'
                WHERE ordernumber = 'P190327181219727' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383372'
                WHERE ordernumber = 'P420327181749552' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383141'
                WHERE ordernumber = 'P200327182344966' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383373'
                WHERE ordernumber = 'P190327182402924' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322812'
                WHERE ordernumber = 'P200327182521971' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383374'
                WHERE ordernumber = 'P420327182617818' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138998'
                WHERE ordernumber = 'P200327184302342' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '28678'
                WHERE ordernumber = 'P420327184405361' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289569'
                WHERE ordernumber = 'P420327185121424' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352257'
                WHERE ordernumber = 'P200327185305353' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240046'
                WHERE ordernumber = 'P190327185838237' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383376'
                WHERE ordernumber = 'P190327190645836' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240634'
                WHERE ordernumber = 'P200327190733416' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383377'
                WHERE ordernumber = 'P420327190740187' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383378'
                WHERE ordernumber = 'P190327191007599' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383381'
                WHERE ordernumber = 'P200327191258589' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383380'
                WHERE ordernumber = 'P190327191810301' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378270'
                WHERE ordernumber = 'P190327192008899' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383311'
                WHERE ordernumber = 'P190327192741428' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383383'
                WHERE ordernumber = 'P420327193124556' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383384'
                WHERE ordernumber = 'P420327193236379' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354155'
                WHERE ordernumber = 'P190327193901146' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383082'
                WHERE ordernumber = 'P190327194114800' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383385'
                WHERE ordernumber = 'P420327194134342' 
            
2024-03-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383386'
                WHERE ordernumber = 'P190327194614901' 
            
2024-03-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '326275'
                WHERE ordernumber = 'P200327194703785' 
            
2024-03-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383388'
                WHERE ordernumber = 'P420327194835520' 
            
2024-03-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '294914'
                WHERE ordernumber = 'P420327195219727' 
            
2024-03-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303132'
                WHERE ordernumber = 'P190327195311195' 
            
2024-03-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365768'
                WHERE ordernumber = 'P420327195340822' 
            
2024-03-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329340'
                WHERE ordernumber = 'P200327195717636' 
            
2024-03-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '32411'
                WHERE ordernumber = 'P200327200030534' 
            
2024-03-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383389'
                WHERE ordernumber = 'P200327200301410' 
            
2024-03-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383390'
                WHERE ordernumber = 'P590327200852790'