2025-03-07 01:00:02 -- 將會員中心id寫入data-lake
2025-03-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-03-06%';
        
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421456'
                WHERE ordernumber = 'P2503060000010' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113474'
                WHERE ordernumber = 'P2503060000011' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311342'
                WHERE ordernumber = 'P2503060000013' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263779'
                WHERE ordernumber = 'P2503060000015' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '66891'
                WHERE ordernumber = 'P2503060000016' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459623'
                WHERE ordernumber = 'P2503060000017' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305535'
                WHERE ordernumber = 'P2503060000018' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457368'
                WHERE ordernumber = 'P2503060000019' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346324'
                WHERE ordernumber = 'P2503060000020' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459624'
                WHERE ordernumber = 'P2503060000022' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459625'
                WHERE ordernumber = 'P2503060000023' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459626'
                WHERE ordernumber = 'P2503060000025' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459627'
                WHERE ordernumber = 'P2503060000026' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '203673'
                WHERE ordernumber = 'P2503060000029' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '163180'
                WHERE ordernumber = 'P2503060000031' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '46042'
                WHERE ordernumber = 'P2503060000032' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '447324'
                WHERE ordernumber = 'P2503060000035' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459628'
                WHERE ordernumber = 'P2503060000037' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P2503060000042' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459630'
                WHERE ordernumber = 'P2503060000043' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459632'
                WHERE ordernumber = 'P2503060000044' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406463'
                WHERE ordernumber = 'P2503060000046' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P2503060000049' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113932'
                WHERE ordernumber = 'P2503060000053' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459634'
                WHERE ordernumber = 'P2503060000055' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347213'
                WHERE ordernumber = 'P2503060000060' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429564'
                WHERE ordernumber = 'P2503060000062' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '181788'
                WHERE ordernumber = 'P2503060000067' 
            
2025-03-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346597'
                WHERE ordernumber = 'P2503060000069' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P2503060000072' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459636'
                WHERE ordernumber = 'P2503060000074' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459637'
                WHERE ordernumber = 'P2503060000076' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383183'
                WHERE ordernumber = 'P2503060000078' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289921'
                WHERE ordernumber = 'P2503060000080' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458055'
                WHERE ordernumber = 'P2503060000082' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94626'
                WHERE ordernumber = 'P2503060000084' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459638'
                WHERE ordernumber = 'P2503060000085' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281823'
                WHERE ordernumber = 'P2503060000087' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459639'
                WHERE ordernumber = 'P2503060000088' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233529'
                WHERE ordernumber = 'P2503060000090' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459640'
                WHERE ordernumber = 'P2503060000094' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206819'
                WHERE ordernumber = 'P2503060000103' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459641'
                WHERE ordernumber = 'P2503060000108' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459642'
                WHERE ordernumber = 'P2503060000113' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268816'
                WHERE ordernumber = 'P2503060000114' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2503060000119' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459643'
                WHERE ordernumber = 'P2503060000122' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223138'
                WHERE ordernumber = 'P2503060000123' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279802'
                WHERE ordernumber = 'P2503060000124' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292758'
                WHERE ordernumber = 'P2503060000128' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459646'
                WHERE ordernumber = 'P2503060000140' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '453442'
                WHERE ordernumber = 'P2503060000144' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432274'
                WHERE ordernumber = 'P2503060000146' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459648'
                WHERE ordernumber = 'P2503060000152' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341246'
                WHERE ordernumber = 'P2503060000153' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162718'
                WHERE ordernumber = 'P2503060000158' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459649'
                WHERE ordernumber = 'P2503060000159' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459650'
                WHERE ordernumber = 'P2503060000160' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300170'
                WHERE ordernumber = 'P2503060000164' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136864'
                WHERE ordernumber = 'P2503060000166' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459651'
                WHERE ordernumber = 'P2503060000170' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459652'
                WHERE ordernumber = 'P2503060000174' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212534'
                WHERE ordernumber = 'P2503060000175' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452051'
                WHERE ordernumber = 'P2503060000176' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459653'
                WHERE ordernumber = 'P2503060000177' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '77512'
                WHERE ordernumber = 'P2503060000178' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459654'
                WHERE ordernumber = 'P2503060000180' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457997'
                WHERE ordernumber = 'P2503060000185' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459655'
                WHERE ordernumber = 'P2503060000186' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459656'
                WHERE ordernumber = 'P2503060000189' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459657'
                WHERE ordernumber = 'P2503060000196' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431970'
                WHERE ordernumber = 'P2503060000198' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459658'
                WHERE ordernumber = 'P2503060000200' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285229'
                WHERE ordernumber = 'P2503060000201' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459659'
                WHERE ordernumber = 'P2503060000202' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459660'
                WHERE ordernumber = 'P2503060000203' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285229'
                WHERE ordernumber = 'P2503060000204' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252127'
                WHERE ordernumber = 'P2503060000206' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270609'
                WHERE ordernumber = 'P2503060000208' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459662'
                WHERE ordernumber = 'P2503060000209' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217757'
                WHERE ordernumber = 'P2503060000212' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459664'
                WHERE ordernumber = 'P2503060000214' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397019'
                WHERE ordernumber = 'P2503060000215' 
            
2025-03-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459665'
                WHERE ordernumber = 'P2503060000218' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303987'
                WHERE ordernumber = 'P2503060000221' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459666'
                WHERE ordernumber = 'P2503060000222' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273785'
                WHERE ordernumber = 'P2503060000228' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317521'
                WHERE ordernumber = 'P2503060000229' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '450734'
                WHERE ordernumber = 'P2503060000233' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343620'
                WHERE ordernumber = 'P2503060000235' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453146'
                WHERE ordernumber = 'P2503060000236' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459668'
                WHERE ordernumber = 'P2503060000238' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459667'
                WHERE ordernumber = 'P2503060000239' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '454991'
                WHERE ordernumber = 'P2503060000240' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391984'
                WHERE ordernumber = 'P2503060000242' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '85243'
                WHERE ordernumber = 'P2503060000243' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459670'
                WHERE ordernumber = 'P2503060000244' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459669'
                WHERE ordernumber = 'P2503060000245' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459669'
                WHERE ordernumber = 'P2503060000246' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348437'
                WHERE ordernumber = 'P2503060000249' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '78136'
                WHERE ordernumber = 'P2503060000250' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459672'
                WHERE ordernumber = 'P2503060000252' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459671'
                WHERE ordernumber = 'P2503060000254' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323666'
                WHERE ordernumber = 'P2503060000259' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459673'
                WHERE ordernumber = 'P2503060000261' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459674'
                WHERE ordernumber = 'P2503060000263' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459675'
                WHERE ordernumber = 'P2503060000262' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459677'
                WHERE ordernumber = 'P2503060000269' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459676'
                WHERE ordernumber = 'P2503060000270' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284057'
                WHERE ordernumber = 'P2503060000271' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459678'
                WHERE ordernumber = 'P2503060000272' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459681'
                WHERE ordernumber = 'P2503060000274' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459679'
                WHERE ordernumber = 'P2503060000275' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285587'
                WHERE ordernumber = 'P2503060000276' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278105'
                WHERE ordernumber = 'P2503060000277' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240748'
                WHERE ordernumber = 'P2503060000278' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459682'
                WHERE ordernumber = 'P2503060000279' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '84936'
                WHERE ordernumber = 'P2503060000280' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459683'
                WHERE ordernumber = 'P2503060000286' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2503060000287' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459684'
                WHERE ordernumber = 'P2503060000292' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459686'
                WHERE ordernumber = 'P2503060000294' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459684'
                WHERE ordernumber = 'P2503060000295' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243812'
                WHERE ordernumber = 'P2503060000299' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232152'
                WHERE ordernumber = 'P2503060000300' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395522'
                WHERE ordernumber = 'P2503060000302' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380944'
                WHERE ordernumber = 'P2503060000304' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386512'
                WHERE ordernumber = 'P2503060000306' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459687'
                WHERE ordernumber = 'P2503060000309' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388070'
                WHERE ordernumber = 'P2503060000312' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459688'
                WHERE ordernumber = 'P2503060000317' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459690'
                WHERE ordernumber = 'P2503060000326' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459691'
                WHERE ordernumber = 'P2503060000328' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457062'
                WHERE ordernumber = 'P2503060000331' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459692'
                WHERE ordernumber = 'P2503060000333' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459693'
                WHERE ordernumber = 'P2503060000335' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458980'
                WHERE ordernumber = 'P2503060000337' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216932'
                WHERE ordernumber = 'P2503060000338' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459694'
                WHERE ordernumber = 'P2503060000341' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459695'
                WHERE ordernumber = 'P2503060000344' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459696'
                WHERE ordernumber = 'P2503060000347' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459699'
                WHERE ordernumber = 'P2503060000349' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264596'
                WHERE ordernumber = 'P2503060000351' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137020'
                WHERE ordernumber = 'P2503060000354' 
            
2025-03-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '145397'
                WHERE ordernumber = 'P2503060000357' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364943'
                WHERE ordernumber = 'P2503060000359' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '158668'
                WHERE ordernumber = 'P2503060000364' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459702'
                WHERE ordernumber = 'P2503060000366' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459703'
                WHERE ordernumber = 'P2503060000368' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459704'
                WHERE ordernumber = 'P2503060000371' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459700'
                WHERE ordernumber = 'P2503060000377' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303066'
                WHERE ordernumber = 'P2503060000379' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421879'
                WHERE ordernumber = 'P2503060000382' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '112218'
                WHERE ordernumber = 'P2503060000383' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459705'
                WHERE ordernumber = 'P2503060000384' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '112218'
                WHERE ordernumber = 'P2503060000386' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430749'
                WHERE ordernumber = 'P2503060000390' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388070'
                WHERE ordernumber = 'P2503060000391' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459708'
                WHERE ordernumber = 'P2503060000392' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '140451'
                WHERE ordernumber = 'P2503060000394' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303066'
                WHERE ordernumber = 'P2503060000395' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459710'
                WHERE ordernumber = 'P2503060000397' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300227'
                WHERE ordernumber = 'P2503060000398' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459712'
                WHERE ordernumber = 'P2503060000400' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459714'
                WHERE ordernumber = 'P2503060000402' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455047'
                WHERE ordernumber = 'P2503060000403' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '720'
                WHERE ordernumber = 'P2503060000405' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458320'
                WHERE ordernumber = 'P2503060000409' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459718'
                WHERE ordernumber = 'P2503060000412' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '172513'
                WHERE ordernumber = 'P2503060000413' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '255629'
                WHERE ordernumber = 'P2503060000414' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459719'
                WHERE ordernumber = 'P2503060000423' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459720'
                WHERE ordernumber = 'P2503060000424' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459721'
                WHERE ordernumber = 'P2503060000425' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459722'
                WHERE ordernumber = 'P2503060000426' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319052'
                WHERE ordernumber = 'P2503060000433' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276758'
                WHERE ordernumber = 'P2503060000435' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298460'
                WHERE ordernumber = 'P2503060000436' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459723'
                WHERE ordernumber = 'P2503060000438' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459724'
                WHERE ordernumber = 'P2503060000440' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377528'
                WHERE ordernumber = 'P2503060000441' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459722'
                WHERE ordernumber = 'P2503060000442' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459725'
                WHERE ordernumber = 'P2503060000445' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '450249'
                WHERE ordernumber = 'P2503060000446' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128914'
                WHERE ordernumber = 'P2503060000447' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459726'
                WHERE ordernumber = 'P2503060000448' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P2503060000453' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '448005'
                WHERE ordernumber = 'P2503060000459' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459728'
                WHERE ordernumber = 'P2503060000461' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390006'
                WHERE ordernumber = 'P2503060000462' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459729'
                WHERE ordernumber = 'P2503060000463' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459731'
                WHERE ordernumber = 'P2503060000467' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459732'
                WHERE ordernumber = 'P2503060000469' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426679'
                WHERE ordernumber = 'P2503060000471' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459477'
                WHERE ordernumber = 'P2503060000476' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275289'
                WHERE ordernumber = 'P2503060000477' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459733'
                WHERE ordernumber = 'P2503060000478' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292048'
                WHERE ordernumber = 'P2503060000483' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459735'
                WHERE ordernumber = 'P2503060000485' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459736'
                WHERE ordernumber = 'P2503060000486' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275063'
                WHERE ordernumber = 'P2503060000488' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459737'
                WHERE ordernumber = 'P2503060000489' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459740'
                WHERE ordernumber = 'P2503060000492' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459739'
                WHERE ordernumber = 'P2503060000493' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459741'
                WHERE ordernumber = 'P2503060000495' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457720'
                WHERE ordernumber = 'P2503060000499' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459744'
                WHERE ordernumber = 'P2503060000501' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350531'
                WHERE ordernumber = 'P2503060000505' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '361478'
                WHERE ordernumber = 'P2503060000507' 
            
2025-03-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459747'
                WHERE ordernumber = 'P2503060000510'