2024-09-18 01:00:02 -- 將會員中心id寫入data-lake
2024-09-18 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-09-17%';
        
2024-09-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360376'
                WHERE ordernumber = 'P630917134036353' 
            
2024-09-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350514'
                WHERE ordernumber = 'P630917154923536' 
            
2024-09-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421553'
                WHERE ordernumber = 'P1050917173230717' 
            
2024-09-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421554'
                WHERE ordernumber = 'P1050917181103506'