2024-07-26 01:00:03 -- 將會員中心id寫入data-lake
2024-07-26 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-07-25%';
        
2024-07-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400425'
                WHERE ordernumber = 'P590725161502887' 
            
2024-07-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402986'
                WHERE ordernumber = 'P590725165917401' 
            
2024-07-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154776'
                WHERE ordernumber = 'P630725174537358' 
            
2024-07-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256512'
                WHERE ordernumber = 'P630725194827674' 
            
2024-07-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403026'
                WHERE ordernumber = 'P630725201233616'