2024-09-30 01:00:02 -- 將會員中心id寫入data-lake
2024-09-30 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-09-29%';
        
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392846'
                WHERE ordernumber = 'P710929104158590' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423513'
                WHERE ordernumber = 'P710929110036576' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303554'
                WHERE ordernumber = 'P180929110231912' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423514'
                WHERE ordernumber = 'P420929110351953' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306908'
                WHERE ordernumber = 'P180929110412733' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382182'
                WHERE ordernumber = 'P420929110430294' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332122'
                WHERE ordernumber = 'P180929110509441' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381574'
                WHERE ordernumber = 'P420929110513653' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278454'
                WHERE ordernumber = 'P200929110558558' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405297'
                WHERE ordernumber = 'P200929111000558' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107559'
                WHERE ordernumber = 'P180929111059604' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423515'
                WHERE ordernumber = 'P200929111413667' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367291'
                WHERE ordernumber = 'P180929111717290' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422933'
                WHERE ordernumber = 'P200929111856450' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423516'
                WHERE ordernumber = 'P180929112059224' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423517'
                WHERE ordernumber = 'P420929112510460' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423517'
                WHERE ordernumber = 'P420929112745212' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423518'
                WHERE ordernumber = 'P180929114251677' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401257'
                WHERE ordernumber = 'P180929114354929' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291414'
                WHERE ordernumber = 'P180929114549644' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397564'
                WHERE ordernumber = 'P710929114740125' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423519'
                WHERE ordernumber = 'P180929115055291' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423521'
                WHERE ordernumber = 'P710929115553461' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423522'
                WHERE ordernumber = 'P420929120456366' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354668'
                WHERE ordernumber = 'P180929121457393' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394440'
                WHERE ordernumber = 'P710929121600959' 
            
2024-09-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423523'
                WHERE ordernumber = 'P420929121653235' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423525'
                WHERE ordernumber = 'P180929121754509' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423524'
                WHERE ordernumber = 'P200929121825267' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417972'
                WHERE ordernumber = 'P200929121904837' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422629'
                WHERE ordernumber = 'P180929121909894' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397129'
                WHERE ordernumber = 'P420929122112214' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292048'
                WHERE ordernumber = 'P200929122858549' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423527'
                WHERE ordernumber = 'P710929123130550' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423528'
                WHERE ordernumber = 'P420929123653222' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423529'
                WHERE ordernumber = 'P180929123707214' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423530'
                WHERE ordernumber = 'P710929123930843' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423531'
                WHERE ordernumber = 'P180929124103349' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423532'
                WHERE ordernumber = 'P710929124622647' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227364'
                WHERE ordernumber = 'P180929125236617' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387776'
                WHERE ordernumber = 'P180929130537763' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221651'
                WHERE ordernumber = 'P200929130721841' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423534'
                WHERE ordernumber = 'P420929130904614' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404904'
                WHERE ordernumber = 'P180929130912134' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423537'
                WHERE ordernumber = 'P200929132206954' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423538'
                WHERE ordernumber = 'P200929132505574' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401441'
                WHERE ordernumber = 'P180929132650700' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341229'
                WHERE ordernumber = 'P180929132851902' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423539'
                WHERE ordernumber = 'P200929133028341' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423540'
                WHERE ordernumber = 'P180929133251464' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94028'
                WHERE ordernumber = 'P200929133443116' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423541'
                WHERE ordernumber = 'P180929133515696' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423543'
                WHERE ordernumber = 'P180929133947771' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81985'
                WHERE ordernumber = 'P630929134428299' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139071'
                WHERE ordernumber = 'P200929134553881' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423545'
                WHERE ordernumber = 'P200929134927814' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242901'
                WHERE ordernumber = 'P710929135326167' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423546'
                WHERE ordernumber = 'P710929140025534' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351864'
                WHERE ordernumber = 'P180929140038934' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423547'
                WHERE ordernumber = 'P710929141132171' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423549'
                WHERE ordernumber = 'P200929141559493' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406876'
                WHERE ordernumber = 'P200929141735304' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339203'
                WHERE ordernumber = 'P420929142608990' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292576'
                WHERE ordernumber = 'P710929142942793' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423552'
                WHERE ordernumber = 'P420929143319328' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117134'
                WHERE ordernumber = 'P710929144014629' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349797'
                WHERE ordernumber = 'P180929144132130' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423553'
                WHERE ordernumber = 'P420929144214622' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423554'
                WHERE ordernumber = 'P420929144847820' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228601'
                WHERE ordernumber = 'P200929144838189' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423554'
                WHERE ordernumber = 'P420929145403671' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241478'
                WHERE ordernumber = 'P710929150055473' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423555'
                WHERE ordernumber = 'P710929150313233' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412239'
                WHERE ordernumber = 'P180929150715641' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423556'
                WHERE ordernumber = 'P200929150730480' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423558'
                WHERE ordernumber = 'P710929151037192' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423559'
                WHERE ordernumber = 'P420929151139432' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249517'
                WHERE ordernumber = 'P200929151548702' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423561'
                WHERE ordernumber = 'P710929151557919' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423562'
                WHERE ordernumber = 'P200929151816578' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234736'
                WHERE ordernumber = 'P590929152709696' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423563'
                WHERE ordernumber = 'P420929152816783' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423563'
                WHERE ordernumber = 'P420929152909418' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369358'
                WHERE ordernumber = 'P420929152954451' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329241'
                WHERE ordernumber = 'P420929153523571' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423565'
                WHERE ordernumber = 'P730929154007976' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423566'
                WHERE ordernumber = 'P420929154154884' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329241'
                WHERE ordernumber = 'P420929154407766' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423564'
                WHERE ordernumber = 'P180929154748549' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423564'
                WHERE ordernumber = 'P180929154827347' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310001'
                WHERE ordernumber = 'P200929154901189' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323791'
                WHERE ordernumber = 'P180929154938214' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423567'
                WHERE ordernumber = 'P420929155051912' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423569'
                WHERE ordernumber = 'P710929155952430' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423570'
                WHERE ordernumber = 'P200929160059847' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423318'
                WHERE ordernumber = 'P420929160422725' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423571'
                WHERE ordernumber = 'P420929160549991' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375056'
                WHERE ordernumber = 'P420929160629386' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423572'
                WHERE ordernumber = 'P420929160729985' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381427'
                WHERE ordernumber = 'P420929160857644' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423573'
                WHERE ordernumber = 'P200929161044693' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423574'
                WHERE ordernumber = 'P200929161137515' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259483'
                WHERE ordernumber = 'P200929161406538' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163239'
                WHERE ordernumber = 'P200929161550290' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423573'
                WHERE ordernumber = 'P200929161739649' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244819'
                WHERE ordernumber = 'P200929162055600' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239270'
                WHERE ordernumber = 'P710929162127358' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423575'
                WHERE ordernumber = 'P710929162403563' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423577'
                WHERE ordernumber = 'P200929162928947' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423018'
                WHERE ordernumber = 'P200929163036426' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423578'
                WHERE ordernumber = 'P420929163208352' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328761'
                WHERE ordernumber = 'P420929163255199' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423579'
                WHERE ordernumber = 'P420929163415520' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137435'
                WHERE ordernumber = 'P200929163421736' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423580'
                WHERE ordernumber = 'P420929163559439' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423581'
                WHERE ordernumber = 'P180929163838253' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423582'
                WHERE ordernumber = 'P420929164639846' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423583'
                WHERE ordernumber = 'P200929164947211' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315071'
                WHERE ordernumber = 'P420929165605120' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304430'
                WHERE ordernumber = 'P200929165645858' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218428'
                WHERE ordernumber = 'P200929165908803' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242754'
                WHERE ordernumber = 'P180929170218956' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423586'
                WHERE ordernumber = 'P420929170330809' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385057'
                WHERE ordernumber = 'P420929170431992' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265130'
                WHERE ordernumber = 'P200929170904361' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99149'
                WHERE ordernumber = 'P180929171434172' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99149'
                WHERE ordernumber = 'P180929171502611' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146068'
                WHERE ordernumber = 'P180929171924508' 
            
2024-09-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419009'
                WHERE ordernumber = 'P200929172257671' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423589'
                WHERE ordernumber = 'P710929173130869' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423590'
                WHERE ordernumber = 'P710929173526928' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423591'
                WHERE ordernumber = 'P420929174321624' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423592'
                WHERE ordernumber = 'P420929174729308' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363806'
                WHERE ordernumber = 'P420929174901271' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114354'
                WHERE ordernumber = 'P420929175008558' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422200'
                WHERE ordernumber = 'P180929175233496' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423594'
                WHERE ordernumber = 'P420929175609585' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244822'
                WHERE ordernumber = 'P200929175656475' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423595'
                WHERE ordernumber = 'P420929180343983' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160876'
                WHERE ordernumber = 'P420929180418831' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423596'
                WHERE ordernumber = 'P200929180530378' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167291'
                WHERE ordernumber = 'P200929181309422' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423601'
                WHERE ordernumber = 'P420929182146693' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423600'
                WHERE ordernumber = 'P200929182215826' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423602'
                WHERE ordernumber = 'P420929182300574' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423604'
                WHERE ordernumber = 'P420929182734195' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247871'
                WHERE ordernumber = 'P180929182742254' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408784'
                WHERE ordernumber = 'P200929183637517' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423606'
                WHERE ordernumber = 'P710929183813591' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423607'
                WHERE ordernumber = 'P710929184149611' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423608'
                WHERE ordernumber = 'P200929185014541' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '197565'
                WHERE ordernumber = 'P710929185017695' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392009'
                WHERE ordernumber = 'P180929185139625' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278022'
                WHERE ordernumber = 'P420929185215474' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423609'
                WHERE ordernumber = 'P200929190017400' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423610'
                WHERE ordernumber = 'P200929190226893' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263528'
                WHERE ordernumber = 'P710929190954418' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423613'
                WHERE ordernumber = 'P710929191645350' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401268'
                WHERE ordernumber = 'P200929193259863' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423616'
                WHERE ordernumber = 'P710929194607506' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423617'
                WHERE ordernumber = 'P710929195049335' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423620'
                WHERE ordernumber = 'P730929200301305' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423621'
                WHERE ordernumber = 'P710929201626652' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369535'
                WHERE ordernumber = 'P710929203540435' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423622'
                WHERE ordernumber = 'P710929203938828' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423624'
                WHERE ordernumber = 'P710929210216731' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423625'
                WHERE ordernumber = 'P710929210448891' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423627'
                WHERE ordernumber = 'P710929211922947' 
            
2024-09-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423628'
                WHERE ordernumber = 'P710929213316610'