2024-04-09 01:00:03 -- 將會員中心id寫入data-lake
2024-04-09 01:00:03 -- 
            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-04-08%';
        
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221802'
                WHERE ordernumber = 'P190408110240533' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133372'
                WHERE ordernumber = 'P200408110450852' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346949'
                WHERE ordernumber = 'P200408110552557' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210566'
                WHERE ordernumber = 'P180408111340748' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319951'
                WHERE ordernumber = 'P200408111508571' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307716'
                WHERE ordernumber = 'P200408111747305' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '713'
                WHERE ordernumber = 'P180408112318971' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384830'
                WHERE ordernumber = 'P420408113717941' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P200408114018537' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384829'
                WHERE ordernumber = 'P180408114540746' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '42884'
                WHERE ordernumber = 'P180408115014303' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94236'
                WHERE ordernumber = 'P200408115223113' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384777'
                WHERE ordernumber = 'P180408120440499' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272413'
                WHERE ordernumber = 'P180408120730909' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384834'
                WHERE ordernumber = 'P180408121831971' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384835'
                WHERE ordernumber = 'P420408123334602' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384836'
                WHERE ordernumber = 'P420408123927633' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384838'
                WHERE ordernumber = 'P420408124429365' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384839'
                WHERE ordernumber = 'P180408124544595' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384840'
                WHERE ordernumber = 'P420408124920243' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217199'
                WHERE ordernumber = 'P420408125123951' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223864'
                WHERE ordernumber = 'P200408125339784' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384841'
                WHERE ordernumber = 'P420408125742117' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '24519'
                WHERE ordernumber = 'P180408125825512' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383612'
                WHERE ordernumber = 'P180408125939431' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384842'
                WHERE ordernumber = 'P420408130117232' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384843'
                WHERE ordernumber = 'P420408130414111' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384844'
                WHERE ordernumber = 'P180408132002509' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384846'
                WHERE ordernumber = 'P180408132316511' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180408134921184' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337262'
                WHERE ordernumber = 'P420408135255243' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384851'
                WHERE ordernumber = 'P420408140329160' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180408142944581' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384852'
                WHERE ordernumber = 'P420408143732943' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311214'
                WHERE ordernumber = 'P200408144323424' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384853'
                WHERE ordernumber = 'P420408144928144' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262644'
                WHERE ordernumber = 'P420408145006959' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349376'
                WHERE ordernumber = 'P420408145829833' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384854'
                WHERE ordernumber = 'P180408150404522' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374145'
                WHERE ordernumber = 'P180408150618183' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384855'
                WHERE ordernumber = 'P420408151251410' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374145'
                WHERE ordernumber = 'P180408151308668' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305429'
                WHERE ordernumber = 'P180408151625454' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86775'
                WHERE ordernumber = 'P180408151845700' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273534'
                WHERE ordernumber = 'P200408152009477' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86775'
                WHERE ordernumber = 'P180408152059426' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382407'
                WHERE ordernumber = 'P200408152244977' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346508'
                WHERE ordernumber = 'P420408153005395' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218323'
                WHERE ordernumber = 'P180408154303410' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180408154902994' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384858'
                WHERE ordernumber = 'P190408155140449' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261374'
                WHERE ordernumber = 'P420408155402778' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384860'
                WHERE ordernumber = 'P190408155737991' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384861'
                WHERE ordernumber = 'P420408160311373' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356430'
                WHERE ordernumber = 'P180408160601675' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376247'
                WHERE ordernumber = 'P200408160605163' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236285'
                WHERE ordernumber = 'P630408160729598' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384863'
                WHERE ordernumber = 'P180408160938275' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99251'
                WHERE ordernumber = 'P200408161040685' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272753'
                WHERE ordernumber = 'P200408162214975' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384864'
                WHERE ordernumber = 'P180408162332352' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102881'
                WHERE ordernumber = 'P200408162339753' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296804'
                WHERE ordernumber = 'P200408162751488' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378446'
                WHERE ordernumber = 'P180408162808264' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280169'
                WHERE ordernumber = 'P420408162842986' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384866'
                WHERE ordernumber = 'P200408165219813' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384867'
                WHERE ordernumber = 'P200408165345858' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259286'
                WHERE ordernumber = 'P180408165730498' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167816'
                WHERE ordernumber = 'P180408165815726' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230278'
                WHERE ordernumber = 'P180408165934788' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326625'
                WHERE ordernumber = 'P190408170407632' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '196015'
                WHERE ordernumber = 'P180408170526232' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383721'
                WHERE ordernumber = 'P190408170635684' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276994'
                WHERE ordernumber = 'P180408170827267' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384870'
                WHERE ordernumber = 'P200408170843230' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349042'
                WHERE ordernumber = 'P420408170942998' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384869'
                WHERE ordernumber = 'P200408171131368' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277324'
                WHERE ordernumber = 'P200408172200484' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287464'
                WHERE ordernumber = 'P200408172703906' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384871'
                WHERE ordernumber = 'P200408173129173' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216234'
                WHERE ordernumber = 'P190408173615658' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384872'
                WHERE ordernumber = 'P200408174000961' 
            
2024-04-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216942'
                WHERE ordernumber = 'P190408174016320' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295284'
                WHERE ordernumber = 'P180408174623361' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200408174751170' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384873'
                WHERE ordernumber = 'P630408175050591' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379456'
                WHERE ordernumber = 'P180408175115969' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292257'
                WHERE ordernumber = 'P200408175235296' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350786'
                WHERE ordernumber = 'P180408175930628' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384874'
                WHERE ordernumber = 'P420408180232439' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '191005'
                WHERE ordernumber = 'P180408180616371' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304026'
                WHERE ordernumber = 'P200408180742914' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384875'
                WHERE ordernumber = 'P180408181114230' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384876'
                WHERE ordernumber = 'P200408181240244' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384877'
                WHERE ordernumber = 'P180408181908658' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384879'
                WHERE ordernumber = 'P420408182901887' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218531'
                WHERE ordernumber = 'P180408182945914' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283784'
                WHERE ordernumber = 'P200408183313814' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384881'
                WHERE ordernumber = 'P200408183917255' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384882'
                WHERE ordernumber = 'P190408184123987' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293083'
                WHERE ordernumber = 'P190408184643419' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384883'
                WHERE ordernumber = 'P190408184843495' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '126295'
                WHERE ordernumber = 'P190408185931853' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384885'
                WHERE ordernumber = 'P200408190420990' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169372'
                WHERE ordernumber = 'P190408190422221' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384886'
                WHERE ordernumber = 'P420408191633561' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384887'
                WHERE ordernumber = 'P630408191711142' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384888'
                WHERE ordernumber = 'P190408193441383' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '42059'
                WHERE ordernumber = 'P200408194241817' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '327431'
                WHERE ordernumber = 'P200408194405885' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282069'
                WHERE ordernumber = 'P190408195924856' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384894'
                WHERE ordernumber = 'P590408210658238' 
            
2024-04-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '223342'
                WHERE ordernumber = 'P630408213355505'