2024-11-20 01:00:01 -- 將會員中心id寫入data-lake
2024-11-20 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-11-19%';
        
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166122'
                WHERE ordernumber = 'P2411190000223' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '322385'
                WHERE ordernumber = 'P2411190000321' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '119764'
                WHERE ordernumber = 'P2411190000628' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394152'
                WHERE ordernumber = 'P2411190000753' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430852'
                WHERE ordernumber = 'P2411190001031' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420072'
                WHERE ordernumber = 'P2411190001220' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95799'
                WHERE ordernumber = 'P2411190001384' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391928'
                WHERE ordernumber = 'P2411190001685' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347354'
                WHERE ordernumber = 'P2411190001887' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430855'
                WHERE ordernumber = 'P2411190002065' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225805'
                WHERE ordernumber = 'P2411190002181' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430857'
                WHERE ordernumber = 'P2411190002262' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '50773'
                WHERE ordernumber = 'P2411190002383' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263364'
                WHERE ordernumber = 'P2411190002445' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403014'
                WHERE ordernumber = 'P2411190002693' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254447'
                WHERE ordernumber = 'P2411190002779' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307996'
                WHERE ordernumber = 'P2411190003264' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429886'
                WHERE ordernumber = 'P2411190003323' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311367'
                WHERE ordernumber = 'P2411190003516' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209574'
                WHERE ordernumber = 'P2411190003677' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430864'
                WHERE ordernumber = 'P2411190003747' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348757'
                WHERE ordernumber = 'P2411190003845' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430867'
                WHERE ordernumber = 'P2411190003982' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '82165'
                WHERE ordernumber = 'P2411190004311' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2411190004638' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430870'
                WHERE ordernumber = 'P2411190004848' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430872'
                WHERE ordernumber = 'P2411190004970' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430871'
                WHERE ordernumber = 'P2411190005127' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324082'
                WHERE ordernumber = 'P2411190005341' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430850'
                WHERE ordernumber = 'P2411190005436' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273868'
                WHERE ordernumber = 'P2411190005535' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430876'
                WHERE ordernumber = 'P2411190005635' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430877'
                WHERE ordernumber = 'P2411190005768' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430873'
                WHERE ordernumber = 'P2411190005965' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430878'
                WHERE ordernumber = 'P2411190006270' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430881'
                WHERE ordernumber = 'P2411190006376' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430880'
                WHERE ordernumber = 'P2411190006432' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430883'
                WHERE ordernumber = 'P2411190006628' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290609'
                WHERE ordernumber = 'P2411190006891' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291669'
                WHERE ordernumber = 'P2411190006918' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346189'
                WHERE ordernumber = 'P2411190007178' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430885'
                WHERE ordernumber = 'P2411190007256' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237400'
                WHERE ordernumber = 'P2411190007345' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P2411190007554' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430886'
                WHERE ordernumber = 'P2411190007860' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430888'
                WHERE ordernumber = 'P2411190008011' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416454'
                WHERE ordernumber = 'P2411190008115' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214193'
                WHERE ordernumber = 'P2411190008236' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247699'
                WHERE ordernumber = 'P2411190008685' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101976'
                WHERE ordernumber = 'P2411190008832' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249845'
                WHERE ordernumber = 'P2411190008943' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249845'
                WHERE ordernumber = 'P2411190009132' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283429'
                WHERE ordernumber = 'P2411190009585' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430894'
                WHERE ordernumber = 'P2411190009667' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430895'
                WHERE ordernumber = 'P2411190009766' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319608'
                WHERE ordernumber = 'P2411190010192' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231451'
                WHERE ordernumber = 'P2411190010250' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143274'
                WHERE ordernumber = 'P2411190010543' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430898'
                WHERE ordernumber = 'P2411190010978' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430899'
                WHERE ordernumber = 'P2411190011039' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430901'
                WHERE ordernumber = 'P2411190011156' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430900'
                WHERE ordernumber = 'P2411190011275' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430903'
                WHERE ordernumber = 'P2411190011411' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430904'
                WHERE ordernumber = 'P2411190011657' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430905'
                WHERE ordernumber = 'P2411190011755' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339398'
                WHERE ordernumber = 'P2411190011862' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95398'
                WHERE ordernumber = 'P2411190011986' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430906'
                WHERE ordernumber = 'P2411190012074' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208741'
                WHERE ordernumber = 'P2411190012571' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430910'
                WHERE ordernumber = 'P2411190012681' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102978'
                WHERE ordernumber = 'P2411190012731' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430912'
                WHERE ordernumber = 'P2411190012852' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430914'
                WHERE ordernumber = 'P2411190012992' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218880'
                WHERE ordernumber = 'P2411190013093' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430778'
                WHERE ordernumber = 'P2411190013118' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287563'
                WHERE ordernumber = 'P2411190013476' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430336'
                WHERE ordernumber = 'P2411190013527' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430916'
                WHERE ordernumber = 'P2411190013954' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430917'
                WHERE ordernumber = 'P2411190014013' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430919'
                WHERE ordernumber = 'P2411190014234' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P2411190014312' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P2411190014411' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430920'
                WHERE ordernumber = 'P2411190014569' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99638'
                WHERE ordernumber = 'P2411190014693' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272786'
                WHERE ordernumber = 'P2411190014796' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430926'
                WHERE ordernumber = 'P2411190015226' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430109'
                WHERE ordernumber = 'P2411190015396' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '65749'
                WHERE ordernumber = 'P2411190015721' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430922'
                WHERE ordernumber = 'P2411190015881' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430922'
                WHERE ordernumber = 'P2411190015991' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390812'
                WHERE ordernumber = 'P2411190016284' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430932'
                WHERE ordernumber = 'P2411190016380' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332467'
                WHERE ordernumber = 'P2411190016538' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430930'
                WHERE ordernumber = 'P2411190016699' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241147'
                WHERE ordernumber = 'P2411190016742' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133443'
                WHERE ordernumber = 'P2411190016854' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430933'
                WHERE ordernumber = 'P2411190017020' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430936'
                WHERE ordernumber = 'P2411190017245' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430937'
                WHERE ordernumber = 'P2411190017310' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426989'
                WHERE ordernumber = 'P2411190017467' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430938'
                WHERE ordernumber = 'P2411190017536' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430942'
                WHERE ordernumber = 'P2411190017611' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344779'
                WHERE ordernumber = 'P2411190017794' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311254'
                WHERE ordernumber = 'P2411190017877' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127189'
                WHERE ordernumber = 'P2411190018135' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '322480'
                WHERE ordernumber = 'P2411190018236' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340568'
                WHERE ordernumber = 'P2411190018398' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430943'
                WHERE ordernumber = 'P2411190018483' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430799'
                WHERE ordernumber = 'P2411190018652' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384149'
                WHERE ordernumber = 'P2411190019077' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253431'
                WHERE ordernumber = 'P2411190019172' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382242'
                WHERE ordernumber = 'P2411190019588' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206345'
                WHERE ordernumber = 'P2411190019846' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '62142'
                WHERE ordernumber = 'P2411190020071' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422369'
                WHERE ordernumber = 'P2411190020249' 
            
2024-11-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372908'
                WHERE ordernumber = 'P2411190020464' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429897'
                WHERE ordernumber = 'P2411190020590' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291977'
                WHERE ordernumber = 'P2411190020679' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292471'
                WHERE ordernumber = 'P2411190020856' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430416'
                WHERE ordernumber = 'P2411190021162' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383903'
                WHERE ordernumber = 'P2411190021297' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231451'
                WHERE ordernumber = 'P2411190021545' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430949'
                WHERE ordernumber = 'P2411190021650' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430949'
                WHERE ordernumber = 'P2411190021738' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430416'
                WHERE ordernumber = 'P2411190021873' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430947'
                WHERE ordernumber = 'P2411190021926' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430949'
                WHERE ordernumber = 'P2411190022068' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430946'
                WHERE ordernumber = 'P2411190022131' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250305'
                WHERE ordernumber = 'P2411190022289' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127964'
                WHERE ordernumber = 'P2411190022330' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168634'
                WHERE ordernumber = 'P2411190022997' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82098'
                WHERE ordernumber = 'P2411190023545' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426806'
                WHERE ordernumber = 'P2411190023740' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430955'
                WHERE ordernumber = 'P2411190023850' 
            
2024-11-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430957'
                WHERE ordernumber = 'P2411190024099'