2024-11-19 01:00:02 -- 將會員中心id寫入data-lake
2024-11-19 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-11-18%';
        
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2411180000286' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244494'
                WHERE ordernumber = 'P2411180000415' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116368'
                WHERE ordernumber = 'P2411180000789' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422304'
                WHERE ordernumber = 'P2411180001627' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430730'
                WHERE ordernumber = 'P2411180001775' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133372'
                WHERE ordernumber = 'P2411180002087' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285340'
                WHERE ordernumber = 'P2411180002184' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430733'
                WHERE ordernumber = 'P2411180002276' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389260'
                WHERE ordernumber = 'P2411180002387' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430735'
                WHERE ordernumber = 'P2411180002661' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P2411180002730' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116975'
                WHERE ordernumber = 'P2411180002813' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297597'
                WHERE ordernumber = 'P2411180003063' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293225'
                WHERE ordernumber = 'P2411180003131' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428876'
                WHERE ordernumber = 'P2411180003665' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '152024'
                WHERE ordernumber = 'P2411180003775' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430739'
                WHERE ordernumber = 'P2411180003811' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246901'
                WHERE ordernumber = 'P2411180004019' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238895'
                WHERE ordernumber = 'P2411180004394' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273560'
                WHERE ordernumber = 'P2411180004530' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430741'
                WHERE ordernumber = 'P2411180004653' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430742'
                WHERE ordernumber = 'P2411180004943' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143149'
                WHERE ordernumber = 'P2411180005034' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '21675'
                WHERE ordernumber = 'P2411180005177' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412721'
                WHERE ordernumber = 'P2411180005486' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '226838'
                WHERE ordernumber = 'P2411180005536' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423390'
                WHERE ordernumber = 'P2411180005965' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264691'
                WHERE ordernumber = 'P2411180006164' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422790'
                WHERE ordernumber = 'P2411180006454' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389161'
                WHERE ordernumber = 'P2411180006546' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '158709'
                WHERE ordernumber = 'P2411180006739' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430726'
                WHERE ordernumber = 'P2411180006949' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430747'
                WHERE ordernumber = 'P2411180007126' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430749'
                WHERE ordernumber = 'P2411180007257' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310793'
                WHERE ordernumber = 'P2411180007367' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430752'
                WHERE ordernumber = 'P2411180007471' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250018'
                WHERE ordernumber = 'P2411180007673' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P2411180007759' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423707'
                WHERE ordernumber = 'P2411180007896' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430757'
                WHERE ordernumber = 'P2411180007957' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343931'
                WHERE ordernumber = 'P2411180008037' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430755'
                WHERE ordernumber = 'P2411180008114' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430756'
                WHERE ordernumber = 'P2411180008279' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430759'
                WHERE ordernumber = 'P2411180008356' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110592'
                WHERE ordernumber = 'P2411180008419' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430762'
                WHERE ordernumber = 'P2411180008696' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389637'
                WHERE ordernumber = 'P2411180008741' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412517'
                WHERE ordernumber = 'P2411180008866' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430763'
                WHERE ordernumber = 'P2411180008919' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95730'
                WHERE ordernumber = 'P2411180009094' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430758'
                WHERE ordernumber = 'P2411180009155' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422653'
                WHERE ordernumber = 'P2411180009317' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430766'
                WHERE ordernumber = 'P2411180009411' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290726'
                WHERE ordernumber = 'P2411180009756' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430770'
                WHERE ordernumber = 'P2411180009842' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430769'
                WHERE ordernumber = 'P2411180009989' 
            
2024-11-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430771'
                WHERE ordernumber = 'P2411180010156' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239240'
                WHERE ordernumber = 'P2411180010288' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P2411180010386' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430772'
                WHERE ordernumber = 'P2411180010497' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430773'
                WHERE ordernumber = 'P2411180010560' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430774'
                WHERE ordernumber = 'P2411180010720' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340480'
                WHERE ordernumber = 'P2411180010869' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427023'
                WHERE ordernumber = 'P2411180010985' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240834'
                WHERE ordernumber = 'P2411180011199' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430779'
                WHERE ordernumber = 'P2411180011812' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287903'
                WHERE ordernumber = 'P2411180011936' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P2411180012294' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430781'
                WHERE ordernumber = 'P2411180012644' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159463'
                WHERE ordernumber = 'P2411180012850' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430706'
                WHERE ordernumber = 'P2411180013485' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430706'
                WHERE ordernumber = 'P2411180013567' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132384'
                WHERE ordernumber = 'P2411180013654' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430786'
                WHERE ordernumber = 'P2411180013740' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430787'
                WHERE ordernumber = 'P2411180013811' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429932'
                WHERE ordernumber = 'P2411180014092' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424659'
                WHERE ordernumber = 'P2411180014542' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430789'
                WHERE ordernumber = 'P2411180014699' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221426'
                WHERE ordernumber = 'P2411180014732' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430790'
                WHERE ordernumber = 'P2411180014836' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430791'
                WHERE ordernumber = 'P2411180014916' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430792'
                WHERE ordernumber = 'P2411180015139' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430793'
                WHERE ordernumber = 'P2411180015287' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389581'
                WHERE ordernumber = 'P2411180015376' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147815'
                WHERE ordernumber = 'P2411180015690' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350776'
                WHERE ordernumber = 'P2411180015998' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430799'
                WHERE ordernumber = 'P2411180016955' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307996'
                WHERE ordernumber = 'P2411180017066' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430801'
                WHERE ordernumber = 'P2411180017326' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277774'
                WHERE ordernumber = 'P2411180017474' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413702'
                WHERE ordernumber = 'P2411180017943' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406094'
                WHERE ordernumber = 'P2411180018099' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163339'
                WHERE ordernumber = 'P2411180018371' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429797'
                WHERE ordernumber = 'P2411180018476' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429797'
                WHERE ordernumber = 'P2411180018558' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429797'
                WHERE ordernumber = 'P2411180018679' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379762'
                WHERE ordernumber = 'P2411180018988' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430804'
                WHERE ordernumber = 'P2411180019022' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '144204'
                WHERE ordernumber = 'P2411180019238' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430803'
                WHERE ordernumber = 'P2411180019357' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430805'
                WHERE ordernumber = 'P2411180019416' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '144204'
                WHERE ordernumber = 'P2411180019568' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81972'
                WHERE ordernumber = 'P2411180019682' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137870'
                WHERE ordernumber = 'P2411180019775' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428958'
                WHERE ordernumber = 'P2411180020041' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139402'
                WHERE ordernumber = 'P2411180020180' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430734'
                WHERE ordernumber = 'P2411180020282' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221764'
                WHERE ordernumber = 'P2411180020434' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430734'
                WHERE ordernumber = 'P2411180020522' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430806'
                WHERE ordernumber = 'P2411180020643' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430808'
                WHERE ordernumber = 'P2411180020946' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430809'
                WHERE ordernumber = 'P2411180021186' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430810'
                WHERE ordernumber = 'P2411180021223' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430811'
                WHERE ordernumber = 'P2411180021617' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430814'
                WHERE ordernumber = 'P2411180021764' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430815'
                WHERE ordernumber = 'P2411180021849' 
            
2024-11-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105529'
                WHERE ordernumber = 'P2411180021912'