2024-10-22 01:00:02 -- 將會員中心id寫入data-lake
2024-10-22 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-21%';
        
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426940'
                WHERE ordernumber = 'P191021110249313' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426941'
                WHERE ordernumber = 'P201021110328573' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426942'
                WHERE ordernumber = 'P421021110747367' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426943'
                WHERE ordernumber = 'P181021110749735' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426944'
                WHERE ordernumber = 'P421021111017271' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426945'
                WHERE ordernumber = 'P181021111158240' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426946'
                WHERE ordernumber = 'P181021111529842' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412987'
                WHERE ordernumber = 'P201021111932892' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248489'
                WHERE ordernumber = 'P181021111936697' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423814'
                WHERE ordernumber = 'P421021112158823' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '91363'
                WHERE ordernumber = 'P181021112240472' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81603'
                WHERE ordernumber = 'P181021112442423' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426948'
                WHERE ordernumber = 'P421021112545481' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223478'
                WHERE ordernumber = 'P201021112614575' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426948'
                WHERE ordernumber = 'P421021112622346' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426949'
                WHERE ordernumber = 'P421021112922785' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329834'
                WHERE ordernumber = 'P181021113521608' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426951'
                WHERE ordernumber = 'P201021114519952' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426950'
                WHERE ordernumber = 'P421021114739504' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426953'
                WHERE ordernumber = 'P201021114856640' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P631021114934737' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348859'
                WHERE ordernumber = 'P181021115235952' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367901'
                WHERE ordernumber = 'P181021115501700' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426955'
                WHERE ordernumber = 'P181021115550480' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426954'
                WHERE ordernumber = 'P181021115645510' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411957'
                WHERE ordernumber = 'P181021115911483' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426956'
                WHERE ordernumber = 'P631021120009913' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341897'
                WHERE ordernumber = 'P421021120058988' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254063'
                WHERE ordernumber = 'P181021120910520' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426958'
                WHERE ordernumber = 'P181021121244738' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341897'
                WHERE ordernumber = 'P421021121245377' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181021122059408' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239058'
                WHERE ordernumber = 'P181021122514869' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73649'
                WHERE ordernumber = 'P201021123022486' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385657'
                WHERE ordernumber = 'P181021123113547' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272470'
                WHERE ordernumber = 'P201021123403589' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426960'
                WHERE ordernumber = 'P181021123932996' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405765'
                WHERE ordernumber = 'P181021124149379' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426961'
                WHERE ordernumber = 'P181021124333254' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426962'
                WHERE ordernumber = 'P181021124708562' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245867'
                WHERE ordernumber = 'P181021125019578' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384966'
                WHERE ordernumber = 'P591021125258773' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426963'
                WHERE ordernumber = 'P181021125421817' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426964'
                WHERE ordernumber = 'P181021125556993' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105981'
                WHERE ordernumber = 'P181021125801654' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346678'
                WHERE ordernumber = 'P201021125841269' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246060'
                WHERE ordernumber = 'P181021125948753' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426965'
                WHERE ordernumber = 'P181021130530892' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426966'
                WHERE ordernumber = 'P191021130545424' 
            
2024-10-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313527'
                WHERE ordernumber = 'P181021130714233' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426967'
                WHERE ordernumber = 'P181021131429172' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426967'
                WHERE ordernumber = 'P181021131520981' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426968'
                WHERE ordernumber = 'P731021131608140' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315855'
                WHERE ordernumber = 'P201021132205957' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417953'
                WHERE ordernumber = 'P421021132926556' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398923'
                WHERE ordernumber = 'P181021133505398' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309575'
                WHERE ordernumber = 'P201021134043880' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426970'
                WHERE ordernumber = 'P181021135451243' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287988'
                WHERE ordernumber = 'P201021135821799' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426971'
                WHERE ordernumber = 'P181021140438823' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P181021140542659' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249872'
                WHERE ordernumber = 'P181021140858782' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357777'
                WHERE ordernumber = 'P181021141051267' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357777'
                WHERE ordernumber = 'P181021141122221' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426975'
                WHERE ordernumber = 'P201021142210530' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426977'
                WHERE ordernumber = 'P181021142407669' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424213'
                WHERE ordernumber = 'P191021142535686' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362318'
                WHERE ordernumber = 'P181021143418541' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426978'
                WHERE ordernumber = 'P191021143809314' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426974'
                WHERE ordernumber = 'P181021143838828' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426974'
                WHERE ordernumber = 'P181021143913799' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426980'
                WHERE ordernumber = 'P191021143959316' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426976'
                WHERE ordernumber = 'P181021144043706' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426976'
                WHERE ordernumber = 'P181021144120354' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P181021144725419' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384129'
                WHERE ordernumber = 'P191021144953536' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '52369'
                WHERE ordernumber = 'P181021145009142' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106481'
                WHERE ordernumber = 'P181021145218990' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206570'
                WHERE ordernumber = 'P191021145353130' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356272'
                WHERE ordernumber = 'P201021145354851' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206570'
                WHERE ordernumber = 'P191021145600889' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '52369'
                WHERE ordernumber = 'P181021145636611' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426987'
                WHERE ordernumber = 'P201021145844683' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426984'
                WHERE ordernumber = 'P191021145932142' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426986'
                WHERE ordernumber = 'P421021145932218' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417811'
                WHERE ordernumber = 'P421021150114839' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353556'
                WHERE ordernumber = 'P201021150331278' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426988'
                WHERE ordernumber = 'P181021150522212' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426989'
                WHERE ordernumber = 'P201021150653962' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426990'
                WHERE ordernumber = 'P421021150947746' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424080'
                WHERE ordernumber = 'P421021151136205' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426992'
                WHERE ordernumber = 'P201021151210998' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426993'
                WHERE ordernumber = 'P201021151333774' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318939'
                WHERE ordernumber = 'P421021151334640' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426991'
                WHERE ordernumber = 'P771021151632142' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426994'
                WHERE ordernumber = 'P191021151647459' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426995'
                WHERE ordernumber = 'P771021153236187' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357538'
                WHERE ordernumber = 'P181021153526128' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '56425'
                WHERE ordernumber = 'P771021153537137' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426996'
                WHERE ordernumber = 'P181021154024656' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '56425'
                WHERE ordernumber = 'P771021154210139' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426997'
                WHERE ordernumber = 'P201021154213914' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426998'
                WHERE ordernumber = 'P181021154334773' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426999'
                WHERE ordernumber = 'P421021154732356' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320225'
                WHERE ordernumber = 'P181021155011917' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422102'
                WHERE ordernumber = 'P421021155452989' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391561'
                WHERE ordernumber = 'P181021160524793' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137117'
                WHERE ordernumber = 'P181021160623601' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64217'
                WHERE ordernumber = 'P771021160708799' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427003'
                WHERE ordernumber = 'P731021160825412' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427004'
                WHERE ordernumber = 'P421021160937467' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427005'
                WHERE ordernumber = 'P181021161823116' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164613'
                WHERE ordernumber = 'P181021162128997' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278599'
                WHERE ordernumber = 'P181021162352742' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427009'
                WHERE ordernumber = 'P731021163149896' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427006'
                WHERE ordernumber = 'P181021163204642' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291048'
                WHERE ordernumber = 'P421021163209416' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420013'
                WHERE ordernumber = 'P421021163238523' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427007'
                WHERE ordernumber = 'P181021163424895' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427008'
                WHERE ordernumber = 'P181021163520766' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115098'
                WHERE ordernumber = 'P201021163547125' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380695'
                WHERE ordernumber = 'P421021163717789' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423230'
                WHERE ordernumber = 'P421021163834732' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82897'
                WHERE ordernumber = 'P181021164119376' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427011'
                WHERE ordernumber = 'P201021164338658' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427012'
                WHERE ordernumber = 'P181021164823738' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427013'
                WHERE ordernumber = 'P421021165205447' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P201021165643128' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133073'
                WHERE ordernumber = 'P201021165708535' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427015'
                WHERE ordernumber = 'P181021170027833' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425838'
                WHERE ordernumber = 'P181021170829571' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427016'
                WHERE ordernumber = 'P181021171137905' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381945'
                WHERE ordernumber = 'P201021171429284' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427017'
                WHERE ordernumber = 'P181021171443986' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427018'
                WHERE ordernumber = 'P181021171644230' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219143'
                WHERE ordernumber = 'P181021171843897' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427019'
                WHERE ordernumber = 'P201021172107951' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128152'
                WHERE ordernumber = 'P181021172439729' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427020'
                WHERE ordernumber = 'P191021172648786' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310306'
                WHERE ordernumber = 'P201021172650322' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427021'
                WHERE ordernumber = 'P201021173237349' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426428'
                WHERE ordernumber = 'P201021173744927' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101638'
                WHERE ordernumber = 'P201021174102564' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427023'
                WHERE ordernumber = 'P421021174109974' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427022'
                WHERE ordernumber = 'P771021174330541' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100813'
                WHERE ordernumber = 'P201021174331356' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427024'
                WHERE ordernumber = 'P771021174606718' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427025'
                WHERE ordernumber = 'P201021174824976' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427026'
                WHERE ordernumber = 'P421021175253875' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209821'
                WHERE ordernumber = 'P181021175522967' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161095'
                WHERE ordernumber = 'P771021175537406' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427029'
                WHERE ordernumber = 'P181021175710995' 
            
2024-10-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427028'
                WHERE ordernumber = 'P771021175816348' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427027'
                WHERE ordernumber = 'P421021175928320' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427031'
                WHERE ordernumber = 'P421021180147328' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257951'
                WHERE ordernumber = 'P201021180258438' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379256'
                WHERE ordernumber = 'P181021181101538' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391928'
                WHERE ordernumber = 'P181021181408924' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286820'
                WHERE ordernumber = 'P201021181704675' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316050'
                WHERE ordernumber = 'P181021182324980' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340673'
                WHERE ordernumber = 'P201021182635285' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241066'
                WHERE ordernumber = 'P201021183230381' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337111'
                WHERE ordernumber = 'P201021183557856' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427037'
                WHERE ordernumber = 'P771021184140214' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329610'
                WHERE ordernumber = 'P421021184351887' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427038'
                WHERE ordernumber = 'P181021185437114' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230102'
                WHERE ordernumber = 'P191021185619496' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427039'
                WHERE ordernumber = 'P191021185811278' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427041'
                WHERE ordernumber = 'P731021190137211' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427043'
                WHERE ordernumber = 'P191021190403921' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427044'
                WHERE ordernumber = 'P771021191024175' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282675'
                WHERE ordernumber = 'P191021191223682' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427045'
                WHERE ordernumber = 'P711021191358611' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427046'
                WHERE ordernumber = 'P191021192000242' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282675'
                WHERE ordernumber = 'P191021192326142' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427047'
                WHERE ordernumber = 'P191021192507473' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427049'
                WHERE ordernumber = 'P731021193118894' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401268'
                WHERE ordernumber = 'P201021193428166' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427050'
                WHERE ordernumber = 'P201021193628454' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279829'
                WHERE ordernumber = 'P201021193713186' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242508'
                WHERE ordernumber = 'P201021195059568' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426398'
                WHERE ordernumber = 'P731021195913797' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426194'
                WHERE ordernumber = 'P191021200127536' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427051'
                WHERE ordernumber = 'P731021200327550' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427052'
                WHERE ordernumber = 'P711021200817376' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427051'
                WHERE ordernumber = 'P731021201053701' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206507'
                WHERE ordernumber = 'P771021203124410' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427054'
                WHERE ordernumber = 'P731021204156807' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427055'
                WHERE ordernumber = 'P771021204335939' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427056'
                WHERE ordernumber = 'P731021204343237' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427058'
                WHERE ordernumber = 'P771021210052726' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427060'
                WHERE ordernumber = 'P771021214354844' 
            
2024-10-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427063'
                WHERE ordernumber = 'P771021215313905'