2024-03-19 01:00:02 -- 將會員中心id寫入data-lake
2024-03-19 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-18%';
        
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382057'
                WHERE ordernumber = 'P180318110428477' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382058'
                WHERE ordernumber = 'P180318110539407' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382060'
                WHERE ordernumber = 'P420318111333178' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314363'
                WHERE ordernumber = 'P200318111426321' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382064'
                WHERE ordernumber = 'P180318111932812' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382066'
                WHERE ordernumber = 'P180318112146947' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102757'
                WHERE ordernumber = 'P200318112226946' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420318112428907' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382068'
                WHERE ordernumber = 'P420318113336241' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382070'
                WHERE ordernumber = 'P590318114705629' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382071'
                WHERE ordernumber = 'P180318115046283' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138351'
                WHERE ordernumber = 'P200318115902265' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382076'
                WHERE ordernumber = 'P180318121652684' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381576'
                WHERE ordernumber = 'P180318121859242' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376318'
                WHERE ordernumber = 'P420318121954754' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382078'
                WHERE ordernumber = 'P420318122455145' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99632'
                WHERE ordernumber = 'P180318123050895' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382080'
                WHERE ordernumber = 'P200318123425572' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102337'
                WHERE ordernumber = 'P180318124322552' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381996'
                WHERE ordernumber = 'P180318124543666' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382081'
                WHERE ordernumber = 'P420318124636223' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139532'
                WHERE ordernumber = 'P200318124936370' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382084'
                WHERE ordernumber = 'P180318124937684' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382085'
                WHERE ordernumber = 'P190318125140831' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381313'
                WHERE ordernumber = 'P420318125322355' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332122'
                WHERE ordernumber = 'P190318125429260' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382086'
                WHERE ordernumber = 'P180318130420138' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102016'
                WHERE ordernumber = 'P200318130530451' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355344'
                WHERE ordernumber = 'P180318130724343' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180318130805445' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329420'
                WHERE ordernumber = 'P180318131711517' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382088'
                WHERE ordernumber = 'P180318132141908' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311532'
                WHERE ordernumber = 'P180318132436256' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311532'
                WHERE ordernumber = 'P180318132517965' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345324'
                WHERE ordernumber = 'P420318132609623' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127600'
                WHERE ordernumber = 'P180318132701245' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382087'
                WHERE ordernumber = 'P180318133015238' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382087'
                WHERE ordernumber = 'P180318133039868' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382089'
                WHERE ordernumber = 'P180318133355265' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382090'
                WHERE ordernumber = 'P180318133539601' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382091'
                WHERE ordernumber = 'P180318133729982' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '131453'
                WHERE ordernumber = 'P180318133854239' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382093'
                WHERE ordernumber = 'P180318134020492' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382095'
                WHERE ordernumber = 'P200318134407708' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382094'
                WHERE ordernumber = 'P180318134444507' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368419'
                WHERE ordernumber = 'P180318134709896' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94460'
                WHERE ordernumber = 'P200318135006168' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382096'
                WHERE ordernumber = 'P180318135040829' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324564'
                WHERE ordernumber = 'P200318135215381' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237385'
                WHERE ordernumber = 'P180318135958697' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382098'
                WHERE ordernumber = 'P420318140414117' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288773'
                WHERE ordernumber = 'P180318140719147' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261147'
                WHERE ordernumber = 'P200318141510943' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377184'
                WHERE ordernumber = 'P180318141823895' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301287'
                WHERE ordernumber = 'P200318142006763' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222164'
                WHERE ordernumber = 'P180318142020764' 
            
2024-03-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382099'
                WHERE ordernumber = 'P420318142213987' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301153'
                WHERE ordernumber = 'P200318142516530' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382100'
                WHERE ordernumber = 'P200318142607456' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111560'
                WHERE ordernumber = 'P180318143052310' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112335'
                WHERE ordernumber = 'P180318143756569' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283649'
                WHERE ordernumber = 'P200318143935768' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382101'
                WHERE ordernumber = 'P180318144125304' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382101'
                WHERE ordernumber = 'P180318144241811' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382102'
                WHERE ordernumber = 'P180318144336679' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379002'
                WHERE ordernumber = 'P180318144440164' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382104'
                WHERE ordernumber = 'P180318145744997' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100515'
                WHERE ordernumber = 'P180318145907337' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382105'
                WHERE ordernumber = 'P420318145941289' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270938'
                WHERE ordernumber = 'P200318150056856' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99520'
                WHERE ordernumber = 'P180318151029814' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99520'
                WHERE ordernumber = 'P180318151108402' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382106'
                WHERE ordernumber = 'P190318151603622' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382107'
                WHERE ordernumber = 'P420318151617265' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P180318151624196' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358172'
                WHERE ordernumber = 'P420318151853587' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258200'
                WHERE ordernumber = 'P180318152411335' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382109'
                WHERE ordernumber = 'P420318152639321' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244849'
                WHERE ordernumber = 'P200318153411627' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382111'
                WHERE ordernumber = 'P200318153750699' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382112'
                WHERE ordernumber = 'P420318154103634' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382113'
                WHERE ordernumber = 'P180318154424536' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382114'
                WHERE ordernumber = 'P420318154652954' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382116'
                WHERE ordernumber = 'P420318155022136' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360735'
                WHERE ordernumber = 'P180318155046311' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297160'
                WHERE ordernumber = 'P420318155348138' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382075'
                WHERE ordernumber = 'P420318155514544' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382117'
                WHERE ordernumber = 'P190318155626588' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381696'
                WHERE ordernumber = 'P190318160506287' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334778'
                WHERE ordernumber = 'P420318160829414' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382118'
                WHERE ordernumber = 'P200318160935516' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382119'
                WHERE ordernumber = 'P420318161316818' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334937'
                WHERE ordernumber = 'P420318161514452' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343931'
                WHERE ordernumber = 'P180318161919559' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300099'
                WHERE ordernumber = 'P420318162216917' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382121'
                WHERE ordernumber = 'P200318162252720' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329610'
                WHERE ordernumber = 'P420318162444144' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96030'
                WHERE ordernumber = 'P180318162614552' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382122'
                WHERE ordernumber = 'P420318163302608' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354703'
                WHERE ordernumber = 'P420318163410557' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331469'
                WHERE ordernumber = 'P420318163749162' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382123'
                WHERE ordernumber = 'P420318164335836' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382125'
                WHERE ordernumber = 'P420318165639146' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382126'
                WHERE ordernumber = 'P180318170216679' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379940'
                WHERE ordernumber = 'P200318170310834' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257146'
                WHERE ordernumber = 'P180318171201671' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300476'
                WHERE ordernumber = 'P420318171344127' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200318171638881' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382129'
                WHERE ordernumber = 'P200318171827249' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292423'
                WHERE ordernumber = 'P200318172507743' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P420318172620626' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382130'
                WHERE ordernumber = 'P200318173337963' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382131'
                WHERE ordernumber = 'P200318173514463' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229319'
                WHERE ordernumber = 'P180318173523508' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283083'
                WHERE ordernumber = 'P200318174039445' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349590'
                WHERE ordernumber = 'P180318174641474' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292428'
                WHERE ordernumber = 'P190318174816960' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382132'
                WHERE ordernumber = 'P180318174821596' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141122'
                WHERE ordernumber = 'P200318174832509' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381382'
                WHERE ordernumber = 'P190318174904217' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382034'
                WHERE ordernumber = 'P200318174957186' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382133'
                WHERE ordernumber = 'P200318175302430' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165307'
                WHERE ordernumber = 'P200318175850562' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165307'
                WHERE ordernumber = 'P200318180022444' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382134'
                WHERE ordernumber = 'P180318180059160' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377368'
                WHERE ordernumber = 'P420318180342294' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382135'
                WHERE ordernumber = 'P420318180517995' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214967'
                WHERE ordernumber = 'P200318180621734' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381967'
                WHERE ordernumber = 'P190318181435528' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284404'
                WHERE ordernumber = 'P180318182109793' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382138'
                WHERE ordernumber = 'P420318182627760' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '32411'
                WHERE ordernumber = 'P200318183707766' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241208'
                WHERE ordernumber = 'P200318184110703' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382140'
                WHERE ordernumber = 'P420318184535678' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307686'
                WHERE ordernumber = 'P200318184800914' 
            
2024-03-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381530'
                WHERE ordernumber = 'P420318185736909' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98929'
                WHERE ordernumber = 'P190318185940560' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382143'
                WHERE ordernumber = 'P420318190626378' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382144'
                WHERE ordernumber = 'P190318190644355' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382145'
                WHERE ordernumber = 'P590318191330967' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247277'
                WHERE ordernumber = 'P200318191335881' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382146'
                WHERE ordernumber = 'P190318191504724' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82183'
                WHERE ordernumber = 'P200318191616909' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105793'
                WHERE ordernumber = 'P190318192003233' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98423'
                WHERE ordernumber = 'P200318192422203' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382147'
                WHERE ordernumber = 'P190318192458282' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382148'
                WHERE ordernumber = 'P190318192709692' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318604'
                WHERE ordernumber = 'P190318192850791' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380459'
                WHERE ordernumber = 'P420318193254663' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330762'
                WHERE ordernumber = 'P190318193347272' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330762'
                WHERE ordernumber = 'P190318193424617' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208457'
                WHERE ordernumber = 'P190318193521812' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382149'
                WHERE ordernumber = 'P190318193637328' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283032'
                WHERE ordernumber = 'P190318193857894' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283036'
                WHERE ordernumber = 'P190318194204923' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271863'
                WHERE ordernumber = 'P420318194247156' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382151'
                WHERE ordernumber = 'P190318194752657' 
            
2024-03-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381570'
                WHERE ordernumber = 'P200318195914637'