2024-01-24 01:00:02 -- 將會員中心id寫入data-lake
2024-01-24 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-01-23%';
        
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338028'
                WHERE ordernumber = 'P420123104228140' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338028'
                WHERE ordernumber = 'P420123104329363' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101722'
                WHERE ordernumber = 'P180123110131554' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '221676'
                WHERE ordernumber = 'P180123110253576' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371267'
                WHERE ordernumber = 'P200123110551855' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371267'
                WHERE ordernumber = 'P200123110623460' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367183'
                WHERE ordernumber = 'P200123110743856' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360253'
                WHERE ordernumber = 'P180123110947595' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345881'
                WHERE ordernumber = 'P200123111839790' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360253'
                WHERE ordernumber = 'P190123111934565' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371274'
                WHERE ordernumber = 'P180123112104851' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118590'
                WHERE ordernumber = 'P190123112258984' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341458'
                WHERE ordernumber = 'P180123112332916' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328514'
                WHERE ordernumber = 'P200123112545955' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272729'
                WHERE ordernumber = 'P200123112633991' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371165'
                WHERE ordernumber = 'P180123112739670' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367380'
                WHERE ordernumber = 'P200123113407593' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '256554'
                WHERE ordernumber = 'P200123113532802' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359853'
                WHERE ordernumber = 'P180123113749567' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '362318'
                WHERE ordernumber = 'P180123113932635' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '362318'
                WHERE ordernumber = 'P180123114009885' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371278'
                WHERE ordernumber = 'P200123114612470' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371279'
                WHERE ordernumber = 'P420123114640738' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371280'
                WHERE ordernumber = 'P180123114733847' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338741'
                WHERE ordernumber = 'P180123114806113' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297233'
                WHERE ordernumber = 'P420123114816737' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367002'
                WHERE ordernumber = 'P200123114919156' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297233'
                WHERE ordernumber = 'P420123114947537' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367002'
                WHERE ordernumber = 'P200123114956291' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367002'
                WHERE ordernumber = 'P200123115036924' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357770'
                WHERE ordernumber = 'P420123115201911' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '370795'
                WHERE ordernumber = 'P200123115252367' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371286'
                WHERE ordernumber = 'P420123115903610' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355971'
                WHERE ordernumber = 'P180123120025266' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371288'
                WHERE ordernumber = 'P200123120910658' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364974'
                WHERE ordernumber = 'P180123121058509' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371086'
                WHERE ordernumber = 'P180123121156142' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371086'
                WHERE ordernumber = 'P180123121237413' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371289'
                WHERE ordernumber = 'P200123121325409' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '125988'
                WHERE ordernumber = 'P180123121405721' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371291'
                WHERE ordernumber = 'P200123121649300' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81040'
                WHERE ordernumber = 'P180123121720880' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371293'
                WHERE ordernumber = 'P420123122020547' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103849'
                WHERE ordernumber = 'P200123122320625' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269627'
                WHERE ordernumber = 'P200123122730368' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371300'
                WHERE ordernumber = 'P420123122909929' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371302'
                WHERE ordernumber = 'P420123123002533' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301891'
                WHERE ordernumber = 'P180123123512811' 
            
2024-01-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371305'
                WHERE ordernumber = 'P180123123628315' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237400'
                WHERE ordernumber = 'P200123124227671' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253817'
                WHERE ordernumber = 'P200123124324507' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162046'
                WHERE ordernumber = 'P180123124454243' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363804'
                WHERE ordernumber = 'P180123125435887' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299497'
                WHERE ordernumber = 'P420123125942460' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286180'
                WHERE ordernumber = 'P420123130012959' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299497'
                WHERE ordernumber = 'P420123130045295' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272593'
                WHERE ordernumber = 'P200123130507377' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370124'
                WHERE ordernumber = 'P420123131000910' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290206'
                WHERE ordernumber = 'P200123131121296' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367272'
                WHERE ordernumber = 'P190123131122467' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371319'
                WHERE ordernumber = 'P420123131217963' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285817'
                WHERE ordernumber = 'P190123131355235' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '204771'
                WHERE ordernumber = 'P420123131509111' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360310'
                WHERE ordernumber = 'P190123131529870' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371321'
                WHERE ordernumber = 'P420123131924962' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349891'
                WHERE ordernumber = 'P180123132820734' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340299'
                WHERE ordernumber = 'P180123133008901' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371332'
                WHERE ordernumber = 'P420123133953931' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317049'
                WHERE ordernumber = 'P200123134648552' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371336'
                WHERE ordernumber = 'P420123134927386' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371337'
                WHERE ordernumber = 'P420123135036458' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371340'
                WHERE ordernumber = 'P420123135413628' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224687'
                WHERE ordernumber = 'P200123135654291' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '37323'
                WHERE ordernumber = 'P180123135727537' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371344'
                WHERE ordernumber = 'P420123140222487' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286579'
                WHERE ordernumber = 'P200123140758875' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286579'
                WHERE ordernumber = 'P200123140928708' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371347'
                WHERE ordernumber = 'P420123141251654' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367088'
                WHERE ordernumber = 'P180123142050769' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367088'
                WHERE ordernumber = 'P180123142136486' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371357'
                WHERE ordernumber = 'P180123142221508' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368696'
                WHERE ordernumber = 'P420123142231273' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115848'
                WHERE ordernumber = 'P200123142254386' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371358'
                WHERE ordernumber = 'P190123142429428' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240231'
                WHERE ordernumber = 'P200123142611122' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338640'
                WHERE ordernumber = 'P200123143002878' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319058'
                WHERE ordernumber = 'P180123143107956' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100518'
                WHERE ordernumber = 'P190123143626532' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114594'
                WHERE ordernumber = 'P190123144418694' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123995'
                WHERE ordernumber = 'P190123144532173' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242956'
                WHERE ordernumber = 'P180123144535218' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128484'
                WHERE ordernumber = 'P180123144643527' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89771'
                WHERE ordernumber = 'P190123144644116' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336368'
                WHERE ordernumber = 'P420123144730414' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350416'
                WHERE ordernumber = 'P180123144753576' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371367'
                WHERE ordernumber = 'P200123144829431' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322543'
                WHERE ordernumber = 'P190123144834848' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349055'
                WHERE ordernumber = 'P200123144938825' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371368'
                WHERE ordernumber = 'P420123145029254' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267850'
                WHERE ordernumber = 'P200123145052274' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '51051'
                WHERE ordernumber = 'P190123145115754' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371369'
                WHERE ordernumber = 'P420123145434511' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366742'
                WHERE ordernumber = 'P190123145654568' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371373'
                WHERE ordernumber = 'P420123150216702' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371375'
                WHERE ordernumber = 'P420123150424895' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '184992'
                WHERE ordernumber = 'P420123150713735' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363891'
                WHERE ordernumber = 'P420123150937814' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '9029'
                WHERE ordernumber = 'P200123151115803' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321856'
                WHERE ordernumber = 'P420123151309687' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371379'
                WHERE ordernumber = 'P420123151516289' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236244'
                WHERE ordernumber = 'P200123151742827' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221941'
                WHERE ordernumber = 'P200123151834507' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237868'
                WHERE ordernumber = 'P180123152047943' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371380'
                WHERE ordernumber = 'P200123152100227' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95592'
                WHERE ordernumber = 'P200123152503710' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358016'
                WHERE ordernumber = 'P180123152738609' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98874'
                WHERE ordernumber = 'P190123152952889' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340295'
                WHERE ordernumber = 'P420123152954251' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90674'
                WHERE ordernumber = 'P180123153059696' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371385'
                WHERE ordernumber = 'P420123153425711' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371386'
                WHERE ordernumber = 'P180123153508919' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276826'
                WHERE ordernumber = 'P180123153819492' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115824'
                WHERE ordernumber = 'P180123154935224' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228197'
                WHERE ordernumber = 'P180123155047954' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117304'
                WHERE ordernumber = 'P200123155405585' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367604'
                WHERE ordernumber = 'P180123155408977' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115824'
                WHERE ordernumber = 'P180123155849114' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354012'
                WHERE ordernumber = 'P180123160019579' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302614'
                WHERE ordernumber = 'P200123160122711' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292038'
                WHERE ordernumber = 'P200123160219857' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371398'
                WHERE ordernumber = 'P420123160650910' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105372'
                WHERE ordernumber = 'P180123160742170' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246075'
                WHERE ordernumber = 'P180123160816641' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371403'
                WHERE ordernumber = 'P420123161032192' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279074'
                WHERE ordernumber = 'P180123161621446' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86183'
                WHERE ordernumber = 'P200123161838711' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371404'
                WHERE ordernumber = 'P420123162414852' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371406'
                WHERE ordernumber = 'P420123162757409' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368046'
                WHERE ordernumber = 'P180123163013878' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291211'
                WHERE ordernumber = 'P200123163311230' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238978'
                WHERE ordernumber = 'P180123163513847' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371409'
                WHERE ordernumber = 'P200123163747569' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371410'
                WHERE ordernumber = 'P180123164157138' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371417'
                WHERE ordernumber = 'P200123165549662' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367443'
                WHERE ordernumber = 'P200123165626428' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '87593'
                WHERE ordernumber = 'P180123165936724' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295439'
                WHERE ordernumber = 'P200123170134372' 
            
2024-01-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371420'
                WHERE ordernumber = 'P180123170242137' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253723'
                WHERE ordernumber = 'P190123170815658' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274990'
                WHERE ordernumber = 'P200123171507538' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371424'
                WHERE ordernumber = 'P180123171510525' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119390'
                WHERE ordernumber = 'P180123171622237' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138079'
                WHERE ordernumber = 'P180123171723455' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252044'
                WHERE ordernumber = 'P200123171815650' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371428'
                WHERE ordernumber = 'P200123172223825' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353532'
                WHERE ordernumber = 'P180123173052413' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371439'
                WHERE ordernumber = 'P200123173824610' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341057'
                WHERE ordernumber = 'P190123174345832' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270207'
                WHERE ordernumber = 'P200123174528192' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371444'
                WHERE ordernumber = 'P200123174849392' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371445'
                WHERE ordernumber = 'P200123175026976' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364551'
                WHERE ordernumber = 'P200123175155853' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371447'
                WHERE ordernumber = 'P200123175447220' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371453'
                WHERE ordernumber = 'P200123180229434' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371454'
                WHERE ordernumber = 'P420123180430760' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269722'
                WHERE ordernumber = 'P180123180610861' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '200067'
                WHERE ordernumber = 'P180123180638857' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371456'
                WHERE ordernumber = 'P200123180737842' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371456'
                WHERE ordernumber = 'P200123180915318' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371458'
                WHERE ordernumber = 'P200123181333598' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230083'
                WHERE ordernumber = 'P180123181421404' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230083'
                WHERE ordernumber = 'P180123181457511' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371459'
                WHERE ordernumber = 'P200123181653426' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '176708'
                WHERE ordernumber = 'P200123181810273' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367559'
                WHERE ordernumber = 'P420123182210369' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '204739'
                WHERE ordernumber = 'P200123183059899' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261976'
                WHERE ordernumber = 'P180123183237563' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371462'
                WHERE ordernumber = 'P420123183723718' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371460'
                WHERE ordernumber = 'P200123184359620' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371460'
                WHERE ordernumber = 'P200123184413287' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343345'
                WHERE ordernumber = 'P180123184821245' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301384'
                WHERE ordernumber = 'P180123185112784' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271548'
                WHERE ordernumber = 'P200123185130322' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275592'
                WHERE ordernumber = 'P200123185656181' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275592'
                WHERE ordernumber = 'P200123185758196' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371467'
                WHERE ordernumber = 'P420123185908711' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365796'
                WHERE ordernumber = 'P200123190128500' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371471'
                WHERE ordernumber = 'P420123190351318' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356799'
                WHERE ordernumber = 'P200123190459905' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262972'
                WHERE ordernumber = 'P190123190728244' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302233'
                WHERE ordernumber = 'P420123190807180' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298156'
                WHERE ordernumber = 'P200123190939527' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302554'
                WHERE ordernumber = 'P190123191007206' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347616'
                WHERE ordernumber = 'P190123191049639' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371473'
                WHERE ordernumber = 'P420123191236531' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371474'
                WHERE ordernumber = 'P190123191428140' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295512'
                WHERE ordernumber = 'P190123191721626' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371090'
                WHERE ordernumber = 'P420123191721547' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368392'
                WHERE ordernumber = 'P420123191909928' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348807'
                WHERE ordernumber = 'P200123192011755' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277863'
                WHERE ordernumber = 'P190123192413112' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371476'
                WHERE ordernumber = 'P420123192632713' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346650'
                WHERE ordernumber = 'P190123192837759' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371480'
                WHERE ordernumber = 'P420123193036743' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364749'
                WHERE ordernumber = 'P190123193059123' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360364'
                WHERE ordernumber = 'P190123193252525' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364749'
                WHERE ordernumber = 'P190123193314307' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371482'
                WHERE ordernumber = 'P200123193553872' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367726'
                WHERE ordernumber = 'P200123193729880' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232171'
                WHERE ordernumber = 'P190123193904737' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371491'
                WHERE ordernumber = 'P420123194422791' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265656'
                WHERE ordernumber = 'P200123194517506' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353717'
                WHERE ordernumber = 'P190123194533559' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226962'
                WHERE ordernumber = 'P200123194830578' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320706'
                WHERE ordernumber = 'P190123195224511' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371492'
                WHERE ordernumber = 'P200123195918453' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121795'
                WHERE ordernumber = 'P200123200036718' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371494'
                WHERE ordernumber = 'P200123200242486' 
            
2024-01-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371494'
                WHERE ordernumber = 'P200123200355235'