2024-10-30 01:00:02 -- 將會員中心id寫入data-lake
2024-10-30 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-29%';
        
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287062'
                WHERE ordernumber = 'P201029110215463' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286447'
                WHERE ordernumber = 'P201029110615464' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342213'
                WHERE ordernumber = 'P181029110656161' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428121'
                WHERE ordernumber = 'P181029111808188' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428120'
                WHERE ordernumber = 'P181029111906395' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428124'
                WHERE ordernumber = 'P421029112253347' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276908'
                WHERE ordernumber = 'P201029113414740' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428127'
                WHERE ordernumber = 'P421029114106587' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372121'
                WHERE ordernumber = 'P421029114308682' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428128'
                WHERE ordernumber = 'P421029114401520' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99933'
                WHERE ordernumber = 'P201029114441266' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310303'
                WHERE ordernumber = 'P181029114459724' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P421029114505808' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393913'
                WHERE ordernumber = 'P201029114756968' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396154'
                WHERE ordernumber = 'P201029114941321' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428130'
                WHERE ordernumber = 'P421029115359325' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398151'
                WHERE ordernumber = 'P421029115518834' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209114'
                WHERE ordernumber = 'P191029120037436' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428132'
                WHERE ordernumber = 'P421029120520581' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342844'
                WHERE ordernumber = 'P421029120732240' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428134'
                WHERE ordernumber = 'P421029120819350' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '67223'
                WHERE ordernumber = 'P201029120902309' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424510'
                WHERE ordernumber = 'P191029121131413' 
            
2024-10-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389340'
                WHERE ordernumber = 'P181029121606836' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389340'
                WHERE ordernumber = 'P181029121731761' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425896'
                WHERE ordernumber = 'P201029121822343' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428135'
                WHERE ordernumber = 'P201029122024997' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428136'
                WHERE ordernumber = 'P201029122211781' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217198'
                WHERE ordernumber = 'P181029122908147' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283781'
                WHERE ordernumber = 'P201029123033143' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380454'
                WHERE ordernumber = 'P181029123222441' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422698'
                WHERE ordernumber = 'P421029124637553' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125219'
                WHERE ordernumber = 'P201029124921637' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269816'
                WHERE ordernumber = 'P201029125735672' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281774'
                WHERE ordernumber = 'P201029125907471' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298628'
                WHERE ordernumber = 'P201029130329609' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130793'
                WHERE ordernumber = 'P181029130632660' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428140'
                WHERE ordernumber = 'P201029130715229' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426588'
                WHERE ordernumber = 'P201029131025242' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339868'
                WHERE ordernumber = 'P421029131533242' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P181029131639658' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291214'
                WHERE ordernumber = 'P181029132656310' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428146'
                WHERE ordernumber = 'P421029132957328' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428142'
                WHERE ordernumber = 'P711029133003152' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428143'
                WHERE ordernumber = 'P421029133202372' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100531'
                WHERE ordernumber = 'P201029133549744' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428149'
                WHERE ordernumber = 'P181029134350511' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428151'
                WHERE ordernumber = 'P201029134749142' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163217'
                WHERE ordernumber = 'P421029135216864' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213792'
                WHERE ordernumber = 'P421029135322760' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181029135322426' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218323'
                WHERE ordernumber = 'P181029135938553' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428153'
                WHERE ordernumber = 'P181029140105420' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281509'
                WHERE ordernumber = 'P201029140431134' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428156'
                WHERE ordernumber = 'P181029140948974' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428155'
                WHERE ordernumber = 'P421029141029731' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '29930'
                WHERE ordernumber = 'P201029141637235' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401675'
                WHERE ordernumber = 'P201029141725667' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286447'
                WHERE ordernumber = 'P201029141808462' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428159'
                WHERE ordernumber = 'P421029142159439' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428158'
                WHERE ordernumber = 'P421029143246494' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291133'
                WHERE ordernumber = 'P421029144347819' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395572'
                WHERE ordernumber = 'P421029144951566' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229781'
                WHERE ordernumber = 'P201029145912462' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428162'
                WHERE ordernumber = 'P201029150225640' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428166'
                WHERE ordernumber = 'P201029150955172' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428169'
                WHERE ordernumber = 'P421029151627561' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406754'
                WHERE ordernumber = 'P421029151826768' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384033'
                WHERE ordernumber = 'P181029152036986' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427092'
                WHERE ordernumber = 'P201029152607835' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428172'
                WHERE ordernumber = 'P421029153102869' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118178'
                WHERE ordernumber = 'P181029153221790' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428173'
                WHERE ordernumber = 'P201029153459585' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241976'
                WHERE ordernumber = 'P181029154306934' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337355'
                WHERE ordernumber = 'P771029154721350' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250051'
                WHERE ordernumber = 'P181029154857506' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428174'
                WHERE ordernumber = 'P201029155546160' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428176'
                WHERE ordernumber = 'P421029160214704' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '170686'
                WHERE ordernumber = 'P201029160423833' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181029160633383' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428178'
                WHERE ordernumber = 'P731029161038213' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '195588'
                WHERE ordernumber = 'P181029161147832' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428179'
                WHERE ordernumber = 'P421029161451367' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336794'
                WHERE ordernumber = 'P421029161548458' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428177'
                WHERE ordernumber = 'P181029161759115' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428180'
                WHERE ordernumber = 'P421029162100765' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316668'
                WHERE ordernumber = 'P421029162129580' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428182'
                WHERE ordernumber = 'P181029162611918' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302505'
                WHERE ordernumber = 'P181029163105336' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428183'
                WHERE ordernumber = 'P201029163804218' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387668'
                WHERE ordernumber = 'P181029164328359' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427039'
                WHERE ordernumber = 'P181029164944509' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428186'
                WHERE ordernumber = 'P201029165137445' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428118'
                WHERE ordernumber = 'P421029165307873' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428185'
                WHERE ordernumber = 'P181029165342810' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428118'
                WHERE ordernumber = 'P421029165343179' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368818'
                WHERE ordernumber = 'P421029170003862' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428187'
                WHERE ordernumber = 'P591029170607629' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339666'
                WHERE ordernumber = 'P421029171143192' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393452'
                WHERE ordernumber = 'P201029171516153' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311531'
                WHERE ordernumber = 'P181029171531236' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405993'
                WHERE ordernumber = 'P421029172135521' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102595'
                WHERE ordernumber = 'P201029172526326' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428188'
                WHERE ordernumber = 'P181029173310441' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282087'
                WHERE ordernumber = 'P191029173419633' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428191'
                WHERE ordernumber = 'P421029173515716' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428189'
                WHERE ordernumber = 'P421029173531507' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428194'
                WHERE ordernumber = 'P181029174613297' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332133'
                WHERE ordernumber = 'P201029175002334' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428196'
                WHERE ordernumber = 'P201029175401778' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302058'
                WHERE ordernumber = 'P771029175454565' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424210'
                WHERE ordernumber = 'P181029181017609' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400421'
                WHERE ordernumber = 'P201029181148604' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94993'
                WHERE ordernumber = 'P201029181330441' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400422'
                WHERE ordernumber = 'P201029181454789' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428198'
                WHERE ordernumber = 'P201029182044192' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428199'
                WHERE ordernumber = 'P421029182611235' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104188'
                WHERE ordernumber = 'P181029182638179' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428200'
                WHERE ordernumber = 'P421029182653443' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428202'
                WHERE ordernumber = 'P201029183925911' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428203'
                WHERE ordernumber = 'P201029184528358' 
            
2024-10-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428204'
                WHERE ordernumber = 'P201029184708825' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428203'
                WHERE ordernumber = 'P201029184953521' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278718'
                WHERE ordernumber = 'P201029185632713' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428205'
                WHERE ordernumber = 'P191029190429634' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425931'
                WHERE ordernumber = 'P201029190637729' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340119'
                WHERE ordernumber = 'P201029190805566' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300681'
                WHERE ordernumber = 'P201029190940856' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306896'
                WHERE ordernumber = 'P191029191015485' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428207'
                WHERE ordernumber = 'P731029191313210' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428208'
                WHERE ordernumber = 'P201029191438189' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428210'
                WHERE ordernumber = 'P201029193151388' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371641'
                WHERE ordernumber = 'P201029194303397' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319481'
                WHERE ordernumber = 'P201029195404507' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '29129'
                WHERE ordernumber = 'P771029204653258' 
            
2024-10-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428214'
                WHERE ordernumber = 'P771029214548821'