2024-10-01 01:00:01 -- 將會員中心id寫入data-lake
2024-10-01 01:00:01 -- 
            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-30%';
        
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423660'
                WHERE ordernumber = 'P420930110112510' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '262391'
                WHERE ordernumber = 'P200930110224395' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423646'
                WHERE ordernumber = 'P190930110927660' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '172590'
                WHERE ordernumber = 'P710930111006232' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423662'
                WHERE ordernumber = 'P420930111603899' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423663'
                WHERE ordernumber = 'P420930111700320' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423664'
                WHERE ordernumber = 'P200930112043872' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423665'
                WHERE ordernumber = 'P190930112154305' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423666'
                WHERE ordernumber = 'P420930112208959' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420696'
                WHERE ordernumber = 'P180930112612450' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209768'
                WHERE ordernumber = 'P190930112809977' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423667'
                WHERE ordernumber = 'P730930112919674' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423668'
                WHERE ordernumber = 'P200930113137348' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377305'
                WHERE ordernumber = 'P200930113825580' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390753'
                WHERE ordernumber = 'P200930114131949' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411711'
                WHERE ordernumber = 'P190930114314213' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '122618'
                WHERE ordernumber = 'P180930120145172' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423672'
                WHERE ordernumber = 'P180930121110887' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423673'
                WHERE ordernumber = 'P180930121453940' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423674'
                WHERE ordernumber = 'P200930121752409' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423675'
                WHERE ordernumber = 'P420930122238266' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423676'
                WHERE ordernumber = 'P200930122304247' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423677'
                WHERE ordernumber = 'P420930122340763' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329834'
                WHERE ordernumber = 'P180930122858160' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423678'
                WHERE ordernumber = 'P200930123436135' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278659'
                WHERE ordernumber = 'P190930123552197' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423679'
                WHERE ordernumber = 'P730930123607134' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249517'
                WHERE ordernumber = 'P200930123654492' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423681'
                WHERE ordernumber = 'P190930123835447' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239316'
                WHERE ordernumber = 'P710930123840857' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423682'
                WHERE ordernumber = 'P730930124352857' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '82231'
                WHERE ordernumber = 'P200930124456521' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423684'
                WHERE ordernumber = 'P180930125337461' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390594'
                WHERE ordernumber = 'P200930125546399' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411412'
                WHERE ordernumber = 'P200930131155341' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411412'
                WHERE ordernumber = 'P200930131450171' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352417'
                WHERE ordernumber = 'P190930131811638' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423686'
                WHERE ordernumber = 'P710930132551152' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422688'
                WHERE ordernumber = 'P420930133134132' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423687'
                WHERE ordernumber = 'P730930133241240' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401492'
                WHERE ordernumber = 'P190930133302653' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118752'
                WHERE ordernumber = 'P180930134451875' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238441'
                WHERE ordernumber = 'P180930134630600' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423689'
                WHERE ordernumber = 'P180930134942229' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273611'
                WHERE ordernumber = 'P200930135553343' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423690'
                WHERE ordernumber = 'P200930135852778' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275242'
                WHERE ordernumber = 'P200930140103467' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423691'
                WHERE ordernumber = 'P420930140249264' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423691'
                WHERE ordernumber = 'P420930140705662' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423692'
                WHERE ordernumber = 'P710930141020290' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252530'
                WHERE ordernumber = 'P710930141419631' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423693'
                WHERE ordernumber = 'P200930141704150' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423693'
                WHERE ordernumber = 'P200930141737347' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423694'
                WHERE ordernumber = 'P180930142050397' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '2270'
                WHERE ordernumber = 'P420930142341959' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421658'
                WHERE ordernumber = 'P180930142423989' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394135'
                WHERE ordernumber = 'P200930142723282' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422495'
                WHERE ordernumber = 'P200930143655820' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245453'
                WHERE ordernumber = 'P420930144520334' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423697'
                WHERE ordernumber = 'P730930144535248' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423698'
                WHERE ordernumber = 'P200930144817318' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280466'
                WHERE ordernumber = 'P420930144905240' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423700'
                WHERE ordernumber = 'P710930145359433' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423701'
                WHERE ordernumber = 'P420930145449138' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274545'
                WHERE ordernumber = 'P200930145510180' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423700'
                WHERE ordernumber = 'P710930145535974' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423702'
                WHERE ordernumber = 'P200930150432843' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420249'
                WHERE ordernumber = 'P180930150720918' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423703'
                WHERE ordernumber = 'P420930150808733' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423704'
                WHERE ordernumber = 'P180930150933660' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423705'
                WHERE ordernumber = 'P420930151059578' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423706'
                WHERE ordernumber = 'P420930152200768' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423708'
                WHERE ordernumber = 'P420930152457297' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423709'
                WHERE ordernumber = 'P420930152701516' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263355'
                WHERE ordernumber = 'P190930153358748' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423710'
                WHERE ordernumber = 'P200930153423226' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423711'
                WHERE ordernumber = 'P730930153739485' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367146'
                WHERE ordernumber = 'P200930153912881' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423712'
                WHERE ordernumber = 'P200930154626754' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423714'
                WHERE ordernumber = 'P420930155015814' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423713'
                WHERE ordernumber = 'P710930155102471' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '124297'
                WHERE ordernumber = 'P190930160206255' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281932'
                WHERE ordernumber = 'P200930160618641' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399816'
                WHERE ordernumber = 'P420930160632728' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364822'
                WHERE ordernumber = 'P180930160902564' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347374'
                WHERE ordernumber = 'P190930161652827' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374299'
                WHERE ordernumber = 'P190930162051325' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237010'
                WHERE ordernumber = 'P200930163144541' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423716'
                WHERE ordernumber = 'P180930163345743' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422805'
                WHERE ordernumber = 'P200930163614764' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423720'
                WHERE ordernumber = 'P190930164734312' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403171'
                WHERE ordernumber = 'P190930164824992' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423723'
                WHERE ordernumber = 'P200930165120632' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '83448'
                WHERE ordernumber = 'P190930165142833' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423725'
                WHERE ordernumber = 'P200930165256448' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130208'
                WHERE ordernumber = 'P190930165339167' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102102'
                WHERE ordernumber = 'P190930165424732' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419643'
                WHERE ordernumber = 'P200930165838627' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368176'
                WHERE ordernumber = 'P420930165837868' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '362998'
                WHERE ordernumber = 'P200930170122313' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423727'
                WHERE ordernumber = 'P710930170138399' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423729'
                WHERE ordernumber = 'P190930170550634' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423731'
                WHERE ordernumber = 'P200930170901535' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111709'
                WHERE ordernumber = 'P180930170904584' 
            
2024-10-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371964'
                WHERE ordernumber = 'P420930170919364' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423732'
                WHERE ordernumber = 'P200930171337314' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397360'
                WHERE ordernumber = 'P180930171337139' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364407'
                WHERE ordernumber = 'P180930171815352' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423734'
                WHERE ordernumber = 'P180930172000188' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363434'
                WHERE ordernumber = 'P710930172017259' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118258'
                WHERE ordernumber = 'P180930172113942' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338267'
                WHERE ordernumber = 'P180930172202229' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413457'
                WHERE ordernumber = 'P180930172314887' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423735'
                WHERE ordernumber = 'P730930172358550' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301585'
                WHERE ordernumber = 'P190930172832535' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423738'
                WHERE ordernumber = 'P190930173106472' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287106'
                WHERE ordernumber = 'P180930173940461' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423739'
                WHERE ordernumber = 'P200930174021315' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423740'
                WHERE ordernumber = 'P180930175110726' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419796'
                WHERE ordernumber = 'P180930175300796' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420802'
                WHERE ordernumber = 'P180930180333965' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421593'
                WHERE ordernumber = 'P730930180705769' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423741'
                WHERE ordernumber = 'P180930181024988' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423742'
                WHERE ordernumber = 'P730930181051231' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423744'
                WHERE ordernumber = 'P190930181557514' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P200930181654986' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '195123'
                WHERE ordernumber = 'P180930181708842' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423747'
                WHERE ordernumber = 'P190930182534832' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423748'
                WHERE ordernumber = 'P420930182654266' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423748'
                WHERE ordernumber = 'P420930182742708' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423749'
                WHERE ordernumber = 'P730930183150976' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423750'
                WHERE ordernumber = 'P420930183203235' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423751'
                WHERE ordernumber = 'P420930183423487' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397894'
                WHERE ordernumber = 'P420930184011797' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402160'
                WHERE ordernumber = 'P420930184409809' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423752'
                WHERE ordernumber = 'P730930184832497' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342091'
                WHERE ordernumber = 'P190930185149396' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423754'
                WHERE ordernumber = 'P420930185742207' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423756'
                WHERE ordernumber = 'P730930190204529' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423758'
                WHERE ordernumber = 'P200930192046765' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423759'
                WHERE ordernumber = 'P710930192302570' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423761'
                WHERE ordernumber = 'P730930193151130' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107291'
                WHERE ordernumber = 'P190930193453889' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92425'
                WHERE ordernumber = 'P200930194012609' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423764'
                WHERE ordernumber = 'P200930194212890' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288990'
                WHERE ordernumber = 'P190930194335120' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423765'
                WHERE ordernumber = 'P200930194345235' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288990'
                WHERE ordernumber = 'P190930194744407' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423767'
                WHERE ordernumber = 'P710930195535405' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423727'
                WHERE ordernumber = 'P710930200143175' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417937'
                WHERE ordernumber = 'P190930200219425' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423769'
                WHERE ordernumber = 'P730930201846384' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211910'
                WHERE ordernumber = 'P710930202006212' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '175432'
                WHERE ordernumber = 'P710930202229329' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423770'
                WHERE ordernumber = 'P710930203308993' 
            
2024-10-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423771'
                WHERE ordernumber = 'P710930205350837'