2024-05-02 01:00:02 -- 將會員中心id寫入data-lake
2024-05-02 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-05-01%';
        
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387732'
                WHERE ordernumber = 'P630501103621605' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275032'
                WHERE ordernumber = 'P630501103627818' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387733'
                WHERE ordernumber = 'P630501103902429' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387734'
                WHERE ordernumber = 'P420501103946764' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387736'
                WHERE ordernumber = 'P630501104750949' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387738'
                WHERE ordernumber = 'P630501105258175' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387739'
                WHERE ordernumber = 'P420501105729562' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '148561'
                WHERE ordernumber = 'P180501110152891' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '68119'
                WHERE ordernumber = 'P180501110333245' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127788'
                WHERE ordernumber = 'P190501110444533' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99290'
                WHERE ordernumber = 'P200501110808236' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387740'
                WHERE ordernumber = 'P630501110905246' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387741'
                WHERE ordernumber = 'P190501111031763' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387742'
                WHERE ordernumber = 'P180501111039135' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387743'
                WHERE ordernumber = 'P180501111235964' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385363'
                WHERE ordernumber = 'P420501111243183' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283299'
                WHERE ordernumber = 'P190501111304890' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216234'
                WHERE ordernumber = 'P180501111344756' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283299'
                WHERE ordernumber = 'P180501111431664' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '145854'
                WHERE ordernumber = 'P200501111557269' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387744'
                WHERE ordernumber = 'P630501112017705' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387745'
                WHERE ordernumber = 'P180501112208804' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P180501112318176' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244638'
                WHERE ordernumber = 'P180501112736539' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137065'
                WHERE ordernumber = 'P180501112923261' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384863'
                WHERE ordernumber = 'P180501113024268' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259823'
                WHERE ordernumber = 'P200501113047688' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302805'
                WHERE ordernumber = 'P420501113116427' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387746'
                WHERE ordernumber = 'P180501113439744' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276404'
                WHERE ordernumber = 'P180501113708877' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337747'
                WHERE ordernumber = 'P420501113708204' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '946'
                WHERE ordernumber = 'P180501113824697' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162040'
                WHERE ordernumber = 'P420501113955374' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387747'
                WHERE ordernumber = 'P630501114615863' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387748'
                WHERE ordernumber = 'P200501114646267' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387749'
                WHERE ordernumber = 'P180501115029528' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387750'
                WHERE ordernumber = 'P200501115112164' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '182327'
                WHERE ordernumber = 'P180501115614682' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386561'
                WHERE ordernumber = 'P420501115714737' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304578'
                WHERE ordernumber = 'P420501120049829' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387752'
                WHERE ordernumber = 'P200501120107499' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387753'
                WHERE ordernumber = 'P200501120159451' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340415'
                WHERE ordernumber = 'P200501120333940' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387754'
                WHERE ordernumber = 'P420501120412643' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290407'
                WHERE ordernumber = 'P200501120531645' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387755'
                WHERE ordernumber = 'P420501120540915' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387756'
                WHERE ordernumber = 'P180501120640693' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387757'
                WHERE ordernumber = 'P180501121333325' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P420501121913511' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387758'
                WHERE ordernumber = 'P200501122059909' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387688'
                WHERE ordernumber = 'P200501122321427' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387757'
                WHERE ordernumber = 'P180501122421454' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305425'
                WHERE ordernumber = 'P200501122723192' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222971'
                WHERE ordernumber = 'P180501122801363' 
            
2024-05-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222971'
                WHERE ordernumber = 'P180501122833966' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378270'
                WHERE ordernumber = 'P180501123223514' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294828'
                WHERE ordernumber = 'P200501123237369' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387759'
                WHERE ordernumber = 'P420501123445421' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387761'
                WHERE ordernumber = 'P420501123747584' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387763'
                WHERE ordernumber = 'P180501123803640' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387762'
                WHERE ordernumber = 'P630501123824986' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380028'
                WHERE ordernumber = 'P200501123859981' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379342'
                WHERE ordernumber = 'P420501124010167' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361861'
                WHERE ordernumber = 'P180501124812444' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128993'
                WHERE ordernumber = 'P190501124904309' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297157'
                WHERE ordernumber = 'P420501124912585' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387766'
                WHERE ordernumber = 'P420501125328684' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350013'
                WHERE ordernumber = 'P420501130446369' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366718'
                WHERE ordernumber = 'P180501130457835' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387769'
                WHERE ordernumber = 'P790501130504135' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387770'
                WHERE ordernumber = 'P180501130630149' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387771'
                WHERE ordernumber = 'P790501130703723' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350013'
                WHERE ordernumber = 'P420501130748840' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367978'
                WHERE ordernumber = 'P200501131002145' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341132'
                WHERE ordernumber = 'P180501131324250' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387774'
                WHERE ordernumber = 'P200501131720963' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386972'
                WHERE ordernumber = 'P180501132357514' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385983'
                WHERE ordernumber = 'P200501132510472' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387776'
                WHERE ordernumber = 'P180501132559221' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387775'
                WHERE ordernumber = 'P630501132726667' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65494'
                WHERE ordernumber = 'P420501133204699' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387777'
                WHERE ordernumber = 'P180501133217375' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345354'
                WHERE ordernumber = 'P630501133227853' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387778'
                WHERE ordernumber = 'P630501133322835' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387780'
                WHERE ordernumber = 'P420501133431341' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319530'
                WHERE ordernumber = 'P180501133607563' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346508'
                WHERE ordernumber = 'P200501133609289' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387781'
                WHERE ordernumber = 'P180501133738713' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330824'
                WHERE ordernumber = 'P180501133928134' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387782'
                WHERE ordernumber = 'P420501134258730' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304306'
                WHERE ordernumber = 'P190501134308563' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387783'
                WHERE ordernumber = 'P180501134345261' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228727'
                WHERE ordernumber = 'P180501134816793' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330842'
                WHERE ordernumber = 'P180501134922649' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73907'
                WHERE ordernumber = 'P180501135021493' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387784'
                WHERE ordernumber = 'P180501135254757' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349725'
                WHERE ordernumber = 'P190501135422765' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387786'
                WHERE ordernumber = 'P190501135649604' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240659'
                WHERE ordernumber = 'P200501140046914' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387787'
                WHERE ordernumber = 'P180501140149297' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387788'
                WHERE ordernumber = 'P420501140154709' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383640'
                WHERE ordernumber = 'P200501140457914' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387789'
                WHERE ordernumber = 'P420501140538983' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387790'
                WHERE ordernumber = 'P200501140653729' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387791'
                WHERE ordernumber = 'P180501140704714' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '187006'
                WHERE ordernumber = 'P200501140806506' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387792'
                WHERE ordernumber = 'P420501140808696' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385731'
                WHERE ordernumber = 'P630501140910717' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P200501141607222' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387432'
                WHERE ordernumber = 'P420501141728582' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275120'
                WHERE ordernumber = 'P630501142119800' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387794'
                WHERE ordernumber = 'P200501142238865' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385539'
                WHERE ordernumber = 'P200501142351279' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385539'
                WHERE ordernumber = 'P200501142446535' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387795'
                WHERE ordernumber = 'P790501142618884' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117708'
                WHERE ordernumber = 'P180501142913693' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387796'
                WHERE ordernumber = 'P200501142938336' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387797'
                WHERE ordernumber = 'P180501143420435' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387798'
                WHERE ordernumber = 'P200501143450666' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387799'
                WHERE ordernumber = 'P420501143642709' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235646'
                WHERE ordernumber = 'P200501143805712' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387800'
                WHERE ordernumber = 'P420501143859998' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162781'
                WHERE ordernumber = 'P420501144129866' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381203'
                WHERE ordernumber = 'P420501144225943' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387801'
                WHERE ordernumber = 'P790501144432358' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296144'
                WHERE ordernumber = 'P190501144437200' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387785'
                WHERE ordernumber = 'P180501144457928' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387785'
                WHERE ordernumber = 'P180501144524980' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387802'
                WHERE ordernumber = 'P420501144743151' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387803'
                WHERE ordernumber = 'P200501144950244' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387806'
                WHERE ordernumber = 'P420501145551421' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387807'
                WHERE ordernumber = 'P200501145727156' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387804'
                WHERE ordernumber = 'P420501145855170' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321883'
                WHERE ordernumber = 'P420501150103567' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240840'
                WHERE ordernumber = 'P180501150124986' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74302'
                WHERE ordernumber = 'P200501150314867' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320317'
                WHERE ordernumber = 'P200501150425485' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387808'
                WHERE ordernumber = 'P420501150836263' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387809'
                WHERE ordernumber = 'P420501151039466' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251223'
                WHERE ordernumber = 'P180501151157808' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387810'
                WHERE ordernumber = 'P420501151159591' 
            
2024-05-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238090'
                WHERE ordernumber = 'P190501151315619' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387811'
                WHERE ordernumber = 'P180501151426556' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387812'
                WHERE ordernumber = 'P420501151648996' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242753'
                WHERE ordernumber = 'P180501151737584' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339179'
                WHERE ordernumber = 'P420501152145982' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237209'
                WHERE ordernumber = 'P180501152317814' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256821'
                WHERE ordernumber = 'P200501152453173' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387814'
                WHERE ordernumber = 'P630501152658822' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100574'
                WHERE ordernumber = 'P200501152916996' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387815'
                WHERE ordernumber = 'P630501152939934' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363699'
                WHERE ordernumber = 'P180501153538827' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387816'
                WHERE ordernumber = 'P630501153649531' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '34454'
                WHERE ordernumber = 'P420501153715533' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387817'
                WHERE ordernumber = 'P200501153811524' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387818'
                WHERE ordernumber = 'P420501153910412' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274039'
                WHERE ordernumber = 'P420501154002364' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283272'
                WHERE ordernumber = 'P180501154352290' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224611'
                WHERE ordernumber = 'P180501154455113' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299744'
                WHERE ordernumber = 'P200501154654216' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387819'
                WHERE ordernumber = 'P200501154929539' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96406'
                WHERE ordernumber = 'P180501155137558' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372023'
                WHERE ordernumber = 'P200501155447852' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278076'
                WHERE ordernumber = 'P180501155606604' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360098'
                WHERE ordernumber = 'P180501155747283' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360098'
                WHERE ordernumber = 'P180501155833508' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110181'
                WHERE ordernumber = 'P200501155905652' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387820'
                WHERE ordernumber = 'P180501160108775' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387821'
                WHERE ordernumber = 'P200501160303459' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387822'
                WHERE ordernumber = 'P200501160645334' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371444'
                WHERE ordernumber = 'P200501161008443' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139831'
                WHERE ordernumber = 'P630501161024329' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104993'
                WHERE ordernumber = 'P420501161033694' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387823'
                WHERE ordernumber = 'P180501161056796' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93569'
                WHERE ordernumber = 'P200501161151347' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214528'
                WHERE ordernumber = 'P190501161209257' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285598'
                WHERE ordernumber = 'P180501161223272' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387824'
                WHERE ordernumber = 'P630501161410783' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384928'
                WHERE ordernumber = 'P180501161834511' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387825'
                WHERE ordernumber = 'P180501161953237' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387826'
                WHERE ordernumber = 'P420501162603579' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206434'
                WHERE ordernumber = 'P180501162802878' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387697'
                WHERE ordernumber = 'P420501163646578' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387828'
                WHERE ordernumber = 'P200501164011411' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387829'
                WHERE ordernumber = 'P180501164056150' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95310'
                WHERE ordernumber = 'P180501164342708' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387832'
                WHERE ordernumber = 'P630501164412297' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387834'
                WHERE ordernumber = 'P420501164836175' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387836'
                WHERE ordernumber = 'P180501165047941' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387837'
                WHERE ordernumber = 'P180501165154423' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387838'
                WHERE ordernumber = 'P200501165418531' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387839'
                WHERE ordernumber = 'P200501165539658' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387840'
                WHERE ordernumber = 'P200501165732201' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287227'
                WHERE ordernumber = 'P180501165828143' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387841'
                WHERE ordernumber = 'P200501170001326' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236177'
                WHERE ordernumber = 'P190501170411380' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387841'
                WHERE ordernumber = 'P200501170511900' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316340'
                WHERE ordernumber = 'P180501170956138' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387292'
                WHERE ordernumber = 'P630501171801263' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387842'
                WHERE ordernumber = 'P200501171750299' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102571'
                WHERE ordernumber = 'P180501172016819' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387843'
                WHERE ordernumber = 'P180501172204829' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250454'
                WHERE ordernumber = 'P180501172921827' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387844'
                WHERE ordernumber = 'P420501172937163' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387845'
                WHERE ordernumber = 'P630501173228757' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387847'
                WHERE ordernumber = 'P180501173705972' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89061'
                WHERE ordernumber = 'P180501173959480' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387846'
                WHERE ordernumber = 'P420501174052656' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387848'
                WHERE ordernumber = 'P630501174058755' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295010'
                WHERE ordernumber = 'P200501174608152' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86199'
                WHERE ordernumber = 'P180501174655238' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387849'
                WHERE ordernumber = 'P420501174753923' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99654'
                WHERE ordernumber = 'P200501174800393' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387850'
                WHERE ordernumber = 'P630501175540985' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380263'
                WHERE ordernumber = 'P420501175629353' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379943'
                WHERE ordernumber = 'P180501175731151' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387851'
                WHERE ordernumber = 'P200501175900229' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387852'
                WHERE ordernumber = 'P180501180014959' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387853'
                WHERE ordernumber = 'P630501180035987' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387854'
                WHERE ordernumber = 'P180501180249199' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387855'
                WHERE ordernumber = 'P180501180442450' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387856'
                WHERE ordernumber = 'P420501181012191' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163063'
                WHERE ordernumber = 'P420501181831253' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387858'
                WHERE ordernumber = 'P200501183032350' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387859'
                WHERE ordernumber = 'P180501183119179' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294892'
                WHERE ordernumber = 'P200501183128592' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341798'
                WHERE ordernumber = 'P630501183333215' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387860'
                WHERE ordernumber = 'P200501183515612' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387861'
                WHERE ordernumber = 'P190501184228982' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377540'
                WHERE ordernumber = 'P200501184431268' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387863'
                WHERE ordernumber = 'P630501184805781' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384016'
                WHERE ordernumber = 'P630501184952296' 
            
2024-05-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387864'
                WHERE ordernumber = 'P190501185436592' 
            
2024-05-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317600'
                WHERE ordernumber = 'P190501185624635' 
            
2024-05-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387865'
                WHERE ordernumber = 'P190501190010681' 
            
2024-05-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387866'
                WHERE ordernumber = 'P190501190332795' 
            
2024-05-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387867'
                WHERE ordernumber = 'P200501190359986' 
            
2024-05-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387868'
                WHERE ordernumber = 'P200501192548559' 
            
2024-05-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387869'
                WHERE ordernumber = 'P630501192722761' 
            
2024-05-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366272'
                WHERE ordernumber = 'P190501194142732' 
            
2024-05-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378057'
                WHERE ordernumber = 'P200501194154191' 
            
2024-05-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P790501205204345' 
            
2024-05-02 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387871'
                WHERE ordernumber = 'P790501205808775'