2024-04-16 01:00:03 -- 將會員中心id寫入data-lake
2024-04-16 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-15%';
        
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264123'
                WHERE ordernumber = 'P180415111637359' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153743'
                WHERE ordernumber = 'P200415112035880' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378451'
                WHERE ordernumber = 'P180415112331313' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385608'
                WHERE ordernumber = 'P590415112935618' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420415113255343' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385609'
                WHERE ordernumber = 'P420415113813422' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '192556'
                WHERE ordernumber = 'P180415114053407' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385610'
                WHERE ordernumber = 'P420415114113471' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385611'
                WHERE ordernumber = 'P180415114139664' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384969'
                WHERE ordernumber = 'P180415114549589' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276466'
                WHERE ordernumber = 'P200415115420219' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385613'
                WHERE ordernumber = 'P180415115517946' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94310'
                WHERE ordernumber = 'P200415115852219' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385614'
                WHERE ordernumber = 'P590415121412764' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243405'
                WHERE ordernumber = 'P200415121824988' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310326'
                WHERE ordernumber = 'P590415121929461' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232251'
                WHERE ordernumber = 'P190415123044499' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242008'
                WHERE ordernumber = 'P200415123545326' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337747'
                WHERE ordernumber = 'P420415123639837' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385615'
                WHERE ordernumber = 'P180415124156912' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156908'
                WHERE ordernumber = 'P420415124229293' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140499'
                WHERE ordernumber = 'P180415124401359' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385616'
                WHERE ordernumber = 'P180415124901964' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385617'
                WHERE ordernumber = 'P180415125817280' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385618'
                WHERE ordernumber = 'P420415130157752' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385619'
                WHERE ordernumber = 'P420415130406607' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385620'
                WHERE ordernumber = 'P180415131231490' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333919'
                WHERE ordernumber = 'P180415131429396' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385621'
                WHERE ordernumber = 'P590415131559192' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141908'
                WHERE ordernumber = 'P420415131848440' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385622'
                WHERE ordernumber = 'P420415132054388' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334915'
                WHERE ordernumber = 'P590415132724998' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385552'
                WHERE ordernumber = 'P200415132740479' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86258'
                WHERE ordernumber = 'P180415134149717' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385623'
                WHERE ordernumber = 'P420415134656848' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385624'
                WHERE ordernumber = 'P420415135457638' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382340'
                WHERE ordernumber = 'P200415135651315' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256896'
                WHERE ordernumber = 'P180415135728841' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385625'
                WHERE ordernumber = 'P200415135907683' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262658'
                WHERE ordernumber = 'P180415135948743' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115322'
                WHERE ordernumber = 'P180415140732324' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355140'
                WHERE ordernumber = 'P200415141146620' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180415141236574' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385628'
                WHERE ordernumber = 'P590415142100570' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304141'
                WHERE ordernumber = 'P200415142113683' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385626'
                WHERE ordernumber = 'P590415142808688' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '37663'
                WHERE ordernumber = 'P200415142854161' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254684'
                WHERE ordernumber = 'P200415142934794' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382340'
                WHERE ordernumber = 'P590415143406455' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125213'
                WHERE ordernumber = 'P200415143500251' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283941'
                WHERE ordernumber = 'P200415143811846' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385631'
                WHERE ordernumber = 'P180415143818783' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385632'
                WHERE ordernumber = 'P590415144154474' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241208'
                WHERE ordernumber = 'P200415144513451' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385633'
                WHERE ordernumber = 'P420415144540511' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385634'
                WHERE ordernumber = 'P590415145022398' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109174'
                WHERE ordernumber = 'P200415145616648' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250391'
                WHERE ordernumber = 'P180415150110958' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371375'
                WHERE ordernumber = 'P420415151318282' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107110'
                WHERE ordernumber = 'P180415151945287' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347603'
                WHERE ordernumber = 'P200415153451596' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385637'
                WHERE ordernumber = 'P180415153512390' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385640'
                WHERE ordernumber = 'P420415154051473' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108231'
                WHERE ordernumber = 'P180415154142443' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385641'
                WHERE ordernumber = 'P420415154329332' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385642'
                WHERE ordernumber = 'P420415154532530' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376110'
                WHERE ordernumber = 'P180415155550948' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354058'
                WHERE ordernumber = 'P200415155634307' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385643'
                WHERE ordernumber = 'P180415155701406' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385644'
                WHERE ordernumber = 'P420415155716902' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138008'
                WHERE ordernumber = 'P200415160003639' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385645'
                WHERE ordernumber = 'P420415161504528' 
            
2024-04-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385345'
                WHERE ordernumber = 'P630415161624856' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385532'
                WHERE ordernumber = 'P420415162553775' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268464'
                WHERE ordernumber = 'P200415162816562' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340551'
                WHERE ordernumber = 'P420415163541750' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385647'
                WHERE ordernumber = 'P180415163709947' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384013'
                WHERE ordernumber = 'P190415164520507' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304156'
                WHERE ordernumber = 'P200415164833914' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385650'
                WHERE ordernumber = 'P180415165044249' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385651'
                WHERE ordernumber = 'P630415165138988' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248368'
                WHERE ordernumber = 'P630415165203410' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292524'
                WHERE ordernumber = 'P630415165619971' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226450'
                WHERE ordernumber = 'P200415165950114' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125653'
                WHERE ordernumber = 'P180415170026781' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365376'
                WHERE ordernumber = 'P180415171442683' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385652'
                WHERE ordernumber = 'P630415171726740' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293946'
                WHERE ordernumber = 'P180415172152716' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382690'
                WHERE ordernumber = 'P200415172401805' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307282'
                WHERE ordernumber = 'P180415172926154' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385653'
                WHERE ordernumber = 'P420415172933140' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385655'
                WHERE ordernumber = 'P180415173134697' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385657'
                WHERE ordernumber = 'P180415174029886' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365094'
                WHERE ordernumber = 'P200415174145709' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364110'
                WHERE ordernumber = 'P200415174438158' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385658'
                WHERE ordernumber = 'P200415174527631' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379215'
                WHERE ordernumber = 'P200415175300476' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385659'
                WHERE ordernumber = 'P420415175846365' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207380'
                WHERE ordernumber = 'P180415181054635' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385660'
                WHERE ordernumber = 'P630415182527720' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385661'
                WHERE ordernumber = 'P180415182527571' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243956'
                WHERE ordernumber = 'P190415182650314' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307643'
                WHERE ordernumber = 'P180415182655976' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '180622'
                WHERE ordernumber = 'P630415183351913' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119612'
                WHERE ordernumber = 'P180415183500699' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250176'
                WHERE ordernumber = 'P200415184911307' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385662'
                WHERE ordernumber = 'P630415190022803' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132801'
                WHERE ordernumber = 'P200415190154195' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88988'
                WHERE ordernumber = 'P420415190200880' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385663'
                WHERE ordernumber = 'P630415190234410' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385664'
                WHERE ordernumber = 'P190415190748548' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164905'
                WHERE ordernumber = 'P190415191425646' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '91524'
                WHERE ordernumber = 'P420415191514888' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385665'
                WHERE ordernumber = 'P190415191605764' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288989'
                WHERE ordernumber = 'P200415192448614' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385666'
                WHERE ordernumber = 'P420415192829711' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385667'
                WHERE ordernumber = 'P590415193431209' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385668'
                WHERE ordernumber = 'P190415193524855' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271872'
                WHERE ordernumber = 'P590415194551524' 
            
2024-04-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385670'
                WHERE ordernumber = 'P590415202435594'