2024-10-04 01:00:01 -- 將會員中心id寫入data-lake
2024-10-04 01:00:01 -- 
            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-03%';
        
2024-10-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423932'
                WHERE ordernumber = 'P631003115440731' 
            
2024-10-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423281'
                WHERE ordernumber = 'P631003120921782' 
            
2024-10-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '207961'
                WHERE ordernumber = 'P731003123929905' 
            
2024-10-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403319'
                WHERE ordernumber = 'P631003133640479' 
            
2024-10-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272528'
                WHERE ordernumber = 'P731003134349924' 
            
2024-10-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423967'
                WHERE ordernumber = 'P631003143705133' 
            
2024-10-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '157711'
                WHERE ordernumber = 'P731003152223574' 
            
2024-10-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290377'
                WHERE ordernumber = 'P731003162809467' 
            
2024-10-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423981'
                WHERE ordernumber = 'P731003170917727' 
            
2024-10-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423987'
                WHERE ordernumber = 'P731003185520206' 
            
2024-10-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136100'
                WHERE ordernumber = 'P731003195351560'