2024-10-24 01:00:02 -- 將會員中心id寫入data-lake
2024-10-24 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-10-23%';
        
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365738'
                WHERE ordernumber = 'P631023100315821' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427178'
                WHERE ordernumber = 'P181023110317568' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427179'
                WHERE ordernumber = 'P181023110529618' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '203673'
                WHERE ordernumber = 'P181023110625191' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '203673'
                WHERE ordernumber = 'P181023110654800' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427177'
                WHERE ordernumber = 'P731023110749461' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381202'
                WHERE ordernumber = 'P181023110935918' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418756'
                WHERE ordernumber = 'P201023110941518' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427181'
                WHERE ordernumber = 'P181023111029505' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427183'
                WHERE ordernumber = 'P181023111802909' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424891'
                WHERE ordernumber = 'P181023112024647' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394499'
                WHERE ordernumber = 'P181023112311316' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427184'
                WHERE ordernumber = 'P711023112421334' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241589'
                WHERE ordernumber = 'P181023112728313' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258460'
                WHERE ordernumber = 'P191023112940199' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427185'
                WHERE ordernumber = 'P181023113113287' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427186'
                WHERE ordernumber = 'P191023113236780' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384839'
                WHERE ordernumber = 'P181023113643562' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138293'
                WHERE ordernumber = 'P181023114857515' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138293'
                WHERE ordernumber = 'P181023115157322' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427189'
                WHERE ordernumber = 'P181023120304993' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P421023120351911' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P421023120623538' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P421023120623538' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P421023120623538' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427192'
                WHERE ordernumber = 'P181023121313676' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427191'
                WHERE ordernumber = 'P771023121316208' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P421023120623538' 
            
2024-10-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427194'
                WHERE ordernumber = 'P771023121816600' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246112'
                WHERE ordernumber = 'P181023121851932' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P421023120623538' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246060'
                WHERE ordernumber = 'P181023122342137' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221827'
                WHERE ordernumber = 'P201023122359288' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254100'
                WHERE ordernumber = 'P711023122542752' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427195'
                WHERE ordernumber = 'P771023122558798' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239481'
                WHERE ordernumber = 'P181023123338686' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427198'
                WHERE ordernumber = 'P181023124504739' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239096'
                WHERE ordernumber = 'P201023124531155' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427197'
                WHERE ordernumber = 'P731023124835230' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427199'
                WHERE ordernumber = 'P201023124849954' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427200'
                WHERE ordernumber = 'P201023125655805' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427202'
                WHERE ordernumber = 'P201023125906561' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427203'
                WHERE ordernumber = 'P771023130152993' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369981'
                WHERE ordernumber = 'P421023130205301' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427204'
                WHERE ordernumber = 'P201023130542950' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427206'
                WHERE ordernumber = 'P421023131400508' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '55463'
                WHERE ordernumber = 'P181023131421552' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399336'
                WHERE ordernumber = 'P771023131604596' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342339'
                WHERE ordernumber = 'P421023132122425' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412721'
                WHERE ordernumber = 'P201023132124272' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328300'
                WHERE ordernumber = 'P421023132222609' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P421023120623538' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P421023120623538' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344013'
                WHERE ordernumber = 'P421023132930895' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427209'
                WHERE ordernumber = 'P201023132935677' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426773'
                WHERE ordernumber = 'P421023133503728' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424070'
                WHERE ordernumber = 'P711023133520402' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342438'
                WHERE ordernumber = 'P421023133948680' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '185470'
                WHERE ordernumber = 'P201023134207748' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427211'
                WHERE ordernumber = 'P191023134924276' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427210'
                WHERE ordernumber = 'P731023135036801' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379133'
                WHERE ordernumber = 'P191023135048788' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404015'
                WHERE ordernumber = 'P201023135151817' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213710'
                WHERE ordernumber = 'P731023135513652' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427212'
                WHERE ordernumber = 'P201023135534657' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100745'
                WHERE ordernumber = 'P191023135811620' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426995'
                WHERE ordernumber = 'P771023140056716' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427214'
                WHERE ordernumber = 'P201023140101380' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424070'
                WHERE ordernumber = 'P711023140123219' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427213'
                WHERE ordernumber = 'P191023140150400' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '38020'
                WHERE ordernumber = 'P201023140545661' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251950'
                WHERE ordernumber = 'P201023140755743' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427215'
                WHERE ordernumber = 'P421023140757177' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P421023120623538' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374785'
                WHERE ordernumber = 'P181023141716717' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391767'
                WHERE ordernumber = 'P421023142051156' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327431'
                WHERE ordernumber = 'P201023142131900' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427218'
                WHERE ordernumber = 'P771023142234396' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384637'
                WHERE ordernumber = 'P181023142341114' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427220'
                WHERE ordernumber = 'P201023142422401' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427219'
                WHERE ordernumber = 'P771023142503554' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294793'
                WHERE ordernumber = 'P201023142626173' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66067'
                WHERE ordernumber = 'P421023142915306' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426699'
                WHERE ordernumber = 'P421023143908617' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427222'
                WHERE ordernumber = 'P181023144232648' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427225'
                WHERE ordernumber = 'P191023144648343' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385358'
                WHERE ordernumber = 'P181023144906200' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427223'
                WHERE ordernumber = 'P421023145015603' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392795'
                WHERE ordernumber = 'P181023145022478' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427228'
                WHERE ordernumber = 'P771023145021816' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427230'
                WHERE ordernumber = 'P181023145426131' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427231'
                WHERE ordernumber = 'P201023145545376' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427232'
                WHERE ordernumber = 'P181023145652162' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427233'
                WHERE ordernumber = 'P181023145915390' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375944'
                WHERE ordernumber = 'P191023150056300' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306372'
                WHERE ordernumber = 'P201023150256915' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427234'
                WHERE ordernumber = 'P181023150538281' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427235'
                WHERE ordernumber = 'P201023151032136' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427223'
                WHERE ordernumber = 'P421023151116423' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427236'
                WHERE ordernumber = 'P201023151358361' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427238'
                WHERE ordernumber = 'P181023151446228' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427239'
                WHERE ordernumber = 'P181023151749339' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347511'
                WHERE ordernumber = 'P201023151758157' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423348'
                WHERE ordernumber = 'P181023152352869' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420826'
                WHERE ordernumber = 'P201023152531764' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427237'
                WHERE ordernumber = 'P181023153005860' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427237'
                WHERE ordernumber = 'P181023153105279' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345976'
                WHERE ordernumber = 'P421023153112861' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427240'
                WHERE ordernumber = 'P201023153250596' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426423'
                WHERE ordernumber = 'P181023153756198' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427242'
                WHERE ordernumber = 'P181023154602261' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427243'
                WHERE ordernumber = 'P191023154720744' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103227'
                WHERE ordernumber = 'P201023155240396' 
            
2024-10-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427241'
                WHERE ordernumber = 'P181023155447655' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212476'
                WHERE ordernumber = 'P191023155816273' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427246'
                WHERE ordernumber = 'P711023160005529' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427245'
                WHERE ordernumber = 'P421023160038699' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427241'
                WHERE ordernumber = 'P191023160237627' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427247'
                WHERE ordernumber = 'P191023160536424' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426166'
                WHERE ordernumber = 'P181023161149513' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272640'
                WHERE ordernumber = 'P201023161203878' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427249'
                WHERE ordernumber = 'P181023161432470' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427248'
                WHERE ordernumber = 'P771023161657254' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427250'
                WHERE ordernumber = 'P421023161802126' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427251'
                WHERE ordernumber = 'P201023161817183' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427252'
                WHERE ordernumber = 'P201023162003347' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427253'
                WHERE ordernumber = 'P421023162303574' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381159'
                WHERE ordernumber = 'P421023162553485' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427254'
                WHERE ordernumber = 'P731023162620623' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239428'
                WHERE ordernumber = 'P181023162908454' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102081'
                WHERE ordernumber = 'P181023163627979' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427256'
                WHERE ordernumber = 'P201023163947126' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P421023120623538' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427257'
                WHERE ordernumber = 'P181023164616731' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427256'
                WHERE ordernumber = 'P201023164756606' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149224'
                WHERE ordernumber = 'P201023164933660' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290965'
                WHERE ordernumber = 'P201023165306683' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427259'
                WHERE ordernumber = 'P181023165515506' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346542'
                WHERE ordernumber = 'P421023165834700' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427260'
                WHERE ordernumber = 'P181023170333727' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425983'
                WHERE ordernumber = 'P421023171503381' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427263'
                WHERE ordernumber = 'P181023171750630' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427264'
                WHERE ordernumber = 'P631023172355613' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427266'
                WHERE ordernumber = 'P201023172534820' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427267'
                WHERE ordernumber = 'P181023172857118' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427266'
                WHERE ordernumber = 'P201023172906282' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427265'
                WHERE ordernumber = 'P181023173020148' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426329'
                WHERE ordernumber = 'P201023173512532' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426329'
                WHERE ordernumber = 'P201023173728992' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427268'
                WHERE ordernumber = 'P201023174013334' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109020'
                WHERE ordernumber = 'P181023174028155' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213140'
                WHERE ordernumber = 'P771023174043654' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377991'
                WHERE ordernumber = 'P181023174330304' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427269'
                WHERE ordernumber = 'P181023174640780' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427270'
                WHERE ordernumber = 'P201023174841787' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427271'
                WHERE ordernumber = 'P181023175146976' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426957'
                WHERE ordernumber = 'P181023175426409' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427274'
                WHERE ordernumber = 'P771023180229280' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424972'
                WHERE ordernumber = 'P181023180733860' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386172'
                WHERE ordernumber = 'P181023180832775' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297429'
                WHERE ordernumber = 'P771023181331337' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309074'
                WHERE ordernumber = 'P181023181409416' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427276'
                WHERE ordernumber = 'P421023181550571' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427275'
                WHERE ordernumber = 'P771023181713812' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427277'
                WHERE ordernumber = 'P181023181946243' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '48949'
                WHERE ordernumber = 'P201023182246228' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427278'
                WHERE ordernumber = 'P181023182428498' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427276'
                WHERE ordernumber = 'P421023181550571' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427279'
                WHERE ordernumber = 'P421023182719397' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364083'
                WHERE ordernumber = 'P181023183017824' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344314'
                WHERE ordernumber = 'P421023183218870' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386043'
                WHERE ordernumber = 'P181023183649905' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427280'
                WHERE ordernumber = 'P181023183753321' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427281'
                WHERE ordernumber = 'P181023183926732' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375066'
                WHERE ordernumber = 'P201023184116759' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405875'
                WHERE ordernumber = 'P181023184536677' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P421023120623538' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427283'
                WHERE ordernumber = 'P181023185328269' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427284'
                WHERE ordernumber = 'P191023185346270' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351806'
                WHERE ordernumber = 'P201023185439918' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423183'
                WHERE ordernumber = 'P191023185515554' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427285'
                WHERE ordernumber = 'P201023185659730' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129341'
                WHERE ordernumber = 'P201023185942155' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427287'
                WHERE ordernumber = 'P191023190705126' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427288'
                WHERE ordernumber = 'P731023191718238' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291258'
                WHERE ordernumber = 'P711023192759697' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427290'
                WHERE ordernumber = 'P201023192829972' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427289'
                WHERE ordernumber = 'P631023193332556' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427291'
                WHERE ordernumber = 'P191023193544633' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403482'
                WHERE ordernumber = 'P201023193650444' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427292'
                WHERE ordernumber = 'P191023193719271' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427293'
                WHERE ordernumber = 'P191023193839890' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427294'
                WHERE ordernumber = 'P191023194247485' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427297'
                WHERE ordernumber = 'P191023195230630' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427299'
                WHERE ordernumber = 'P191023195642883' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427296'
                WHERE ordernumber = 'P771023195651335' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427296'
                WHERE ordernumber = 'P771023195651335' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292099'
                WHERE ordernumber = 'P731023201320411' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424965'
                WHERE ordernumber = 'P591023202713406' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427307'
                WHERE ordernumber = 'P711023204209596' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355309'
                WHERE ordernumber = 'P711023205604924' 
            
2024-10-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427313'
                WHERE ordernumber = 'P771023214807230'