2024-04-12 01:00:02 -- 將會員中心id寫入data-lake
2024-04-12 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-04-11%';
        
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200411111135216' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385131'
                WHERE ordernumber = 'P180411111219304' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160810'
                WHERE ordernumber = 'P200411111249408' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P180411111311170' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385132'
                WHERE ordernumber = 'P180411111555239' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350085'
                WHERE ordernumber = 'P180411111912704' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385134'
                WHERE ordernumber = 'P200411111916596' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385133'
                WHERE ordernumber = 'P420411112024243' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382282'
                WHERE ordernumber = 'P420411113002150' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364450'
                WHERE ordernumber = 'P420411113047769' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321974'
                WHERE ordernumber = 'P180411113306608' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365668'
                WHERE ordernumber = 'P200411113748579' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385136'
                WHERE ordernumber = 'P420411114449969' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104889'
                WHERE ordernumber = 'P200411114455379' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291421'
                WHERE ordernumber = 'P190411114517640' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111046'
                WHERE ordernumber = 'P180411114943740' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97169'
                WHERE ordernumber = 'P200411115401867' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385137'
                WHERE ordernumber = 'P200411120400576' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385139'
                WHERE ordernumber = 'P200411121110218' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385140'
                WHERE ordernumber = 'P180411121425964' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310087'
                WHERE ordernumber = 'P420411121505876' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351726'
                WHERE ordernumber = 'P200411123218699' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367946'
                WHERE ordernumber = 'P420411123809566' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385141'
                WHERE ordernumber = 'P200411124633989' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385141'
                WHERE ordernumber = 'P200411124658874' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136084'
                WHERE ordernumber = 'P200411124736421' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345751'
                WHERE ordernumber = 'P420411125432786' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385142'
                WHERE ordernumber = 'P200411125521772' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385144'
                WHERE ordernumber = 'P200411125855908' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385145'
                WHERE ordernumber = 'P420411130403606' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347489'
                WHERE ordernumber = 'P180411130653709' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385148'
                WHERE ordernumber = 'P590411130959913' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104722'
                WHERE ordernumber = 'P420411131215221' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385149'
                WHERE ordernumber = 'P180411132219399' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385151'
                WHERE ordernumber = 'P420411132907448' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385150'
                WHERE ordernumber = 'P200411132922726' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226540'
                WHERE ordernumber = 'P420411133031429' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226540'
                WHERE ordernumber = 'P420411133138367' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384312'
                WHERE ordernumber = 'P200411133422829' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245852'
                WHERE ordernumber = 'P200411133847457' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385020'
                WHERE ordernumber = 'P200411135208159' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282261'
                WHERE ordernumber = 'P200411135348308' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227260'
                WHERE ordernumber = 'P180411135350587' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385152'
                WHERE ordernumber = 'P420411135615178' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301892'
                WHERE ordernumber = 'P180411135836268' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385153'
                WHERE ordernumber = 'P200411140133371' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355302'
                WHERE ordernumber = 'P420411140600431' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385154'
                WHERE ordernumber = 'P200411140957428' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383315'
                WHERE ordernumber = 'P200411141109199' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303916'
                WHERE ordernumber = 'P200411141213406' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342992'
                WHERE ordernumber = 'P190411141254373' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251950'
                WHERE ordernumber = 'P200411141859867' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380354'
                WHERE ordernumber = 'P420411143139292' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385156'
                WHERE ordernumber = 'P190411143646456' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250073'
                WHERE ordernumber = 'P180411144337607' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342834'
                WHERE ordernumber = 'P420411144457228' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385157'
                WHERE ordernumber = 'P630411144906786' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385158'
                WHERE ordernumber = 'P420411145408220' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385158'
                WHERE ordernumber = 'P420411145424172' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '25121'
                WHERE ordernumber = 'P180411145726174' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385160'
                WHERE ordernumber = 'P420411150335349' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385162'
                WHERE ordernumber = 'P420411150543687' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385161'
                WHERE ordernumber = 'P420411150600881' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95036'
                WHERE ordernumber = 'P180411150800674' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106176'
                WHERE ordernumber = 'P630411150951822' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339724'
                WHERE ordernumber = 'P200411151610380' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383329'
                WHERE ordernumber = 'P420411151654922' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385164'
                WHERE ordernumber = 'P200411151836643' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132928'
                WHERE ordernumber = 'P180411151909247' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385165'
                WHERE ordernumber = 'P420411152632155' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385169'
                WHERE ordernumber = 'P180411154243225' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385168'
                WHERE ordernumber = 'P200411154309217' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385170'
                WHERE ordernumber = 'P420411154409137' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385171'
                WHERE ordernumber = 'P180411154507119' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385172'
                WHERE ordernumber = 'P190411154531612' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385173'
                WHERE ordernumber = 'P180411155325750' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333490'
                WHERE ordernumber = 'P420411155329504' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268773'
                WHERE ordernumber = 'P420411155634720' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385177'
                WHERE ordernumber = 'P420411162007289' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211379'
                WHERE ordernumber = 'P180411162807149' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378935'
                WHERE ordernumber = 'P420411162926868' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228322'
                WHERE ordernumber = 'P180411162938721' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385179'
                WHERE ordernumber = 'P180411163332862' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385180'
                WHERE ordernumber = 'P420411163631440' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229589'
                WHERE ordernumber = 'P180411163751377' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '55006'
                WHERE ordernumber = 'P180411163916598' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358895'
                WHERE ordernumber = 'P200411163939996' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385182'
                WHERE ordernumber = 'P420411164224252' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385182'
                WHERE ordernumber = 'P420411164808142' 
            
2024-04-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385186'
                WHERE ordernumber = 'P420411165720925' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380975'
                WHERE ordernumber = 'P180411165911703' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385187'
                WHERE ordernumber = 'P180411170035261' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367338'
                WHERE ordernumber = 'P180411170510170' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366850'
                WHERE ordernumber = 'P420411170650286' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274892'
                WHERE ordernumber = 'P200411170719182' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385188'
                WHERE ordernumber = 'P420411171541188' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385190'
                WHERE ordernumber = 'P180411171928682' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385191'
                WHERE ordernumber = 'P420411172118424' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385192'
                WHERE ordernumber = 'P180411172247967' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385193'
                WHERE ordernumber = 'P200411173034783' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268119'
                WHERE ordernumber = 'P630411173509339' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102757'
                WHERE ordernumber = 'P200411173655935' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100719'
                WHERE ordernumber = 'P630411173812326' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385195'
                WHERE ordernumber = 'P200411173911229' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385196'
                WHERE ordernumber = 'P180411174054718' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385189'
                WHERE ordernumber = 'P200411174527295' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356286'
                WHERE ordernumber = 'P180411175526295' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385199'
                WHERE ordernumber = 'P420411180058597' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223674'
                WHERE ordernumber = 'P180411180203249' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382417'
                WHERE ordernumber = 'P180411180428136' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385200'
                WHERE ordernumber = 'P180411180706668' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381591'
                WHERE ordernumber = 'P420411180737477' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380111'
                WHERE ordernumber = 'P190411180938964' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355007'
                WHERE ordernumber = 'P180411181612976' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385202'
                WHERE ordernumber = 'P200411181637927' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385203'
                WHERE ordernumber = 'P180411182142364' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121956'
                WHERE ordernumber = 'P420411182230216' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142266'
                WHERE ordernumber = 'P180411182335464' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385204'
                WHERE ordernumber = 'P200411182351867' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385205'
                WHERE ordernumber = 'P200411183316769' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385206'
                WHERE ordernumber = 'P200411183623406' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299342'
                WHERE ordernumber = 'P420411183637284' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385207'
                WHERE ordernumber = 'P180411184002668' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385208'
                WHERE ordernumber = 'P420411184325966' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385209'
                WHERE ordernumber = 'P420411184539186' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385174'
                WHERE ordernumber = 'P420411184855882' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382162'
                WHERE ordernumber = 'P200411185316346' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241631'
                WHERE ordernumber = 'P200411185353880' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385210'
                WHERE ordernumber = 'P200411185845274' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345668'
                WHERE ordernumber = 'P420411190345317' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224749'
                WHERE ordernumber = 'P190411190711936' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216124'
                WHERE ordernumber = 'P190411191157219' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374190'
                WHERE ordernumber = 'P420411192401342' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143576'
                WHERE ordernumber = 'P190411192722894' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '84735'
                WHERE ordernumber = 'P190411193020384' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214478'
                WHERE ordernumber = 'P190411193214329' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '29379'
                WHERE ordernumber = 'P200411193754331' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299947'
                WHERE ordernumber = 'P190411193754762' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357105'
                WHERE ordernumber = 'P630411194040623' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346381'
                WHERE ordernumber = 'P190411194247352' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385212'
                WHERE ordernumber = 'P200411194752434' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385213'
                WHERE ordernumber = 'P190411194822665' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248077'
                WHERE ordernumber = 'P190411195055462' 
            
2024-04-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214794'
                WHERE ordernumber = 'P190411195935963'