2024-02-26 01:00:02 -- 將會員中心id寫入data-lake
2024-02-26 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-25%';
        
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '165370'
                WHERE ordernumber = 'P420225103910156' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378825'
                WHERE ordernumber = 'P190225110412401' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377786'
                WHERE ordernumber = 'P200225110622605' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107927'
                WHERE ordernumber = 'P200225111003715' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102133'
                WHERE ordernumber = 'P180225111031450' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '189760'
                WHERE ordernumber = 'P420225112417300' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164500'
                WHERE ordernumber = 'P180225112647424' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378830'
                WHERE ordernumber = 'P200225112743626' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278151'
                WHERE ordernumber = 'P200225113409980' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '77463'
                WHERE ordernumber = 'P200225113603492' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '77463'
                WHERE ordernumber = 'P200225113749119' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378831'
                WHERE ordernumber = 'P180225113849184' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377159'
                WHERE ordernumber = 'P180225114508772' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378832'
                WHERE ordernumber = 'P200225114551733' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '267420'
                WHERE ordernumber = 'P200225115109409' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81989'
                WHERE ordernumber = 'P180225120243486' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378833'
                WHERE ordernumber = 'P420225120455850' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '157035'
                WHERE ordernumber = 'P200225120856254' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377242'
                WHERE ordernumber = 'P200225121225251' 
            
2024-02-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269862'
                WHERE ordernumber = 'P200225121337194' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '5781'
                WHERE ordernumber = 'P200225121612959' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132578'
                WHERE ordernumber = 'P180225122232134' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378834'
                WHERE ordernumber = 'P200225122945440' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378836'
                WHERE ordernumber = 'P420225123534363' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243170'
                WHERE ordernumber = 'P180225123905117' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146430'
                WHERE ordernumber = 'P200225124040747' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337886'
                WHERE ordernumber = 'P200225125352202' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298945'
                WHERE ordernumber = 'P420225125536660' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355105'
                WHERE ordernumber = 'P180225130001157' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378840'
                WHERE ordernumber = 'P200225131130420' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301307'
                WHERE ordernumber = 'P180225131558763' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377353'
                WHERE ordernumber = 'P420225131859326' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P200225132051414' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301307'
                WHERE ordernumber = 'P180225132109678' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378842'
                WHERE ordernumber = 'P420225132200370' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378843'
                WHERE ordernumber = 'P420225132438346' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378839'
                WHERE ordernumber = 'P180225132847546' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308018'
                WHERE ordernumber = 'P180225133311357' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276908'
                WHERE ordernumber = 'P200225133515322' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364367'
                WHERE ordernumber = 'P420225133518798' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259850'
                WHERE ordernumber = 'P180225133633114' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118883'
                WHERE ordernumber = 'P180225133908158' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346508'
                WHERE ordernumber = 'P200225134056193' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371977'
                WHERE ordernumber = 'P200225134231290' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262496'
                WHERE ordernumber = 'P200225134340148' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378844'
                WHERE ordernumber = 'P200225135023888' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378845'
                WHERE ordernumber = 'P180225135235344' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378846'
                WHERE ordernumber = 'P420225135348507' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284766'
                WHERE ordernumber = 'P180225135847437' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163285'
                WHERE ordernumber = 'P200225140231452' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378848'
                WHERE ordernumber = 'P200225140352347' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256346'
                WHERE ordernumber = 'P180225140849606' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138207'
                WHERE ordernumber = 'P180225141137479' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375111'
                WHERE ordernumber = 'P180225142026718' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128338'
                WHERE ordernumber = 'P180225142458998' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378851'
                WHERE ordernumber = 'P200225142848784' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342311'
                WHERE ordernumber = 'P180225143112782' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270378'
                WHERE ordernumber = 'P200225143316266' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235431'
                WHERE ordernumber = 'P200225144216378' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378853'
                WHERE ordernumber = 'P180225144833556' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378651'
                WHERE ordernumber = 'P180225145731322' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355415'
                WHERE ordernumber = 'P420225150050443' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378849'
                WHERE ordernumber = 'P180225150614915' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378849'
                WHERE ordernumber = 'P180225150632615' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378206'
                WHERE ordernumber = 'P200225150952367' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356635'
                WHERE ordernumber = 'P420225151358835' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378857'
                WHERE ordernumber = 'P420225151733699' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378859'
                WHERE ordernumber = 'P420225151910550' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366606'
                WHERE ordernumber = 'P180225152207425' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300855'
                WHERE ordernumber = 'P200225152252160' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378860'
                WHERE ordernumber = 'P420225152420624' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378608'
                WHERE ordernumber = 'P180225152451438' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208071'
                WHERE ordernumber = 'P190225152835130' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66178'
                WHERE ordernumber = 'P200225153427866' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309303'
                WHERE ordernumber = 'P180225153748766' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378861'
                WHERE ordernumber = 'P420225153937714' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378862'
                WHERE ordernumber = 'P200225154700397' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378863'
                WHERE ordernumber = 'P420225160409233' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367697'
                WHERE ordernumber = 'P200225160453684' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378635'
                WHERE ordernumber = 'P200225161727699' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171633'
                WHERE ordernumber = 'P200225162010427' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378865'
                WHERE ordernumber = 'P420225162019861' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235498'
                WHERE ordernumber = 'P200225162055554' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367630'
                WHERE ordernumber = 'P420225163640477' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378871'
                WHERE ordernumber = 'P200225164204604' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116366'
                WHERE ordernumber = 'P200225164535779' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378872'
                WHERE ordernumber = 'P420225164630598' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378873'
                WHERE ordernumber = 'P200225164937484' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378876'
                WHERE ordernumber = 'P420225165230531' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302655'
                WHERE ordernumber = 'P420225165315585' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378878'
                WHERE ordernumber = 'P420225165955343' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207972'
                WHERE ordernumber = 'P420225170627328' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378880'
                WHERE ordernumber = 'P420225170724592' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307718'
                WHERE ordernumber = 'P200225171542777' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378879'
                WHERE ordernumber = 'P180225171916822' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294793'
                WHERE ordernumber = 'P200225172212865' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98478'
                WHERE ordernumber = 'P200225172418857' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343258'
                WHERE ordernumber = 'P180225172458329' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378882'
                WHERE ordernumber = 'P420225172540710' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357018'
                WHERE ordernumber = 'P180225172656531' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378884'
                WHERE ordernumber = 'P420225172737550' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378885'
                WHERE ordernumber = 'P420225172915179' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378886'
                WHERE ordernumber = 'P420225173028572' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378887'
                WHERE ordernumber = 'P420225173154383' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378888'
                WHERE ordernumber = 'P420225173257509' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168425'
                WHERE ordernumber = 'P420225173450727' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307592'
                WHERE ordernumber = 'P180225173659911' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378867'
                WHERE ordernumber = 'P180225173856821' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378867'
                WHERE ordernumber = 'P180225173933480' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378889'
                WHERE ordernumber = 'P200225174022483' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378890'
                WHERE ordernumber = 'P420225174202722' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378891'
                WHERE ordernumber = 'P200225174424568' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378241'
                WHERE ordernumber = 'P180225174848277' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378892'
                WHERE ordernumber = 'P180225175038399' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350031'
                WHERE ordernumber = 'P180225175313997' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378893'
                WHERE ordernumber = 'P180225175555359' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378894'
                WHERE ordernumber = 'P420225175710226' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378895'
                WHERE ordernumber = 'P180225175907874' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378895'
                WHERE ordernumber = 'P180225175951181' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378896'
                WHERE ordernumber = 'P420225181305951' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209842'
                WHERE ordernumber = 'P180225181943953' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362038'
                WHERE ordernumber = 'P200225183654816' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378900'
                WHERE ordernumber = 'P190225184709522' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94627'
                WHERE ordernumber = 'P420225184926966' 
            
2024-02-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378901'
                WHERE ordernumber = 'P420225192339658'