2024-02-24 01:00:01 -- 將會員中心id寫入data-lake
2024-02-24 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-02-23%';
        
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320265'
                WHERE ordernumber = 'P190223110230327' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220905'
                WHERE ordernumber = 'P190223110455739' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378564'
                WHERE ordernumber = 'P190223110622979' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378566'
                WHERE ordernumber = 'P200223110803480' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81671'
                WHERE ordernumber = 'P190223110832778' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378567'
                WHERE ordernumber = 'P420223110831790' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283469'
                WHERE ordernumber = 'P200223110959502' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378568'
                WHERE ordernumber = 'P190223111016393' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378569'
                WHERE ordernumber = 'P420223111151740' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378570'
                WHERE ordernumber = 'P190223111221456' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378571'
                WHERE ordernumber = 'P420223111536613' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378572'
                WHERE ordernumber = 'P200223111612300' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378573'
                WHERE ordernumber = 'P200223111730496' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378576'
                WHERE ordernumber = 'P200223111949672' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378577'
                WHERE ordernumber = 'P420223112418947' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294236'
                WHERE ordernumber = 'P200223112613280' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '45344'
                WHERE ordernumber = 'P190223112616355' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378579'
                WHERE ordernumber = 'P420223112631442' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228318'
                WHERE ordernumber = 'P190223112716552' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378581'
                WHERE ordernumber = 'P190223112827262' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276849'
                WHERE ordernumber = 'P200223112921404' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378574'
                WHERE ordernumber = 'P190223113038508' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378323'
                WHERE ordernumber = 'P200223113051275' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378582'
                WHERE ordernumber = 'P200223113303118' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378583'
                WHERE ordernumber = 'P190223113559297' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378584'
                WHERE ordernumber = 'P420223113732798' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154659'
                WHERE ordernumber = 'P200223114101140' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '77964'
                WHERE ordernumber = 'P200223114214626' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377387'
                WHERE ordernumber = 'P190223114502581' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369708'
                WHERE ordernumber = 'P420223114655720' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239567'
                WHERE ordernumber = 'P190223115148432' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378586'
                WHERE ordernumber = 'P190223115302993' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378587'
                WHERE ordernumber = 'P200223115537823' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263162'
                WHERE ordernumber = 'P190223115919907' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378588'
                WHERE ordernumber = 'P200223120103521' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251216'
                WHERE ordernumber = 'P200223120151303' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317718'
                WHERE ordernumber = 'P420223120200861' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378580'
                WHERE ordernumber = 'P190223120239304' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378585'
                WHERE ordernumber = 'P420223120318209' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240551'
                WHERE ordernumber = 'P200223120345302' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378589'
                WHERE ordernumber = 'P420223120651516' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358195'
                WHERE ordernumber = 'P190223120959540' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297072'
                WHERE ordernumber = 'P420223122159992' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378590'
                WHERE ordernumber = 'P420223122413720' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378591'
                WHERE ordernumber = 'P190223122825312' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378592'
                WHERE ordernumber = 'P190223123013557' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378593'
                WHERE ordernumber = 'P190223123325387' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378595'
                WHERE ordernumber = 'P420223123543594' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137581'
                WHERE ordernumber = 'P190223124551152' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378597'
                WHERE ordernumber = 'P190223124821728' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378169'
                WHERE ordernumber = 'P200223124910894' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245747'
                WHERE ordernumber = 'P200223125319844' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350153'
                WHERE ordernumber = 'P200223125435348' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378575'
                WHERE ordernumber = 'P420223130109847' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251872'
                WHERE ordernumber = 'P420223130337706' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378598'
                WHERE ordernumber = 'P200223130525440' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378599'
                WHERE ordernumber = 'P200223130736954' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377582'
                WHERE ordernumber = 'P420223131128615' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378600'
                WHERE ordernumber = 'P420223131401549' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307192'
                WHERE ordernumber = 'P420223131452182' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297157'
                WHERE ordernumber = 'P420223132122600' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378602'
                WHERE ordernumber = 'P190223132322866' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368125'
                WHERE ordernumber = 'P190223132627896' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378603'
                WHERE ordernumber = 'P200223133036433' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340691'
                WHERE ordernumber = 'P200223133204166' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349585'
                WHERE ordernumber = 'P190223134459952' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '1592'
                WHERE ordernumber = 'P190223135225662' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378606'
                WHERE ordernumber = 'P190223135508119' 
            
2024-02-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377582'
                WHERE ordernumber = 'P200223140251678'