2025-02-07 01:00:02 -- 將會員中心id寫入data-lake
2025-02-07 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 '2025-02-06%';
        
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337926'
                WHERE ordernumber = 'P2502060000008' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269473'
                WHERE ordernumber = 'P2502060000011' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454969'
                WHERE ordernumber = 'P2502060000013' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454970'
                WHERE ordernumber = 'P2502060000017' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400372'
                WHERE ordernumber = 'P2502060000018' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '168878'
                WHERE ordernumber = 'P2502060000020' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '119326'
                WHERE ordernumber = 'P2502060000021' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '453122'
                WHERE ordernumber = 'P2502060000022' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393875'
                WHERE ordernumber = 'P2502060000024' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317433'
                WHERE ordernumber = 'P2502060000027' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385092'
                WHERE ordernumber = 'P2502060000029' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111709'
                WHERE ordernumber = 'P2502060000030' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '451136'
                WHERE ordernumber = 'P2502060000031' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363039'
                WHERE ordernumber = 'P2502060000032' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352298'
                WHERE ordernumber = 'P2502060000033' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454968'
                WHERE ordernumber = 'P2502060000034' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454973'
                WHERE ordernumber = 'P2502060000036' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454968'
                WHERE ordernumber = 'P2502060000037' 
            
2025-02-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95540'
                WHERE ordernumber = 'P2502060000038' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454974'
                WHERE ordernumber = 'P2502060000039' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454976'
                WHERE ordernumber = 'P2502060000046' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454977'
                WHERE ordernumber = 'P2502060000048' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '152005'
                WHERE ordernumber = 'P2502060000050' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454978'
                WHERE ordernumber = 'P2502060000054' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454979'
                WHERE ordernumber = 'P2502060000064' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62458'
                WHERE ordernumber = 'P2502060000067' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380655'
                WHERE ordernumber = 'P2502060000068' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109345'
                WHERE ordernumber = 'P2502060000072' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372465'
                WHERE ordernumber = 'P2502060000074' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375069'
                WHERE ordernumber = 'P2502060000075' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132653'
                WHERE ordernumber = 'P2502060000078' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375069'
                WHERE ordernumber = 'P2502060000080' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454982'
                WHERE ordernumber = 'P2502060000082' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P2502060000085' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '447175'
                WHERE ordernumber = 'P2502060000087' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454984'
                WHERE ordernumber = 'P2502060000088' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454985'
                WHERE ordernumber = 'P2502060000090' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432709'
                WHERE ordernumber = 'P2502060000091' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454986'
                WHERE ordernumber = 'P2502060000094' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454987'
                WHERE ordernumber = 'P2502060000095' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '453512'
                WHERE ordernumber = 'P2502060000098' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338194'
                WHERE ordernumber = 'P2502060000099' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397143'
                WHERE ordernumber = 'P2502060000100' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454989'
                WHERE ordernumber = 'P2502060000105' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394036'
                WHERE ordernumber = 'P2502060000110' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420788'
                WHERE ordernumber = 'P2502060000112' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399816'
                WHERE ordernumber = 'P2502060000114' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454991'
                WHERE ordernumber = 'P2502060000119' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282012'
                WHERE ordernumber = 'P2502060000122' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454992'
                WHERE ordernumber = 'P2502060000125' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425878'
                WHERE ordernumber = 'P2502060000126' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353097'
                WHERE ordernumber = 'P2502060000129' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454599'
                WHERE ordernumber = 'P2502060000130' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454993'
                WHERE ordernumber = 'P2502060000131' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378491'
                WHERE ordernumber = 'P2502060000134' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P2502060000138' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136084'
                WHERE ordernumber = 'P2502060000142' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454995'
                WHERE ordernumber = 'P2502060000152' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454996'
                WHERE ordernumber = 'P2502060000155' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298977'
                WHERE ordernumber = 'P2502060000162' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271601'
                WHERE ordernumber = 'P2502060000163' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454999'
                WHERE ordernumber = 'P2502060000167' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455000'
                WHERE ordernumber = 'P2502060000172' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455002'
                WHERE ordernumber = 'P2502060000176' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455003'
                WHERE ordernumber = 'P2502060000177' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455004'
                WHERE ordernumber = 'P2502060000179' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452598'
                WHERE ordernumber = 'P2502060000186' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455005'
                WHERE ordernumber = 'P2502060000188' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159648'
                WHERE ordernumber = 'P2502060000197' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249748'
                WHERE ordernumber = 'P2502060000198' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455006'
                WHERE ordernumber = 'P2502060000199' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160685'
                WHERE ordernumber = 'P2502060000200' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258867'
                WHERE ordernumber = 'P2502060000201' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391087'
                WHERE ordernumber = 'P2502060000202' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454992'
                WHERE ordernumber = 'P2502060000204' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157203'
                WHERE ordernumber = 'P2502060000207' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110061'
                WHERE ordernumber = 'P2502060000208' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455009'
                WHERE ordernumber = 'P2502060000211' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258964'
                WHERE ordernumber = 'P2502060000214' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345251'
                WHERE ordernumber = 'P2502060000215' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234387'
                WHERE ordernumber = 'P2502060000218' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323621'
                WHERE ordernumber = 'P2502060000234' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455012'
                WHERE ordernumber = 'P2502060000235' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299086'
                WHERE ordernumber = 'P2502060000237' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455013'
                WHERE ordernumber = 'P2502060000239' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100500'
                WHERE ordernumber = 'P2502060000242' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100500'
                WHERE ordernumber = 'P2502060000243' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455014'
                WHERE ordernumber = 'P2502060000246' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236961'
                WHERE ordernumber = 'P2502060000252' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455015'
                WHERE ordernumber = 'P2502060000254' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298871'
                WHERE ordernumber = 'P2502060000256' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118490'
                WHERE ordernumber = 'P2502060000258' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400997'
                WHERE ordernumber = 'P2502060000259' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '445779'
                WHERE ordernumber = 'P2502060000265' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219323'
                WHERE ordernumber = 'P2502060000268' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455016'
                WHERE ordernumber = 'P2502060000279' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377568'
                WHERE ordernumber = 'P2502060000287' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326667'
                WHERE ordernumber = 'P2502060000296' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288045'
                WHERE ordernumber = 'P2502060000298' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394397'
                WHERE ordernumber = 'P2502060000302' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455020'
                WHERE ordernumber = 'P2502060000305' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394397'
                WHERE ordernumber = 'P2502060000308' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442146'
                WHERE ordernumber = 'P2502060000312' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281701'
                WHERE ordernumber = 'P2502060000329' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281701'
                WHERE ordernumber = 'P2502060000330' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455021'
                WHERE ordernumber = 'P2502060000332' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243696'
                WHERE ordernumber = 'P2502060000337' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455022'
                WHERE ordernumber = 'P2502060000339' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455023'
                WHERE ordernumber = 'P2502060000340' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303781'
                WHERE ordernumber = 'P2502060000341' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455024'
                WHERE ordernumber = 'P2502060000347' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454624'
                WHERE ordernumber = 'P2502060000350' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454624'
                WHERE ordernumber = 'P2502060000351' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455025'
                WHERE ordernumber = 'P2502060000353' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455026'
                WHERE ordernumber = 'P2502060000355' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455027'
                WHERE ordernumber = 'P2502060000358' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396477'
                WHERE ordernumber = 'P2502060000363' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96821'
                WHERE ordernumber = 'P2502060000364' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96821'
                WHERE ordernumber = 'P2502060000366' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455029'
                WHERE ordernumber = 'P2502060000369' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455030'
                WHERE ordernumber = 'P2502060000370' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400983'
                WHERE ordernumber = 'P2502060000386' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100454'
                WHERE ordernumber = 'P2502060000387' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455033'
                WHERE ordernumber = 'P2502060000389' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348877'
                WHERE ordernumber = 'P2502060000394' 
            
2025-02-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455033'
                WHERE ordernumber = 'P2502060000396' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208833'
                WHERE ordernumber = 'P2502060000400' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308226'
                WHERE ordernumber = 'P2502060000410' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400538'
                WHERE ordernumber = 'P2502060000413' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213859'
                WHERE ordernumber = 'P2502060000418' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279074'
                WHERE ordernumber = 'P2502060000420' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100094'
                WHERE ordernumber = 'P2502060000422' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291884'
                WHERE ordernumber = 'P2502060000427' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455035'
                WHERE ordernumber = 'P2502060000429' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230870'
                WHERE ordernumber = 'P2502060000431' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455037'
                WHERE ordernumber = 'P2502060000444' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142452'
                WHERE ordernumber = 'P2502060000446' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142452'
                WHERE ordernumber = 'P2502060000447' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455038'
                WHERE ordernumber = 'P2502060000450' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455039'
                WHERE ordernumber = 'P2502060000453' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455040'
                WHERE ordernumber = 'P2502060000456' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455041'
                WHERE ordernumber = 'P2502060000465' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357562'
                WHERE ordernumber = 'P2502060000466' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427039'
                WHERE ordernumber = 'P2502060000471' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442734'
                WHERE ordernumber = 'P2502060000472' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '441699'
                WHERE ordernumber = 'P2502060000479' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455043'
                WHERE ordernumber = 'P2502060000481' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110046'
                WHERE ordernumber = 'P2502060000486' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88985'
                WHERE ordernumber = 'P2502060000487' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113302'
                WHERE ordernumber = 'P2502060000493' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455045'
                WHERE ordernumber = 'P2502060000505' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74302'
                WHERE ordernumber = 'P2502060000512' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320317'
                WHERE ordernumber = 'P2502060000515' 
            
2025-02-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455047'
                WHERE ordernumber = 'P2502060000519'