2024-11-01 01:00:02 -- 將會員中心id寫入data-lake
2024-11-01 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-31%';
        
2024-11-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428395'
                WHERE ordernumber = 'P711031122414853' 
            
2024-11-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427954'
                WHERE ordernumber = 'P711031163033611' 
            
2024-11-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231844'
                WHERE ordernumber = 'P711031163205712'