2024-10-02 01:00:02 -- 將會員中心id寫入data-lake
2024-10-02 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-01%';
        
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423798'
                WHERE ordernumber = 'P201001110437184' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423797'
                WHERE ordernumber = 'P181001110534468' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423796'
                WHERE ordernumber = 'P191001110941282' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98694'
                WHERE ordernumber = 'P421001111007358' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '373647'
                WHERE ordernumber = 'P421001111136488' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269427'
                WHERE ordernumber = 'P181001111343183' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423801'
                WHERE ordernumber = 'P201001111442656' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423802'
                WHERE ordernumber = 'P201001111549622' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93266'
                WHERE ordernumber = 'P181001111618141' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423803'
                WHERE ordernumber = 'P181001112133597' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339198'
                WHERE ordernumber = 'P421001112344901' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '203673'
                WHERE ordernumber = 'P181001112501757' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337679'
                WHERE ordernumber = 'P711001112630922' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423806'
                WHERE ordernumber = 'P181001112739645' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410655'
                WHERE ordernumber = 'P181001112931956' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423808'
                WHERE ordernumber = 'P421001113210615' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423807'
                WHERE ordernumber = 'P181001113216805' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368478'
                WHERE ordernumber = 'P191001113759868' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423809'
                WHERE ordernumber = 'P201001114231271' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423811'
                WHERE ordernumber = 'P421001114334311' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112497'
                WHERE ordernumber = 'P421001114759280' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423813'
                WHERE ordernumber = 'P191001114814504' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423812'
                WHERE ordernumber = 'P181001115229501' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351228'
                WHERE ordernumber = 'P181001115550933' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423815'
                WHERE ordernumber = 'P421001115731404' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93028'
                WHERE ordernumber = 'P201001120714716' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250167'
                WHERE ordernumber = 'P201001120925783' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422853'
                WHERE ordernumber = 'P711001121226939' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421982'
                WHERE ordernumber = 'P181001122013189' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423816'
                WHERE ordernumber = 'P421001122205825' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423817'
                WHERE ordernumber = 'P201001122356589' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '157805'
                WHERE ordernumber = 'P731001122406823' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423818'
                WHERE ordernumber = 'P201001122545640' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133351'
                WHERE ordernumber = 'P201001122939631' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423820'
                WHERE ordernumber = 'P201001123546378' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423823'
                WHERE ordernumber = 'P201001123903837' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410546'
                WHERE ordernumber = 'P421001123913749' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237345'
                WHERE ordernumber = 'P181001124148493' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266880'
                WHERE ordernumber = 'P181001124524801' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423825'
                WHERE ordernumber = 'P181001124751539' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209570'
                WHERE ordernumber = 'P181001125245183' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371632'
                WHERE ordernumber = 'P181001125304969' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423826'
                WHERE ordernumber = 'P421001125422818' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423825'
                WHERE ordernumber = 'P181001125524398' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423707'
                WHERE ordernumber = 'P631001130300487' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101538'
                WHERE ordernumber = 'P181001130637388' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423828'
                WHERE ordernumber = 'P201001130701211' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423831'
                WHERE ordernumber = 'P181001131528539' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273262'
                WHERE ordernumber = 'P181001131624305' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218311'
                WHERE ordernumber = 'P181001131845458' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394739'
                WHERE ordernumber = 'P421001131940944' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423832'
                WHERE ordernumber = 'P731001132033153' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395448'
                WHERE ordernumber = 'P201001132426506' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423833'
                WHERE ordernumber = 'P421001132434927' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423834'
                WHERE ordernumber = 'P421001132739947' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399308'
                WHERE ordernumber = 'P421001132940602' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423835'
                WHERE ordernumber = 'P731001133213541' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423836'
                WHERE ordernumber = 'P181001133830237' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98847'
                WHERE ordernumber = 'P181001134810815' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423837'
                WHERE ordernumber = 'P201001135112725' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114191'
                WHERE ordernumber = 'P201001140456882' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334332'
                WHERE ordernumber = 'P421001141422681' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353829'
                WHERE ordernumber = 'P421001141713829' 
            
2024-10-02 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385157'
                WHERE ordernumber = 'P631001141948735' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423842'
                WHERE ordernumber = 'P711001142037159' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418411'
                WHERE ordernumber = 'P421001142134348' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423843'
                WHERE ordernumber = 'P181001142736221' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423844'
                WHERE ordernumber = 'P731001143134884' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423846'
                WHERE ordernumber = 'P711001144402770' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423848'
                WHERE ordernumber = 'P191001144900172' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360253'
                WHERE ordernumber = 'P181001145105489' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303069'
                WHERE ordernumber = 'P181001145823209' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62738'
                WHERE ordernumber = 'P191001150848515' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423849'
                WHERE ordernumber = 'P181001151356221' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365076'
                WHERE ordernumber = 'P201001151727578' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254154'
                WHERE ordernumber = 'P711001152327553' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P421001153102157' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101890'
                WHERE ordernumber = 'P181001153237518' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423852'
                WHERE ordernumber = 'P201001154153963' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423855'
                WHERE ordernumber = 'P201001160616229' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423857'
                WHERE ordernumber = 'P201001161303285' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423858'
                WHERE ordernumber = 'P201001161517116' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181001162124986' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423856'
                WHERE ordernumber = 'P631001162135196' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399573'
                WHERE ordernumber = 'P181001162602614' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400772'
                WHERE ordernumber = 'P421001163158564' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423859'
                WHERE ordernumber = 'P191001163617758' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102983'
                WHERE ordernumber = 'P201001163626693' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423860'
                WHERE ordernumber = 'P731001163838528' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97952'
                WHERE ordernumber = 'P201001164145905' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423861'
                WHERE ordernumber = 'P191001164201654' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423861'
                WHERE ordernumber = 'P191001164206822' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423864'
                WHERE ordernumber = 'P201001164531943' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409220'
                WHERE ordernumber = 'P201001164941454' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423865'
                WHERE ordernumber = 'P191001164941277' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235882'
                WHERE ordernumber = 'P631001165004916' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423866'
                WHERE ordernumber = 'P181001165550867' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423868'
                WHERE ordernumber = 'P181001170753831' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423869'
                WHERE ordernumber = 'P181001170953850' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99470'
                WHERE ordernumber = 'P181001171121800' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423871'
                WHERE ordernumber = 'P711001171735940' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380028'
                WHERE ordernumber = 'P201001172307232' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404367'
                WHERE ordernumber = 'P181001172408822' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81097'
                WHERE ordernumber = 'P201001172538561' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423872'
                WHERE ordernumber = 'P421001172800924' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165876'
                WHERE ordernumber = 'P201001172924131' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422200'
                WHERE ordernumber = 'P711001173330329' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376517'
                WHERE ordernumber = 'P711001173536791' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352545'
                WHERE ordernumber = 'P201001174148563' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423509'
                WHERE ordernumber = 'P201001174329355' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284155'
                WHERE ordernumber = 'P201001174632397' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423875'
                WHERE ordernumber = 'P201001175005499' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423874'
                WHERE ordernumber = 'P181001175100888' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119802'
                WHERE ordernumber = 'P181001175405374' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119802'
                WHERE ordernumber = 'P181001175501361' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423875'
                WHERE ordernumber = 'P201001175729733' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423878'
                WHERE ordernumber = 'P181001175941432' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423877'
                WHERE ordernumber = 'P181001180609468' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423877'
                WHERE ordernumber = 'P181001180629318' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423879'
                WHERE ordernumber = 'P181001181845273' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423879'
                WHERE ordernumber = 'P181001181908118' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317600'
                WHERE ordernumber = 'P181001182427224' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307922'
                WHERE ordernumber = 'P181001182647963' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110891'
                WHERE ordernumber = 'P181001183637807' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352960'
                WHERE ordernumber = 'P181001184339143' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288822'
                WHERE ordernumber = 'P201001184411320' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321982'
                WHERE ordernumber = 'P421001184441528' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284409'
                WHERE ordernumber = 'P181001184450439' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423881'
                WHERE ordernumber = 'P201001184633158' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256227'
                WHERE ordernumber = 'P731001185003421' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249015'
                WHERE ordernumber = 'P201001185605752' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342239'
                WHERE ordernumber = 'P181001185625167' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322219'
                WHERE ordernumber = 'P421001185910593' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378290'
                WHERE ordernumber = 'P191001191554462' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401268'
                WHERE ordernumber = 'P201001191922808' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423884'
                WHERE ordernumber = 'P711001192210237' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423883'
                WHERE ordernumber = 'P191001192245481' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423887'
                WHERE ordernumber = 'P191001193503897' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423888'
                WHERE ordernumber = 'P731001193928925' 
            
2024-10-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279954'
                WHERE ordernumber = 'P631001211014590'