2024-10-23 01:00:02 -- 將會員中心id寫入data-lake
2024-10-23 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-10-22%';
        
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384129'
                WHERE ordernumber = 'P181022110241291' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368655'
                WHERE ordernumber = 'P181022110305847' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345751'
                WHERE ordernumber = 'P421022110345226' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424740'
                WHERE ordernumber = 'P421022110444606' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308636'
                WHERE ordernumber = 'P631022110455393' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427083'
                WHERE ordernumber = 'P181022110644236' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246075'
                WHERE ordernumber = 'P181022110854993' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427084'
                WHERE ordernumber = 'P421022110911347' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236243'
                WHERE ordernumber = 'P201022110947346' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '330295'
                WHERE ordernumber = 'P421022111010499' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427081'
                WHERE ordernumber = 'P201022111242477' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427086'
                WHERE ordernumber = 'P181022111251504' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427085'
                WHERE ordernumber = 'P421022111442794' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420138'
                WHERE ordernumber = 'P421022111624259' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427087'
                WHERE ordernumber = 'P591022112839630' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '122686'
                WHERE ordernumber = 'P191022113522316' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316185'
                WHERE ordernumber = 'P421022114403788' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427079'
                WHERE ordernumber = 'P181022114412650' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426003'
                WHERE ordernumber = 'P421022115203134' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220538'
                WHERE ordernumber = 'P421022115659705' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427089'
                WHERE ordernumber = 'P421022115957922' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104726'
                WHERE ordernumber = 'P421022120149582' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427090'
                WHERE ordernumber = 'P771022120404141' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181022122028119' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270284'
                WHERE ordernumber = 'P201022122450793' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P421022123551951' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427092'
                WHERE ordernumber = 'P201022123820771' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427093'
                WHERE ordernumber = 'P181022124951920' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371641'
                WHERE ordernumber = 'P201022125003547' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286388'
                WHERE ordernumber = 'P201022125255919' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310339'
                WHERE ordernumber = 'P201022130045133' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427094'
                WHERE ordernumber = 'P201022130126418' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427096'
                WHERE ordernumber = 'P201022131252967' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427098'
                WHERE ordernumber = 'P421022131808283' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236963'
                WHERE ordernumber = 'P201022131840258' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427097'
                WHERE ordernumber = 'P421022131922325' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102799'
                WHERE ordernumber = 'P181022131924668' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236963'
                WHERE ordernumber = 'P201022132050549' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385640'
                WHERE ordernumber = 'P421022132113310' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297211'
                WHERE ordernumber = 'P201022132145989' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427099'
                WHERE ordernumber = 'P181022132151949' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251457'
                WHERE ordernumber = 'P201022132245996' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427100'
                WHERE ordernumber = 'P421022132605550' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427102'
                WHERE ordernumber = 'P181022132733505' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386982'
                WHERE ordernumber = 'P421022132904376' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427103'
                WHERE ordernumber = 'P201022133029731' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425484'
                WHERE ordernumber = 'P201022133315758' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422709'
                WHERE ordernumber = 'P711022133651677' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427104'
                WHERE ordernumber = 'P421022133932268' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286251'
                WHERE ordernumber = 'P201022134557260' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '148666'
                WHERE ordernumber = 'P181022134718673' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '160775'
                WHERE ordernumber = 'P771022135123784' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80681'
                WHERE ordernumber = 'P181022135500368' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427106'
                WHERE ordernumber = 'P421022140650134' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427108'
                WHERE ordernumber = 'P201022142127976' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236726'
                WHERE ordernumber = 'P201022142636942' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427109'
                WHERE ordernumber = 'P771022143025619' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426082'
                WHERE ordernumber = 'P181022143507574' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427110'
                WHERE ordernumber = 'P201022143536545' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420454'
                WHERE ordernumber = 'P201022143844178' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427112'
                WHERE ordernumber = 'P201022144241953' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '78770'
                WHERE ordernumber = 'P771022144718359' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384284'
                WHERE ordernumber = 'P771022145038329' 
            
2024-10-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303390'
                WHERE ordernumber = 'P421022145502137' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421768'
                WHERE ordernumber = 'P731022145525486' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427113'
                WHERE ordernumber = 'P201022145640651' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424530'
                WHERE ordernumber = 'P421022150000695' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412987'
                WHERE ordernumber = 'P201022150153607' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427114'
                WHERE ordernumber = 'P201022150316997' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313336'
                WHERE ordernumber = 'P181022150759340' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384284'
                WHERE ordernumber = 'P771022150815600' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238570'
                WHERE ordernumber = 'P201022150843636' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257880'
                WHERE ordernumber = 'P201022151043121' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238570'
                WHERE ordernumber = 'P201022151256398' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427115'
                WHERE ordernumber = 'P201022152312504' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362318'
                WHERE ordernumber = 'P181022152517507' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422669'
                WHERE ordernumber = 'P201022152858327' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427116'
                WHERE ordernumber = 'P201022153002227' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119011'
                WHERE ordernumber = 'P711022153101654' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409228'
                WHERE ordernumber = 'P421022153115491' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427120'
                WHERE ordernumber = 'P201022154000893' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427122'
                WHERE ordernumber = 'P201022154847274' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352165'
                WHERE ordernumber = 'P181022155954867' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427125'
                WHERE ordernumber = 'P201022160916822' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427126'
                WHERE ordernumber = 'P421022161611358' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380886'
                WHERE ordernumber = 'P181022161738287' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342558'
                WHERE ordernumber = 'P181022163115244' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427128'
                WHERE ordernumber = 'P201022163822173' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102656'
                WHERE ordernumber = 'P181022163833610' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P181022164029975' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252036'
                WHERE ordernumber = 'P631022165001261' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420128'
                WHERE ordernumber = 'P421022170421171' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387912'
                WHERE ordernumber = 'P201022170743678' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281828'
                WHERE ordernumber = 'P181022171331601' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427129'
                WHERE ordernumber = 'P771022171429661' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408775'
                WHERE ordernumber = 'P181022171630701' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427130'
                WHERE ordernumber = 'P771022171944283' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427129'
                WHERE ordernumber = 'P771022172115445' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P421022172616524' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426918'
                WHERE ordernumber = 'P181022172826953' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399717'
                WHERE ordernumber = 'P421022173130116' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98694'
                WHERE ordernumber = 'P421022173821805' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427132'
                WHERE ordernumber = 'P421022174858137' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415215'
                WHERE ordernumber = 'P201022175901373' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427136'
                WHERE ordernumber = 'P201022180313908' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426665'
                WHERE ordernumber = 'P421022180355990' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427137'
                WHERE ordernumber = 'P201022180418547' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422379'
                WHERE ordernumber = 'P421022180545840' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354769'
                WHERE ordernumber = 'P421022181056211' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427138'
                WHERE ordernumber = 'P421022181622603' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385168'
                WHERE ordernumber = 'P201022181807181' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427139'
                WHERE ordernumber = 'P181022181852940' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385895'
                WHERE ordernumber = 'P181022182249218' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427140'
                WHERE ordernumber = 'P771022182513177' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427140'
                WHERE ordernumber = 'P771022182513177' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427141'
                WHERE ordernumber = 'P201022182618166' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427142'
                WHERE ordernumber = 'P181022182900803' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427142'
                WHERE ordernumber = 'P181022182952588' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276593'
                WHERE ordernumber = 'P181022183209229' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343834'
                WHERE ordernumber = 'P201022183528842' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427146'
                WHERE ordernumber = 'P201022184327954' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427145'
                WHERE ordernumber = 'P771022184547383' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427148'
                WHERE ordernumber = 'P201022184639632' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P181022185015929' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427150'
                WHERE ordernumber = 'P771022185041282' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284409'
                WHERE ordernumber = 'P181022185231421' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97253'
                WHERE ordernumber = 'P191022185539612' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137334'
                WHERE ordernumber = 'P201022185627328' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165635'
                WHERE ordernumber = 'P191022185857369' 
            
2024-10-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291344'
                WHERE ordernumber = 'P771022190355732'