2024-10-03 01:00:02 -- 將會員中心id寫入data-lake
2024-10-03 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-02%';
        
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '39674'
                WHERE ordernumber = 'P631002111620613' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423867'
                WHERE ordernumber = 'P731002112620761' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423913'
                WHERE ordernumber = 'P731002112912517' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423914'
                WHERE ordernumber = 'P731002113102889' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423915'
                WHERE ordernumber = 'P731002113637524' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423918'
                WHERE ordernumber = 'P731002115542700' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423920'
                WHERE ordernumber = 'P731002120200438' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423921'
                WHERE ordernumber = 'P731002120454660' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423922'
                WHERE ordernumber = 'P731002120921419' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '370757'
                WHERE ordernumber = 'P731002123312339' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '200768'
                WHERE ordernumber = 'P711002123455545' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423927'
                WHERE ordernumber = 'P731002125729784' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423925'
                WHERE ordernumber = 'P731002125833845' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423926'
                WHERE ordernumber = 'P731002125941646' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423924'
                WHERE ordernumber = 'P731002130305536' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423928'
                WHERE ordernumber = 'P711002131451324' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '39363'
                WHERE ordernumber = 'P631002132458523' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422937'
                WHERE ordernumber = 'P631002133845649' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423929'
                WHERE ordernumber = 'P731002135411575' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423929'
                WHERE ordernumber = 'P731002135658415' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423931'
                WHERE ordernumber = 'P711002141055330' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423936'
                WHERE ordernumber = 'P711002163909556' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423919'
                WHERE ordernumber = 'P731002164149133' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390727'
                WHERE ordernumber = 'P731002174714391' 
            
2024-10-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423612'
                WHERE ordernumber = 'P631002183835158'