2025-02-27 01:00:02 -- 將會員中心id寫入data-lake
2025-02-27 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-26%';
        
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458201'
                WHERE ordernumber = 'P2502260000016' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458203'
                WHERE ordernumber = 'P2502260000017' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458202'
                WHERE ordernumber = 'P2502260000018' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438875'
                WHERE ordernumber = 'P2502260000020' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458205'
                WHERE ordernumber = 'P2502260000024' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456630'
                WHERE ordernumber = 'P2502260000025' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253723'
                WHERE ordernumber = 'P2502260000026' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395011'
                WHERE ordernumber = 'P2502260000027' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458206'
                WHERE ordernumber = 'P2502260000028' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261118'
                WHERE ordernumber = 'P2502260000029' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458203'
                WHERE ordernumber = 'P2502260000030' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458207'
                WHERE ordernumber = 'P2502260000032' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213832'
                WHERE ordernumber = 'P2502260000033' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94715'
                WHERE ordernumber = 'P2502260000034' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213832'
                WHERE ordernumber = 'P2502260000035' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458200'
                WHERE ordernumber = 'P2502260000036' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458209'
                WHERE ordernumber = 'P2502260000037' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97753'
                WHERE ordernumber = 'P2502260000038' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395011'
                WHERE ordernumber = 'P2502260000039' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420826'
                WHERE ordernumber = 'P2502260000040' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457662'
                WHERE ordernumber = 'P2502260000041' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P2502260000042' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352006'
                WHERE ordernumber = 'P2502260000044' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458208'
                WHERE ordernumber = 'P2502260000046' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274682'
                WHERE ordernumber = 'P2502260000050' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431283'
                WHERE ordernumber = 'P2502260000056' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P2502260000058' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '158348'
                WHERE ordernumber = 'P2502260000062' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438765'
                WHERE ordernumber = 'P2502260000063' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458194'
                WHERE ordernumber = 'P2502260000065' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458195'
                WHERE ordernumber = 'P2502260000068' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458215'
                WHERE ordernumber = 'P2502260000069' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395273'
                WHERE ordernumber = 'P2502260000070' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458217'
                WHERE ordernumber = 'P2502260000071' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457777'
                WHERE ordernumber = 'P2502260000072' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354688'
                WHERE ordernumber = 'P2502260000073' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390648'
                WHERE ordernumber = 'P2502260000074' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '362809'
                WHERE ordernumber = 'P2502260000079' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2502260000080' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '227696'
                WHERE ordernumber = 'P2502260000083' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458218'
                WHERE ordernumber = 'P2502260000087' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458220'
                WHERE ordernumber = 'P2502260000090' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319052'
                WHERE ordernumber = 'P2502260000094' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458219'
                WHERE ordernumber = 'P2502260000095' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458221'
                WHERE ordernumber = 'P2502260000099' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458222'
                WHERE ordernumber = 'P2502260000103' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101741'
                WHERE ordernumber = 'P2502260000104' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458214'
                WHERE ordernumber = 'P2502260000108' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458214'
                WHERE ordernumber = 'P2502260000110' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433349'
                WHERE ordernumber = 'P2502260000111' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458223'
                WHERE ordernumber = 'P2502260000114' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458224'
                WHERE ordernumber = 'P2502260000116' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216944'
                WHERE ordernumber = 'P2502260000119' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277920'
                WHERE ordernumber = 'P2502260000131' 
            
2025-02-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '458227'
                WHERE ordernumber = 'P2502260000135' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171583'
                WHERE ordernumber = 'P2502260000137' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458173'
                WHERE ordernumber = 'P2502260000138' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169'
                WHERE ordernumber = 'P2502260000144' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117187'
                WHERE ordernumber = 'P2502260000146' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359025'
                WHERE ordernumber = 'P2502260000147' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281379'
                WHERE ordernumber = 'P2502260000149' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458231'
                WHERE ordernumber = 'P2502260000150' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458173'
                WHERE ordernumber = 'P2502260000152' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435311'
                WHERE ordernumber = 'P2502260000156' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425240'
                WHERE ordernumber = 'P2502260000158' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93659'
                WHERE ordernumber = 'P2502260000160' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458232'
                WHERE ordernumber = 'P2502260000161' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458233'
                WHERE ordernumber = 'P2502260000164' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171872'
                WHERE ordernumber = 'P2502260000167' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458235'
                WHERE ordernumber = 'P2502260000169' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299101'
                WHERE ordernumber = 'P2502260000171' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458234'
                WHERE ordernumber = 'P2502260000172' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458236'
                WHERE ordernumber = 'P2502260000173' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458237'
                WHERE ordernumber = 'P2502260000174' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458238'
                WHERE ordernumber = 'P2502260000177' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458239'
                WHERE ordernumber = 'P2502260000178' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458240'
                WHERE ordernumber = 'P2502260000179' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458229'
                WHERE ordernumber = 'P2502260000180' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223258'
                WHERE ordernumber = 'P2502260000182' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400901'
                WHERE ordernumber = 'P2502260000184' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458241'
                WHERE ordernumber = 'P2502260000187' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231406'
                WHERE ordernumber = 'P2502260000188' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429666'
                WHERE ordernumber = 'P2502260000190' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231406'
                WHERE ordernumber = 'P2502260000191' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458245'
                WHERE ordernumber = 'P2502260000199' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458246'
                WHERE ordernumber = 'P2502260000204' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454928'
                WHERE ordernumber = 'P2502260000208' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215043'
                WHERE ordernumber = 'P2502260000209' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458070'
                WHERE ordernumber = 'P2502260000210' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457997'
                WHERE ordernumber = 'P2502260000212' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458247'
                WHERE ordernumber = 'P2502260000213' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457283'
                WHERE ordernumber = 'P2502260000214' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458249'
                WHERE ordernumber = 'P2502260000221' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458249'
                WHERE ordernumber = 'P2502260000226' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458250'
                WHERE ordernumber = 'P2502260000231' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458251'
                WHERE ordernumber = 'P2502260000235' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228189'
                WHERE ordernumber = 'P2502260000236' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455492'
                WHERE ordernumber = 'P2502260000240' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458254'
                WHERE ordernumber = 'P2502260000242' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458255'
                WHERE ordernumber = 'P2502260000244' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432842'
                WHERE ordernumber = 'P2502260000245' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458256'
                WHERE ordernumber = 'P2502260000246' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458257'
                WHERE ordernumber = 'P2502260000249' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307996'
                WHERE ordernumber = 'P2502260000250' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458259'
                WHERE ordernumber = 'P2502260000254' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432369'
                WHERE ordernumber = 'P2502260000257' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349821'
                WHERE ordernumber = 'P2502260000258' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335311'
                WHERE ordernumber = 'P2502260000261' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302957'
                WHERE ordernumber = 'P2502260000263' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458261'
                WHERE ordernumber = 'P2502260000264' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458263'
                WHERE ordernumber = 'P2502260000265' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458262'
                WHERE ordernumber = 'P2502260000267' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94028'
                WHERE ordernumber = 'P2502260000268' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458262'
                WHERE ordernumber = 'P2502260000269' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458265'
                WHERE ordernumber = 'P2502260000270' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241084'
                WHERE ordernumber = 'P2502260000271' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458266'
                WHERE ordernumber = 'P2502260000273' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458267'
                WHERE ordernumber = 'P2502260000274' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97041'
                WHERE ordernumber = 'P2502260000276' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344238'
                WHERE ordernumber = 'P2502260000279' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458244'
                WHERE ordernumber = 'P2502260000280' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458268'
                WHERE ordernumber = 'P2502260000283' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276074'
                WHERE ordernumber = 'P2502260000284' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458269'
                WHERE ordernumber = 'P2502260000285' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98323'
                WHERE ordernumber = 'P2502260000288' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98323'
                WHERE ordernumber = 'P2502260000290' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '451212'
                WHERE ordernumber = 'P2502260000291' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458263'
                WHERE ordernumber = 'P2502260000293' 
            
2025-02-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454896'
                WHERE ordernumber = 'P2502260000295' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458193'
                WHERE ordernumber = 'P2502260000296' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458269'
                WHERE ordernumber = 'P2502260000298' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458272'
                WHERE ordernumber = 'P2502260000299' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381869'
                WHERE ordernumber = 'P2502260000300' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458270'
                WHERE ordernumber = 'P2502260000301' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458273'
                WHERE ordernumber = 'P2502260000302' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101517'
                WHERE ordernumber = 'P2502260000303' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '442593'
                WHERE ordernumber = 'P2502260000305' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349196'
                WHERE ordernumber = 'P2502260000307' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458275'
                WHERE ordernumber = 'P2502260000309' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81316'
                WHERE ordernumber = 'P2502260000310' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396453'
                WHERE ordernumber = 'P2502260000311' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283250'
                WHERE ordernumber = 'P2502260000313' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342821'
                WHERE ordernumber = 'P2502260000314' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458271'
                WHERE ordernumber = 'P2502260000315' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421873'
                WHERE ordernumber = 'P2502260000316' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458276'
                WHERE ordernumber = 'P2502260000318' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458277'
                WHERE ordernumber = 'P2502260000319' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '448851'
                WHERE ordernumber = 'P2502260000320' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458278'
                WHERE ordernumber = 'P2502260000321' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346065'
                WHERE ordernumber = 'P2502260000322' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457941'
                WHERE ordernumber = 'P2502260000325' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349740'
                WHERE ordernumber = 'P2502260000326' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '448415'
                WHERE ordernumber = 'P2502260000329' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458279'
                WHERE ordernumber = 'P2502260000332' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458280'
                WHERE ordernumber = 'P2502260000333' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458279'
                WHERE ordernumber = 'P2502260000334' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240384'
                WHERE ordernumber = 'P2502260000335' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458282'
                WHERE ordernumber = 'P2502260000336' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458281'
                WHERE ordernumber = 'P2502260000337' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392021'
                WHERE ordernumber = 'P2502260000339' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458283'
                WHERE ordernumber = 'P2502260000343' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455749'
                WHERE ordernumber = 'P2502260000351' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268429'
                WHERE ordernumber = 'P2502260000352' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458284'
                WHERE ordernumber = 'P2502260000354' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372405'
                WHERE ordernumber = 'P2502260000355' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '47324'
                WHERE ordernumber = 'P2502260000364' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343266'
                WHERE ordernumber = 'P2502260000367' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317043'
                WHERE ordernumber = 'P2502260000371' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298942'
                WHERE ordernumber = 'P2502260000373' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167176'
                WHERE ordernumber = 'P2502260000379' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458285'
                WHERE ordernumber = 'P2502260000380' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272565'
                WHERE ordernumber = 'P2502260000381' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167176'
                WHERE ordernumber = 'P2502260000382' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458288'
                WHERE ordernumber = 'P2502260000384' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458289'
                WHERE ordernumber = 'P2502260000386' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250027'
                WHERE ordernumber = 'P2502260000387' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437562'
                WHERE ordernumber = 'P2502260000388' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458287'
                WHERE ordernumber = 'P2502260000390' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458289'
                WHERE ordernumber = 'P2502260000392' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433397'
                WHERE ordernumber = 'P2502260000395' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433397'
                WHERE ordernumber = 'P2502260000397' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326230'
                WHERE ordernumber = 'P2502260000401' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103227'
                WHERE ordernumber = 'P2502260000404' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458290'
                WHERE ordernumber = 'P2502260000406' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458290'
                WHERE ordernumber = 'P2502260000407' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363042'
                WHERE ordernumber = 'P2502260000409' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457535'
                WHERE ordernumber = 'P2502260000412' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423397'
                WHERE ordernumber = 'P2502260000417' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93633'
                WHERE ordernumber = 'P2502260000420' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322480'
                WHERE ordernumber = 'P2502260000423' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210678'
                WHERE ordernumber = 'P2502260000425' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '454873'
                WHERE ordernumber = 'P2502260000426' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339326'
                WHERE ordernumber = 'P2502260000428' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102249'
                WHERE ordernumber = 'P2502260000432' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458076'
                WHERE ordernumber = 'P2502260000433' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102020'
                WHERE ordernumber = 'P2502260000436' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295253'
                WHERE ordernumber = 'P2502260000439' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458293'
                WHERE ordernumber = 'P2502260000442' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165405'
                WHERE ordernumber = 'P2502260000444' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443081'
                WHERE ordernumber = 'P2502260000449' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396617'
                WHERE ordernumber = 'P2502260000450' 
            
2025-02-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219671'
                WHERE ordernumber = 'P2502260000451' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364609'
                WHERE ordernumber = 'P2502260000453' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458298'
                WHERE ordernumber = 'P2502260000454' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458299'
                WHERE ordernumber = 'P2502260000457' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458300'
                WHERE ordernumber = 'P2502260000459' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458301'
                WHERE ordernumber = 'P2502260000461' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458302'
                WHERE ordernumber = 'P2502260000463' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458300'
                WHERE ordernumber = 'P2502260000465' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458304'
                WHERE ordernumber = 'P2502260000467' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458303'
                WHERE ordernumber = 'P2502260000469' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458305'
                WHERE ordernumber = 'P2502260000473' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P2502260000474' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458306'
                WHERE ordernumber = 'P2502260000475' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263388'
                WHERE ordernumber = 'P2502260000478' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458304'
                WHERE ordernumber = 'P2502260000481' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297112'
                WHERE ordernumber = 'P2502260000482' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94028'
                WHERE ordernumber = 'P2502260000484' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374403'
                WHERE ordernumber = 'P2502260000487' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '434342'
                WHERE ordernumber = 'P2502260000488' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458308'
                WHERE ordernumber = 'P2502260000490' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457420'
                WHERE ordernumber = 'P2502260000492' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458294'
                WHERE ordernumber = 'P2502260000493' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '117852'
                WHERE ordernumber = 'P2502260000495' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397252'
                WHERE ordernumber = 'P2502260000496' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458309'
                WHERE ordernumber = 'P2502260000498' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458307'
                WHERE ordernumber = 'P2502260000501' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458310'
                WHERE ordernumber = 'P2502260000505' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249382'
                WHERE ordernumber = 'P2502260000507' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458311'
                WHERE ordernumber = 'P2502260000508' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288624'
                WHERE ordernumber = 'P2502260000510' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415741'
                WHERE ordernumber = 'P2502260000511' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '223076'
                WHERE ordernumber = 'P2502260000515' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458312'
                WHERE ordernumber = 'P2502260000517' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288170'
                WHERE ordernumber = 'P2502260000520' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '168328'
                WHERE ordernumber = 'P2502260000522' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458316'
                WHERE ordernumber = 'P2502260000524' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458317'
                WHERE ordernumber = 'P2502260000525' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393336'
                WHERE ordernumber = 'P2502260000527' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419587'
                WHERE ordernumber = 'P2502260000529' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305165'
                WHERE ordernumber = 'P2502260000530' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458319'
                WHERE ordernumber = 'P2502260000531' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458314'
                WHERE ordernumber = 'P2502260000533' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311300'
                WHERE ordernumber = 'P2502260000534' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458318'
                WHERE ordernumber = 'P2502260000536' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458320'
                WHERE ordernumber = 'P2502260000537' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345808'
                WHERE ordernumber = 'P2502260000538' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458314'
                WHERE ordernumber = 'P2502260000540' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383373'
                WHERE ordernumber = 'P2502260000543' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458321'
                WHERE ordernumber = 'P2502260000546' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458322'
                WHERE ordernumber = 'P2502260000548' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458323'
                WHERE ordernumber = 'P2502260000549' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '433234'
                WHERE ordernumber = 'P2502260000551' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455347'
                WHERE ordernumber = 'P2502260000556' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '265715'
                WHERE ordernumber = 'P2502260000559' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458324'
                WHERE ordernumber = 'P2502260000561' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365633'
                WHERE ordernumber = 'P2502260000564' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458325'
                WHERE ordernumber = 'P2502260000565' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '179349'
                WHERE ordernumber = 'P2502260000566' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457684'
                WHERE ordernumber = 'P2502260000568' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390504'
                WHERE ordernumber = 'P2502260000570' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96897'
                WHERE ordernumber = 'P2502260000576' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453859'
                WHERE ordernumber = 'P2502260000577' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458326'
                WHERE ordernumber = 'P2502260000578' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458327'
                WHERE ordernumber = 'P2502260000580' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '259727'
                WHERE ordernumber = 'P2502260000581' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458328'
                WHERE ordernumber = 'P2502260000584' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458329'
                WHERE ordernumber = 'P2502260000585' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457422'
                WHERE ordernumber = 'P2502260000587' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '250431'
                WHERE ordernumber = 'P2502260000589' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343179'
                WHERE ordernumber = 'P2502260000590' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458331'
                WHERE ordernumber = 'P2502260000593' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '375253'
                WHERE ordernumber = 'P2502260000596' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '140829'
                WHERE ordernumber = 'P2502260000597' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398700'
                WHERE ordernumber = 'P2502260000601' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458332'
                WHERE ordernumber = 'P2502260000603' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458330'
                WHERE ordernumber = 'P2502260000604' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '134365'
                WHERE ordernumber = 'P2502260000607' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458333'
                WHERE ordernumber = 'P2502260000608' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458334'
                WHERE ordernumber = 'P2502260000610' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '127235'
                WHERE ordernumber = 'P2502260000611' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '239021'
                WHERE ordernumber = 'P2502260000612' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458335'
                WHERE ordernumber = 'P2502260000615' 
            
2025-02-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '458334'
                WHERE ordernumber = 'P2502260000617'