2025-02-15 01:00:01 -- 將會員中心id寫入data-lake
2025-02-15 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 '2025-02-14%';
        
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '158635'
                WHERE ordernumber = 'P2502140000021' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402427'
                WHERE ordernumber = 'P2502140000025' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2502140000026' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455975'
                WHERE ordernumber = 'P2502140000029' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455976'
                WHERE ordernumber = 'P2502140000033' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455158'
                WHERE ordernumber = 'P2502140000035' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433141'
                WHERE ordernumber = 'P2502140000036' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454830'
                WHERE ordernumber = 'P2502140000038' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386312'
                WHERE ordernumber = 'P2502140000040' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455978'
                WHERE ordernumber = 'P2502140000042' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102863'
                WHERE ordernumber = 'P2502140000049' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455978'
                WHERE ordernumber = 'P2502140000050' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '215133'
                WHERE ordernumber = 'P2502140000052' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455979'
                WHERE ordernumber = 'P2502140000054' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241062'
                WHERE ordernumber = 'P2502140000055' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81676'
                WHERE ordernumber = 'P2502140000058' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455980'
                WHERE ordernumber = 'P2502140000059' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385133'
                WHERE ordernumber = 'P2502140000061' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310533'
                WHERE ordernumber = 'P2502140000064' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '453059'
                WHERE ordernumber = 'P2502140000067' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438160'
                WHERE ordernumber = 'P2502140000069' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455982'
                WHERE ordernumber = 'P2502140000072' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301771'
                WHERE ordernumber = 'P2502140000082' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283915'
                WHERE ordernumber = 'P2502140000088' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455117'
                WHERE ordernumber = 'P2502140000093' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455983'
                WHERE ordernumber = 'P2502140000100' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '262148'
                WHERE ordernumber = 'P2502140000102' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352006'
                WHERE ordernumber = 'P2502140000109' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455985'
                WHERE ordernumber = 'P2502140000111' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268471'
                WHERE ordernumber = 'P2502140000113' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P2502140000116' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313348'
                WHERE ordernumber = 'P2502140000119' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455988'
                WHERE ordernumber = 'P2502140000124' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455987'
                WHERE ordernumber = 'P2502140000127' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455989'
                WHERE ordernumber = 'P2502140000128' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '446540'
                WHERE ordernumber = 'P2502140000131' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214136'
                WHERE ordernumber = 'P2502140000136' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455992'
                WHERE ordernumber = 'P2502140000139' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455993'
                WHERE ordernumber = 'P2502140000143' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213664'
                WHERE ordernumber = 'P2502140000145' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412009'
                WHERE ordernumber = 'P2502140000147' 
            
2025-02-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311988'
                WHERE ordernumber = 'P2502140000148' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224421'
                WHERE ordernumber = 'P2502140000149' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290609'
                WHERE ordernumber = 'P2502140000153' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455996'
                WHERE ordernumber = 'P2502140000154' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455994'
                WHERE ordernumber = 'P2502140000155' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455995'
                WHERE ordernumber = 'P2502140000156' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455998'
                WHERE ordernumber = 'P2502140000159' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455997'
                WHERE ordernumber = 'P2502140000160' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456001'
                WHERE ordernumber = 'P2502140000165' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456000'
                WHERE ordernumber = 'P2502140000167' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455997'
                WHERE ordernumber = 'P2502140000169' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289929'
                WHERE ordernumber = 'P2502140000171' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456002'
                WHERE ordernumber = 'P2502140000172' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96134'
                WHERE ordernumber = 'P2502140000173' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247190'
                WHERE ordernumber = 'P2502140000174' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456002'
                WHERE ordernumber = 'P2502140000175' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456005'
                WHERE ordernumber = 'P2502140000183' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98929'
                WHERE ordernumber = 'P2502140000185' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456006'
                WHERE ordernumber = 'P2502140000187' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456007'
                WHERE ordernumber = 'P2502140000188' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456004'
                WHERE ordernumber = 'P2502140000190' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456008'
                WHERE ordernumber = 'P2502140000192' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396702'
                WHERE ordernumber = 'P2502140000194' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456004'
                WHERE ordernumber = 'P2502140000196' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365771'
                WHERE ordernumber = 'P2502140000200' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456009'
                WHERE ordernumber = 'P2502140000201' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409144'
                WHERE ordernumber = 'P2502140000202' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365771'
                WHERE ordernumber = 'P2502140000208' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456010'
                WHERE ordernumber = 'P2502140000212' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456011'
                WHERE ordernumber = 'P2502140000215' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456012'
                WHERE ordernumber = 'P2502140000218' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456013'
                WHERE ordernumber = 'P2502140000220' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456015'
                WHERE ordernumber = 'P2502140000222' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456016'
                WHERE ordernumber = 'P2502140000225' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456014'
                WHERE ordernumber = 'P2502140000227' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456018'
                WHERE ordernumber = 'P2502140000229' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431877'
                WHERE ordernumber = 'P2502140000230' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366041'
                WHERE ordernumber = 'P2502140000232' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101144'
                WHERE ordernumber = 'P2502140000233' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456020'
                WHERE ordernumber = 'P2502140000235' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358258'
                WHERE ordernumber = 'P2502140000236' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456021'
                WHERE ordernumber = 'P2502140000237' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456022'
                WHERE ordernumber = 'P2502140000239' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141809'
                WHERE ordernumber = 'P2502140000243' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456023'
                WHERE ordernumber = 'P2502140000247' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456024'
                WHERE ordernumber = 'P2502140000248' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383604'
                WHERE ordernumber = 'P2502140000252' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456026'
                WHERE ordernumber = 'P2502140000253' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456027'
                WHERE ordernumber = 'P2502140000254' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143087'
                WHERE ordernumber = 'P2502140000268' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456030'
                WHERE ordernumber = 'P2502140000272' 
            
2025-02-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P2502140000275'