2024-10-09 01:00:01 -- 將會員中心id寫入data-lake
2024-10-09 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-08%';
        
2024-10-09 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '258194'
                WHERE ordernumber = 'P201008110533772' 
            
2024-10-09 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P201008110658997' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274905'
                WHERE ordernumber = 'P201008110839538' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424723'
                WHERE ordernumber = 'P201008111429564' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364080'
                WHERE ordernumber = 'P421008111828262' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424724'
                WHERE ordernumber = 'P421008112127546' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424725'
                WHERE ordernumber = 'P201008112507441' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304674'
                WHERE ordernumber = 'P201008112559787' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424726'
                WHERE ordernumber = 'P201008112928746' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392795'
                WHERE ordernumber = 'P181008113502347' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424729'
                WHERE ordernumber = 'P201008114030796' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314514'
                WHERE ordernumber = 'P181008114202690' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424727'
                WHERE ordernumber = 'P181008114359586' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424615'
                WHERE ordernumber = 'P181008114614247' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216260'
                WHERE ordernumber = 'P181008115919970' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424730'
                WHERE ordernumber = 'P731008120345460' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424731'
                WHERE ordernumber = 'P181008120528494' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342844'
                WHERE ordernumber = 'P421008120944811' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424732'
                WHERE ordernumber = 'P181008121741425' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271802'
                WHERE ordernumber = 'P201008121825352' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271802'
                WHERE ordernumber = 'P201008121921230' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424734'
                WHERE ordernumber = 'P181008122913459' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297135'
                WHERE ordernumber = 'P421008124113641' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419320'
                WHERE ordernumber = 'P181008124649810' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424737'
                WHERE ordernumber = 'P181008124952559' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424739'
                WHERE ordernumber = 'P181008125136146' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424742'
                WHERE ordernumber = 'P181008125323944' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424740'
                WHERE ordernumber = 'P421008125339340' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381308'
                WHERE ordernumber = 'P181008125920452' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381308'
                WHERE ordernumber = 'P181008130018189' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314528'
                WHERE ordernumber = 'P181008131433175' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424745'
                WHERE ordernumber = 'P201008131927493' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385796'
                WHERE ordernumber = 'P181008131940738' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376220'
                WHERE ordernumber = 'P631008133353137' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P421008133406554' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424747'
                WHERE ordernumber = 'P631008133717446' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424750'
                WHERE ordernumber = 'P201008134002819' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340190'
                WHERE ordernumber = 'P181008134114620' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301524'
                WHERE ordernumber = 'P421008134142692' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '141695'
                WHERE ordernumber = 'P631008134408893' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372425'
                WHERE ordernumber = 'P201008134415572' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424700'
                WHERE ordernumber = 'P181008134944356' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424749'
                WHERE ordernumber = 'P181008135057703' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424752'
                WHERE ordernumber = 'P181008135252667' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424754'
                WHERE ordernumber = 'P421008135318995' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424753'
                WHERE ordernumber = 'P181008135333379' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340190'
                WHERE ordernumber = 'P181008135525589' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424752'
                WHERE ordernumber = 'P181008135653449' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424751'
                WHERE ordernumber = 'P181008135803849' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290965'
                WHERE ordernumber = 'P201008135845899' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422502'
                WHERE ordernumber = 'P711008142444478' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390391'
                WHERE ordernumber = 'P631008142508822' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236420'
                WHERE ordernumber = 'P201008142732350' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329786'
                WHERE ordernumber = 'P421008142745856' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424761'
                WHERE ordernumber = 'P181008142859183' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273534'
                WHERE ordernumber = 'P201008143000198' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424760'
                WHERE ordernumber = 'P421008143003317' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P181008143017919' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P181008143101845' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424764'
                WHERE ordernumber = 'P181008143506787' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421558'
                WHERE ordernumber = 'P711008143739701' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424765'
                WHERE ordernumber = 'P181008143836633' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403634'
                WHERE ordernumber = 'P421008144216324' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424766'
                WHERE ordernumber = 'P731008144345770' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421408'
                WHERE ordernumber = 'P421008144409261' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424768'
                WHERE ordernumber = 'P201008144432368' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424769'
                WHERE ordernumber = 'P181008145018459' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424768'
                WHERE ordernumber = 'P201008145237569' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424771'
                WHERE ordernumber = 'P201008145538787' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P181008150112742' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424770'
                WHERE ordernumber = 'P731008150207304' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387308'
                WHERE ordernumber = 'P181008150653850' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424773'
                WHERE ordernumber = 'P421008151522893' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422213'
                WHERE ordernumber = 'P711008151546252' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P201008151634466' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424774'
                WHERE ordernumber = 'P731008152413925' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424775'
                WHERE ordernumber = 'P201008152451726' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424775'
                WHERE ordernumber = 'P201008152629604' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424776'
                WHERE ordernumber = 'P711008152825585' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424779'
                WHERE ordernumber = 'P201008153230647' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342626'
                WHERE ordernumber = 'P181008153458498' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424781'
                WHERE ordernumber = 'P731008155230416' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241465'
                WHERE ordernumber = 'P181008155354201' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391170'
                WHERE ordernumber = 'P181008160221505' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311842'
                WHERE ordernumber = 'P421008161343619' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424784'
                WHERE ordernumber = 'P731008162307361' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '361044'
                WHERE ordernumber = 'P201008162457631' 
            
2024-10-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '361044'
                WHERE ordernumber = 'P201008162555960' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270284'
                WHERE ordernumber = 'P201008162831624' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424786'
                WHERE ordernumber = 'P201008164000369' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278745'
                WHERE ordernumber = 'P201008164123369' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424788'
                WHERE ordernumber = 'P201008164640210' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240942'
                WHERE ordernumber = 'P201008170031754' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381648'
                WHERE ordernumber = 'P181008170915896' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424791'
                WHERE ordernumber = 'P201008171417260' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97047'
                WHERE ordernumber = 'P421008171426297' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107770'
                WHERE ordernumber = 'P181008172055910' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406296'
                WHERE ordernumber = 'P201008172214572' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338843'
                WHERE ordernumber = 'P421008172257375' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424792'
                WHERE ordernumber = 'P421008172656118' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259125'
                WHERE ordernumber = 'P201008172924281' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424793'
                WHERE ordernumber = 'P731008173253603' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424782'
                WHERE ordernumber = 'P181008173527459' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424424'
                WHERE ordernumber = 'P631008173633203' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118258'
                WHERE ordernumber = 'P181008174839532' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398262'
                WHERE ordernumber = 'P181008175327227' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424738'
                WHERE ordernumber = 'P181008175605309' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424795'
                WHERE ordernumber = 'P591008175746625' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424797'
                WHERE ordernumber = 'P181008175911600' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386418'
                WHERE ordernumber = 'P631008175958347' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99982'
                WHERE ordernumber = 'P181008180231532' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424798'
                WHERE ordernumber = 'P421008180328636' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365174'
                WHERE ordernumber = 'P631008180415462' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221466'
                WHERE ordernumber = 'P181008180525806' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350756'
                WHERE ordernumber = 'P711008180918190' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424800'
                WHERE ordernumber = 'P421008181704417' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64798'
                WHERE ordernumber = 'P181008181758884' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289038'
                WHERE ordernumber = 'P201008181930819' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319552'
                WHERE ordernumber = 'P181008182807605' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414910'
                WHERE ordernumber = 'P201008183421920' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424803'
                WHERE ordernumber = 'P201008183549526' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424802'
                WHERE ordernumber = 'P711008183637834' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424801'
                WHERE ordernumber = 'P181008183705292' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424804'
                WHERE ordernumber = 'P731008183825979' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243812'
                WHERE ordernumber = 'P181008184925522' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383225'
                WHERE ordernumber = 'P181008185229636' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424806'
                WHERE ordernumber = 'P201008185336731' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116282'
                WHERE ordernumber = 'P201008185512230' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424807'
                WHERE ordernumber = 'P201008185641469' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424809'
                WHERE ordernumber = 'P201008185937794' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424808'
                WHERE ordernumber = 'P731008185954802' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '46166'
                WHERE ordernumber = 'P191008190157143' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112568'
                WHERE ordernumber = 'P191008190431323' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112568'
                WHERE ordernumber = 'P191008190606462' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424810'
                WHERE ordernumber = 'P201008190756610' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102761'
                WHERE ordernumber = 'P191008190907331' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337264'
                WHERE ordernumber = 'P191008191030605' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424815'
                WHERE ordernumber = 'P631008192655172' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424818'
                WHERE ordernumber = 'P191008193925750' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368710'
                WHERE ordernumber = 'P191008194150438' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424819'
                WHERE ordernumber = 'P711008194225710' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '184559'
                WHERE ordernumber = 'P191008194538574' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230543'
                WHERE ordernumber = 'P191008194918758' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378695'
                WHERE ordernumber = 'P191008195100344' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393538'
                WHERE ordernumber = 'P191008195850784' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424820'
                WHERE ordernumber = 'P711008200250697' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424828'
                WHERE ordernumber = 'P731008205017943' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424830'
                WHERE ordernumber = 'P731008205513738' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424831'
                WHERE ordernumber = 'P631008210940481' 
            
2024-10-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424834'
                WHERE ordernumber = 'P631008213019613'