2023-12-05 01:00:02 -- 將會員中心id寫入data-lake
2023-12-05 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 '2023-12-04%';
        
2023-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261980'
                WHERE ordernumber = 'P201204110241126' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P191204110734321' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344897'
                WHERE ordernumber = 'P181204110749333' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249054'
                WHERE ordernumber = 'P181204110921424' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350701'
                WHERE ordernumber = 'P181204111420942' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350703'
                WHERE ordernumber = 'P421204111549776' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350705'
                WHERE ordernumber = 'P191204111927112' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350706'
                WHERE ordernumber = 'P421204112033672' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350708'
                WHERE ordernumber = 'P201204112556306' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350709'
                WHERE ordernumber = 'P421204112702822' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316900'
                WHERE ordernumber = 'P181204113826972' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167632'
                WHERE ordernumber = 'P201204113921981' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139087'
                WHERE ordernumber = 'P201204114024288' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350404'
                WHERE ordernumber = 'P421204114129449' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342684'
                WHERE ordernumber = 'P201204114252756' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350712'
                WHERE ordernumber = 'P181204114430417' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328174'
                WHERE ordernumber = 'P181204114906646' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P191204114932836' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95359'
                WHERE ordernumber = 'P181204115038998' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324606'
                WHERE ordernumber = 'P201204115052483' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163435'
                WHERE ordernumber = 'P191204115057544' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350713'
                WHERE ordernumber = 'P201204115307754' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P201204115934449' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216309'
                WHERE ordernumber = 'P201204121018135' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81647'
                WHERE ordernumber = 'P181204121319406' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281239'
                WHERE ordernumber = 'P181204124006814' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330640'
                WHERE ordernumber = 'P421204124929660' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229742'
                WHERE ordernumber = 'P201204125515143' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350719'
                WHERE ordernumber = 'P181204125614494' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350720'
                WHERE ordernumber = 'P201204125740361' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350723'
                WHERE ordernumber = 'P421204125959261' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P421204130107596' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240381'
                WHERE ordernumber = 'P421204130323696' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350545'
                WHERE ordernumber = 'P421204130459539' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350725'
                WHERE ordernumber = 'P181204130747196' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350726'
                WHERE ordernumber = 'P191204131155511' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350727'
                WHERE ordernumber = 'P191204131409566' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350728'
                WHERE ordernumber = 'P191204131454972' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350730'
                WHERE ordernumber = 'P181204131947232' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '126295'
                WHERE ordernumber = 'P181204132113276' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350731'
                WHERE ordernumber = 'P181204132252434' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350733'
                WHERE ordernumber = 'P181204132349554' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350735'
                WHERE ordernumber = 'P181204132447376' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97726'
                WHERE ordernumber = 'P181204132636701' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333902'
                WHERE ordernumber = 'P201204132910160' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287040'
                WHERE ordernumber = 'P181204133031304' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293262'
                WHERE ordernumber = 'P201204133148987' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109968'
                WHERE ordernumber = 'P201204133432483' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350739'
                WHERE ordernumber = 'P181204133623545' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100515'
                WHERE ordernumber = 'P191204133849269' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350741'
                WHERE ordernumber = 'P201204133955396' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350742'
                WHERE ordernumber = 'P421204134411806' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323576'
                WHERE ordernumber = 'P201204135035910' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350744'
                WHERE ordernumber = 'P201204135155316' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350745'
                WHERE ordernumber = 'P201204140226139' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350746'
                WHERE ordernumber = 'P181204140815985' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167796'
                WHERE ordernumber = 'P181204141003631' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P181204141228236' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117014'
                WHERE ordernumber = 'P181204141311986' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240584'
                WHERE ordernumber = 'P201204141337998' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350748'
                WHERE ordernumber = 'P181204141517653' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338208'
                WHERE ordernumber = 'P181204141944600' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338208'
                WHERE ordernumber = 'P181204142037606' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P181204142132420' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162239'
                WHERE ordernumber = 'P201204142259444' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296149'
                WHERE ordernumber = 'P201204142734112' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291438'
                WHERE ordernumber = 'P201204143456714' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94856'
                WHERE ordernumber = 'P201204144753387' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346212'
                WHERE ordernumber = 'P191204145936767' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316581'
                WHERE ordernumber = 'P421204151142579' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350752'
                WHERE ordernumber = 'P191204151333528' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350753'
                WHERE ordernumber = 'P201204152038795' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350754'
                WHERE ordernumber = 'P181204153600199' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163015'
                WHERE ordernumber = 'P181204154039517' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350758'
                WHERE ordernumber = 'P201204154650575' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350759'
                WHERE ordernumber = 'P181204155035384' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116319'
                WHERE ordernumber = 'P181204155710241' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213666'
                WHERE ordernumber = 'P181204160907448' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104419'
                WHERE ordernumber = 'P181204161927759' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349480'
                WHERE ordernumber = 'P181204162353292' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104675'
                WHERE ordernumber = 'P181204162453465' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334481'
                WHERE ordernumber = 'P201204163432401' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350765'
                WHERE ordernumber = 'P421204163955999' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299907'
                WHERE ordernumber = 'P431204165035499' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350769'
                WHERE ordernumber = 'P181204165542945' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350770'
                WHERE ordernumber = 'P181204165649676' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303554'
                WHERE ordernumber = 'P181204165754218' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303554'
                WHERE ordernumber = 'P181204170032375' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289089'
                WHERE ordernumber = 'P201204170226685' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306488'
                WHERE ordernumber = 'P201204171111430' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350772'
                WHERE ordernumber = 'P421204171605850' 
            
2023-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263337'
                WHERE ordernumber = 'P201204172145309' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350776'
                WHERE ordernumber = 'P421204172605537' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340958'
                WHERE ordernumber = 'P201204173843328' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350777'
                WHERE ordernumber = 'P421204173918837' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350778'
                WHERE ordernumber = 'P181204174346958' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350778'
                WHERE ordernumber = 'P181204174639484' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350780'
                WHERE ordernumber = 'P201204175342129' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313276'
                WHERE ordernumber = 'P181204175911297' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350782'
                WHERE ordernumber = 'P181204180346747' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '72752'
                WHERE ordernumber = 'P421204180742901' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238978'
                WHERE ordernumber = 'P181204181221984' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350785'
                WHERE ordernumber = 'P421204181656670' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306378'
                WHERE ordernumber = 'P181204181955299' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306378'
                WHERE ordernumber = 'P181204182022383' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350786'
                WHERE ordernumber = 'P181204182702262' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299704'
                WHERE ordernumber = 'P421204182904480' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350792'
                WHERE ordernumber = 'P191204185925118' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275636'
                WHERE ordernumber = 'P201204190008257' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258070'
                WHERE ordernumber = 'P201204190341900' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P421204193004218' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99926'
                WHERE ordernumber = 'P191204193148136' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350794'
                WHERE ordernumber = 'P201204193352836' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346488'
                WHERE ordernumber = 'P201204194427354' 
            
2023-12-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350796'
                WHERE ordernumber = 'P421204200518843'