2024-02-27 01:00:02 -- 將會員中心id寫入data-lake
2024-02-27 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-02-26%';
        
2024-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P420226110052843' 
            
2024-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378938'
                WHERE ordernumber = 'P180226110416819' 
            
2024-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356256'
                WHERE ordernumber = 'P180226110543911' 
            
2024-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340236'
                WHERE ordernumber = 'P420226111225378' 
            
2024-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378939'
                WHERE ordernumber = 'P180226111237654' 
            
2024-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270147'
                WHERE ordernumber = 'P200226111343508' 
            
2024-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378940'
                WHERE ordernumber = 'P180226111525750' 
            
2024-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116371'
                WHERE ordernumber = 'P200226111726297' 
            
2024-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276826'
                WHERE ordernumber = 'P180226111809552' 
            
2024-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378941'
                WHERE ordernumber = 'P420226112156311' 
            
2024-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378944'
                WHERE ordernumber = 'P420226112712391' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84659'
                WHERE ordernumber = 'P180226113206224' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378947'
                WHERE ordernumber = 'P180226113427558' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378946'
                WHERE ordernumber = 'P180226113650341' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340972'
                WHERE ordernumber = 'P180226114037574' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378949'
                WHERE ordernumber = 'P200226114705343' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378950'
                WHERE ordernumber = 'P190226114724693' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378951'
                WHERE ordernumber = 'P190226114840851' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378953'
                WHERE ordernumber = 'P180226115112726' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96433'
                WHERE ordernumber = 'P180226115249198' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347214'
                WHERE ordernumber = 'P190226115321730' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281989'
                WHERE ordernumber = 'P420226115638308' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84215'
                WHERE ordernumber = 'P190226115721264' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378955'
                WHERE ordernumber = 'P200226120224497' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339631'
                WHERE ordernumber = 'P200226120326893' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420226120451262' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378956'
                WHERE ordernumber = 'P200226120641861' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235650'
                WHERE ordernumber = 'P190226121115913' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235650'
                WHERE ordernumber = 'P190226121207823' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115993'
                WHERE ordernumber = 'P190226121502671' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140470'
                WHERE ordernumber = 'P190226121558309' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378958'
                WHERE ordernumber = 'P200226121811915' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256821'
                WHERE ordernumber = 'P420226122827916' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378960'
                WHERE ordernumber = 'P200226123217267' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378961'
                WHERE ordernumber = 'P200226123543219' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378963'
                WHERE ordernumber = 'P190226124208118' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298128'
                WHERE ordernumber = 'P200226124313184' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311660'
                WHERE ordernumber = 'P190226124445777' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139258'
                WHERE ordernumber = 'P200226125020619' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341790'
                WHERE ordernumber = 'P190226125047319' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378966'
                WHERE ordernumber = 'P180226125832682' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378899'
                WHERE ordernumber = 'P190226130129149' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263731'
                WHERE ordernumber = 'P200226130251964' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236188'
                WHERE ordernumber = 'P190226130925522' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P180226132342803' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143625'
                WHERE ordernumber = 'P180226132516140' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65115'
                WHERE ordernumber = 'P200226132909245' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300621'
                WHERE ordernumber = 'P200226133654460' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378970'
                WHERE ordernumber = 'P200226133939566' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311763'
                WHERE ordernumber = 'P200226134007303' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378972'
                WHERE ordernumber = 'P420226134356171' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213209'
                WHERE ordernumber = 'P180226134401560' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273931'
                WHERE ordernumber = 'P200226135244603' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378975'
                WHERE ordernumber = 'P200226135344674' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116117'
                WHERE ordernumber = 'P190226135544818' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340551'
                WHERE ordernumber = 'P420226135631771' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249648'
                WHERE ordernumber = 'P200226135705809' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355601'
                WHERE ordernumber = 'P180226140214797' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228801'
                WHERE ordernumber = 'P180226140539679' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96762'
                WHERE ordernumber = 'P200226140625588' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241711'
                WHERE ordernumber = 'P180226142456497' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249157'
                WHERE ordernumber = 'P200226143130865' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378980'
                WHERE ordernumber = 'P190226144033749' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378981'
                WHERE ordernumber = 'P180226144042456' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352244'
                WHERE ordernumber = 'P420226144627688' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327886'
                WHERE ordernumber = 'P200226145021198' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277899'
                WHERE ordernumber = 'P200226145110126' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378984'
                WHERE ordernumber = 'P180226145346396' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378986'
                WHERE ordernumber = 'P180226145531382' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208462'
                WHERE ordernumber = 'P180226145629476' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378988'
                WHERE ordernumber = 'P200226145821412' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378989'
                WHERE ordernumber = 'P200226150110603' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378990'
                WHERE ordernumber = 'P190226150543159' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378991'
                WHERE ordernumber = 'P200226150633540' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378978'
                WHERE ordernumber = 'P190226150835116' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378978'
                WHERE ordernumber = 'P190226150919788' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378992'
                WHERE ordernumber = 'P190226151100232' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378995'
                WHERE ordernumber = 'P190226152247114' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378996'
                WHERE ordernumber = 'P190226152714305' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378997'
                WHERE ordernumber = 'P180226153740832' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315036'
                WHERE ordernumber = 'P180226153825524' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378999'
                WHERE ordernumber = 'P420226153857854' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379000'
                WHERE ordernumber = 'P180226154149665' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315758'
                WHERE ordernumber = 'P420226154314664' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P180226154331713' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329401'
                WHERE ordernumber = 'P180226154626701' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163013'
                WHERE ordernumber = 'P200226154642656' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379002'
                WHERE ordernumber = 'P180226155026263' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276437'
                WHERE ordernumber = 'P420226155042662' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274774'
                WHERE ordernumber = 'P190226155627888' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277194'
                WHERE ordernumber = 'P420226160557940' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99638'
                WHERE ordernumber = 'P180226161018774' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379004'
                WHERE ordernumber = 'P180226161520155' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379005'
                WHERE ordernumber = 'P180226161627779' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378158'
                WHERE ordernumber = 'P180226161714343' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379012'
                WHERE ordernumber = 'P420226162747977' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379013'
                WHERE ordernumber = 'P200226163011185' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149333'
                WHERE ordernumber = 'P200226163916870' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212111'
                WHERE ordernumber = 'P180226164329146' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101602'
                WHERE ordernumber = 'P180226164442596' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254176'
                WHERE ordernumber = 'P200226164804720' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378169'
                WHERE ordernumber = 'P200226172102682' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378169'
                WHERE ordernumber = 'P200226172253940' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252044'
                WHERE ordernumber = 'P200226172434874' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379015'
                WHERE ordernumber = 'P180226172624432' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310777'
                WHERE ordernumber = 'P200226172651750' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379016'
                WHERE ordernumber = 'P200226172955358' 
            
2024-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297170'
                WHERE ordernumber = 'P200226173241403' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379017'
                WHERE ordernumber = 'P180226173559828' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379018'
                WHERE ordernumber = 'P180226173808273' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257033'
                WHERE ordernumber = 'P200226173833865' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338630'
                WHERE ordernumber = 'P200226174159163' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124298'
                WHERE ordernumber = 'P200226174230877' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379019'
                WHERE ordernumber = 'P180226174236557' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289838'
                WHERE ordernumber = 'P180226174524991' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378652'
                WHERE ordernumber = 'P180226174909238' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219508'
                WHERE ordernumber = 'P180226175156908' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379020'
                WHERE ordernumber = 'P200226175416449' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379021'
                WHERE ordernumber = 'P180226175644190' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379022'
                WHERE ordernumber = 'P180226180058876' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379023'
                WHERE ordernumber = 'P420226180354935' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379024'
                WHERE ordernumber = 'P180226180535267' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379026'
                WHERE ordernumber = 'P180226180949227' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379027'
                WHERE ordernumber = 'P180226181130446' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379028'
                WHERE ordernumber = 'P180226181225987' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379029'
                WHERE ordernumber = 'P180226181413431' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269154'
                WHERE ordernumber = 'P180226182027218' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297325'
                WHERE ordernumber = 'P420226182400816' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379030'
                WHERE ordernumber = 'P190226183141933' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257521'
                WHERE ordernumber = 'P180226183231706' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379031'
                WHERE ordernumber = 'P200226183332957' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275900'
                WHERE ordernumber = 'P200226183604818' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379033'
                WHERE ordernumber = 'P200226183751155' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379034'
                WHERE ordernumber = 'P190226184133706' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379035'
                WHERE ordernumber = 'P420226184137548' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379036'
                WHERE ordernumber = 'P420226184342122' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239202'
                WHERE ordernumber = 'P190226184506644' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314722'
                WHERE ordernumber = 'P420226184513162' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375648'
                WHERE ordernumber = 'P190226185119160' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379037'
                WHERE ordernumber = 'P190226185716279' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379038'
                WHERE ordernumber = 'P200226185935761' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379039'
                WHERE ordernumber = 'P420226190435903' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379040'
                WHERE ordernumber = 'P190226190556750' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324771'
                WHERE ordernumber = 'P420226190643260' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379041'
                WHERE ordernumber = 'P190226190719154' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247109'
                WHERE ordernumber = 'P200226190741661' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379042'
                WHERE ordernumber = 'P200226191253767' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363867'
                WHERE ordernumber = 'P190226192030615' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266035'
                WHERE ordernumber = 'P200226192037322' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379043'
                WHERE ordernumber = 'P200226192806269' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335613'
                WHERE ordernumber = 'P200226193102883' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266705'
                WHERE ordernumber = 'P190226194214227' 
            
2024-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217542'
                WHERE ordernumber = 'P420226194420475'