2024-10-16 01:00:01 -- 將會員中心id寫入data-lake
2024-10-16 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-10-15%';
        
2024-10-16 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '420234'
                WHERE ordernumber = 'P631015100237674' 
            
2024-10-16 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '403941'
                WHERE ordernumber = 'P201015110300902' 
            
2024-10-16 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '206583'
                WHERE ordernumber = 'P181015111241252' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425969'
                WHERE ordernumber = 'P421015111427901' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257744'
                WHERE ordernumber = 'P181015111506384' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217639'
                WHERE ordernumber = 'P181015112056948' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350706'
                WHERE ordernumber = 'P421015112204269' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398653'
                WHERE ordernumber = 'P421015112251833' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424852'
                WHERE ordernumber = 'P181015112704217' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425971'
                WHERE ordernumber = 'P181015112845478' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424852'
                WHERE ordernumber = 'P181015112956225' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425972'
                WHERE ordernumber = 'P201015113206336' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298156'
                WHERE ordernumber = 'P201015113523130' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96737'
                WHERE ordernumber = 'P201015113600959' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425973'
                WHERE ordernumber = 'P421015114028832' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425974'
                WHERE ordernumber = 'P181015114150929' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363219'
                WHERE ordernumber = 'P421015114347230' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243634'
                WHERE ordernumber = 'P181015114350331' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P201015114446158' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324722'
                WHERE ordernumber = 'P421015114834569' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425976'
                WHERE ordernumber = 'P181015114950427' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300648'
                WHERE ordernumber = 'P181015115134634' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425948'
                WHERE ordernumber = 'P181015115356855' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425978'
                WHERE ordernumber = 'P421015115742414' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425974'
                WHERE ordernumber = 'P181015115843794' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425979'
                WHERE ordernumber = 'P181015120110868' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181015120832207' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '221669'
                WHERE ordernumber = 'P201015121034779' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '64180'
                WHERE ordernumber = 'P201015121413529' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425984'
                WHERE ordernumber = 'P181015122156778' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425985'
                WHERE ordernumber = 'P181015122256735' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334304'
                WHERE ordernumber = 'P421015122345563' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '171106'
                WHERE ordernumber = 'P201015122502907' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334304'
                WHERE ordernumber = 'P421015122642478' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '265982'
                WHERE ordernumber = 'P421015122943788' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P421015123231796' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345088'
                WHERE ordernumber = 'P181015123314337' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425987'
                WHERE ordernumber = 'P201015123456730' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425986'
                WHERE ordernumber = 'P421015123614866' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396445'
                WHERE ordernumber = 'P421015123747330' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425988'
                WHERE ordernumber = 'P421015124017171' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73543'
                WHERE ordernumber = 'P421015124351994' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425989'
                WHERE ordernumber = 'P181015124731351' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423666'
                WHERE ordernumber = 'P421015125248668' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263347'
                WHERE ordernumber = 'P631015125309623' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '153677'
                WHERE ordernumber = 'P201015125503988' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425992'
                WHERE ordernumber = 'P181015125615493' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137065'
                WHERE ordernumber = 'P181015125650435' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137065'
                WHERE ordernumber = 'P181015125730337' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425994'
                WHERE ordernumber = 'P421015132436642' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425995'
                WHERE ordernumber = 'P421015132649278' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425996'
                WHERE ordernumber = 'P731015133036873' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425997'
                WHERE ordernumber = 'P421015133346467' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425998'
                WHERE ordernumber = 'P181015133736508' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106167'
                WHERE ordernumber = 'P181015133851861' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252709'
                WHERE ordernumber = 'P201015134221850' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363413'
                WHERE ordernumber = 'P181015135449961' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143188'
                WHERE ordernumber = 'P181015135741732' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282261'
                WHERE ordernumber = 'P201015140147598' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212710'
                WHERE ordernumber = 'P181015140210733' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349376'
                WHERE ordernumber = 'P421015140528426' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P201015140927783' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426000'
                WHERE ordernumber = 'P181015141210808' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308600'
                WHERE ordernumber = 'P421015142020387' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426003'
                WHERE ordernumber = 'P421015142755828' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426002'
                WHERE ordernumber = 'P181015142823469' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382194'
                WHERE ordernumber = 'P421015143147504' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405236'
                WHERE ordernumber = 'P201015143601828' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426005'
                WHERE ordernumber = 'P711015143709435' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213710'
                WHERE ordernumber = 'P731015144158433' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426007'
                WHERE ordernumber = 'P421015145730453' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426008'
                WHERE ordernumber = 'P421015145808332' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426006'
                WHERE ordernumber = 'P201015150123618' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426010'
                WHERE ordernumber = 'P421015150240734' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '203673'
                WHERE ordernumber = 'P181015150305262' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426009'
                WHERE ordernumber = 'P711015150522477' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426011'
                WHERE ordernumber = 'P201015150700128' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99638'
                WHERE ordernumber = 'P181015151442655' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P181015151817400' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421972'
                WHERE ordernumber = 'P201015152522874' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426015'
                WHERE ordernumber = 'P201015152837275' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270284'
                WHERE ordernumber = 'P201015153005489' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259340'
                WHERE ordernumber = 'P731015153301182' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426016'
                WHERE ordernumber = 'P181015153446937' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426016'
                WHERE ordernumber = 'P181015153458910' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426018'
                WHERE ordernumber = 'P181015153903566' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234843'
                WHERE ordernumber = 'P191015154430677' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426022'
                WHERE ordernumber = 'P181015154722577' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426019'
                WHERE ordernumber = 'P421015155024122' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426023'
                WHERE ordernumber = 'P201015155236355' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167614'
                WHERE ordernumber = 'P201015155407635' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426022'
                WHERE ordernumber = 'P181015155420494' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426024'
                WHERE ordernumber = 'P421015155640267' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422323'
                WHERE ordernumber = 'P191015160006769' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345359'
                WHERE ordernumber = 'P201015160713816' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426028'
                WHERE ordernumber = 'P201015160855681' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '89714'
                WHERE ordernumber = 'P181015160924878' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426030'
                WHERE ordernumber = 'P421015162356207' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213784'
                WHERE ordernumber = 'P201015162444860' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329401'
                WHERE ordernumber = 'P181015162744708' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220284'
                WHERE ordernumber = 'P181015163025797' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245454'
                WHERE ordernumber = 'P201015163840662' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398629'
                WHERE ordernumber = 'P181015164009192' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426031'
                WHERE ordernumber = 'P181015164307840' 
            
2024-10-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426032'
                WHERE ordernumber = 'P181015165351453' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426032'
                WHERE ordernumber = 'P181015165428498' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408428'
                WHERE ordernumber = 'P181015165718313' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426034'
                WHERE ordernumber = 'P201015165930336' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426033'
                WHERE ordernumber = 'P711015170202623' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400395'
                WHERE ordernumber = 'P421015170251273' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384016'
                WHERE ordernumber = 'P631015170435132' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426036'
                WHERE ordernumber = 'P711015171215429' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426037'
                WHERE ordernumber = 'P711015172625982' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103830'
                WHERE ordernumber = 'P181015172731638' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409663'
                WHERE ordernumber = 'P731015173047254' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426038'
                WHERE ordernumber = 'P181015173340806' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426020'
                WHERE ordernumber = 'P181015173537495' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371641'
                WHERE ordernumber = 'P201015174026670' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426040'
                WHERE ordernumber = 'P631015174227257' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426042'
                WHERE ordernumber = 'P201015175025299' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312112'
                WHERE ordernumber = 'P181015175512479' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241800'
                WHERE ordernumber = 'P181015180123908' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135002'
                WHERE ordernumber = 'P421015180642880' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242590'
                WHERE ordernumber = 'P201015181713918' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425409'
                WHERE ordernumber = 'P201015182045574' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408907'
                WHERE ordernumber = 'P181015182622568' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426046'
                WHERE ordernumber = 'P731015183825671' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426044'
                WHERE ordernumber = 'P181015183951194' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423349'
                WHERE ordernumber = 'P201015183953869' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426044'
                WHERE ordernumber = 'P181015184037450' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426048'
                WHERE ordernumber = 'P731015184127762' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311253'
                WHERE ordernumber = 'P201015184612318' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277054'
                WHERE ordernumber = 'P181015184625461' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426051'
                WHERE ordernumber = 'P201015184751782' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426053'
                WHERE ordernumber = 'P421015185351621' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426055'
                WHERE ordernumber = 'P201015190150154' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426056'
                WHERE ordernumber = 'P421015190430529' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209927'
                WHERE ordernumber = 'P191015193436383' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426058'
                WHERE ordernumber = 'P201015193634979' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163703'
                WHERE ordernumber = 'P191015194716482' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426060'
                WHERE ordernumber = 'P711015195806992' 
            
2024-10-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426061'
                WHERE ordernumber = 'P191015200052344'