2025-03-03 01:00:02 -- 將會員中心id寫入data-lake
2025-03-03 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-02%';
        
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110048'
                WHERE ordernumber = 'P2503020000013' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96240'
                WHERE ordernumber = 'P2503020000017' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459053'
                WHERE ordernumber = 'P2503020000018' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286322'
                WHERE ordernumber = 'P2503020000019' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '159951'
                WHERE ordernumber = 'P2503020000022' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154788'
                WHERE ordernumber = 'P2503020000023' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142114'
                WHERE ordernumber = 'P2503020000030' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459054'
                WHERE ordernumber = 'P2503020000033' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457677'
                WHERE ordernumber = 'P2503020000035' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457677'
                WHERE ordernumber = 'P2503020000036' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459057'
                WHERE ordernumber = 'P2503020000042' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459058'
                WHERE ordernumber = 'P2503020000044' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459060'
                WHERE ordernumber = 'P2503020000046' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459061'
                WHERE ordernumber = 'P2503020000048' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459062'
                WHERE ordernumber = 'P2503020000049' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395522'
                WHERE ordernumber = 'P2503020000050' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459063'
                WHERE ordernumber = 'P2503020000052' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '295443'
                WHERE ordernumber = 'P2503020000053' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459064'
                WHERE ordernumber = 'P2503020000054' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459065'
                WHERE ordernumber = 'P2503020000056' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329752'
                WHERE ordernumber = 'P2503020000057' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '11242'
                WHERE ordernumber = 'P2503020000059' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123357'
                WHERE ordernumber = 'P2503020000061' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328429'
                WHERE ordernumber = 'P2503020000063' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '454097'
                WHERE ordernumber = 'P2503020000070' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459066'
                WHERE ordernumber = 'P2503020000071' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459067'
                WHERE ordernumber = 'P2503020000076' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459068'
                WHERE ordernumber = 'P2503020000079' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459069'
                WHERE ordernumber = 'P2503020000080' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280986'
                WHERE ordernumber = 'P2503020000081' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228801'
                WHERE ordernumber = 'P2503020000082' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244072'
                WHERE ordernumber = 'P2503020000084' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '441652'
                WHERE ordernumber = 'P2503020000086' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459070'
                WHERE ordernumber = 'P2503020000087' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100823'
                WHERE ordernumber = 'P2503020000089' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459071'
                WHERE ordernumber = 'P2503020000091' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246128'
                WHERE ordernumber = 'P2503020000095' 
            
2025-03-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459073'
                WHERE ordernumber = 'P2503020000097' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242026'
                WHERE ordernumber = 'P2503020000098' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459074'
                WHERE ordernumber = 'P2503020000100' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312199'
                WHERE ordernumber = 'P2503020000101' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459075'
                WHERE ordernumber = 'P2503020000102' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459076'
                WHERE ordernumber = 'P2503020000103' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325183'
                WHERE ordernumber = 'P2503020000108' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135816'
                WHERE ordernumber = 'P2503020000110' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361182'
                WHERE ordernumber = 'P2503020000113' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459077'
                WHERE ordernumber = 'P2503020000115' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459078'
                WHERE ordernumber = 'P2503020000118' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459079'
                WHERE ordernumber = 'P2503020000123' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459080'
                WHERE ordernumber = 'P2503020000127' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459081'
                WHERE ordernumber = 'P2503020000129' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456311'
                WHERE ordernumber = 'P2503020000133' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459083'
                WHERE ordernumber = 'P2503020000135' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367377'
                WHERE ordernumber = 'P2503020000136' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459084'
                WHERE ordernumber = 'P2503020000137' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459085'
                WHERE ordernumber = 'P2503020000142' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280957'
                WHERE ordernumber = 'P2503020000144' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459086'
                WHERE ordernumber = 'P2503020000147' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459087'
                WHERE ordernumber = 'P2503020000148' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459090'
                WHERE ordernumber = 'P2503020000154' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458191'
                WHERE ordernumber = 'P2503020000156' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316889'
                WHERE ordernumber = 'P2503020000158' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '449777'
                WHERE ordernumber = 'P2503020000159' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459091'
                WHERE ordernumber = 'P2503020000162' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '52250'
                WHERE ordernumber = 'P2503020000169' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459092'
                WHERE ordernumber = 'P2503020000170' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459093'
                WHERE ordernumber = 'P2503020000171' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343385'
                WHERE ordernumber = 'P2503020000172' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459094'
                WHERE ordernumber = 'P2503020000173' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459088'
                WHERE ordernumber = 'P2503020000174' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459098'
                WHERE ordernumber = 'P2503020000179' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459095'
                WHERE ordernumber = 'P2503020000181' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459096'
                WHERE ordernumber = 'P2503020000183' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326611'
                WHERE ordernumber = 'P2503020000186' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128589'
                WHERE ordernumber = 'P2503020000187' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231153'
                WHERE ordernumber = 'P2503020000188' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459099'
                WHERE ordernumber = 'P2503020000191' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459100'
                WHERE ordernumber = 'P2503020000192' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231153'
                WHERE ordernumber = 'P2503020000194' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459101'
                WHERE ordernumber = 'P2503020000197' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459102'
                WHERE ordernumber = 'P2503020000201' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459103'
                WHERE ordernumber = 'P2503020000202' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404194'
                WHERE ordernumber = 'P2503020000206' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459105'
                WHERE ordernumber = 'P2503020000209' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384096'
                WHERE ordernumber = 'P2503020000210' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459105'
                WHERE ordernumber = 'P2503020000211' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459106'
                WHERE ordernumber = 'P2503020000214' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459108'
                WHERE ordernumber = 'P2503020000215' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101456'
                WHERE ordernumber = 'P2503020000216' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459109'
                WHERE ordernumber = 'P2503020000217' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459110'
                WHERE ordernumber = 'P2503020000220' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459111'
                WHERE ordernumber = 'P2503020000223' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459112'
                WHERE ordernumber = 'P2503020000224' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459083'
                WHERE ordernumber = 'P2503020000228' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283924'
                WHERE ordernumber = 'P2503020000236' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459115'
                WHERE ordernumber = 'P2503020000245' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459114'
                WHERE ordernumber = 'P2503020000246' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459116'
                WHERE ordernumber = 'P2503020000249' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459117'
                WHERE ordernumber = 'P2503020000252' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230861'
                WHERE ordernumber = 'P2503020000253' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459118'
                WHERE ordernumber = 'P2503020000255' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459119'
                WHERE ordernumber = 'P2503020000256' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459121'
                WHERE ordernumber = 'P2503020000257' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459123'
                WHERE ordernumber = 'P2503020000267' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363106'
                WHERE ordernumber = 'P2503020000268' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459124'
                WHERE ordernumber = 'P2503020000269' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459125'
                WHERE ordernumber = 'P2503020000273' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207452'
                WHERE ordernumber = 'P2503020000275' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459126'
                WHERE ordernumber = 'P2503020000276' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459127'
                WHERE ordernumber = 'P2503020000279' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459128'
                WHERE ordernumber = 'P2503020000285' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252126'
                WHERE ordernumber = 'P2503020000288' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390116'
                WHERE ordernumber = 'P2503020000289' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406754'
                WHERE ordernumber = 'P2503020000292' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455030'
                WHERE ordernumber = 'P2503020000297' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459130'
                WHERE ordernumber = 'P2503020000298' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459129'
                WHERE ordernumber = 'P2503020000301' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235105'
                WHERE ordernumber = 'P2503020000305' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459131'
                WHERE ordernumber = 'P2503020000307' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357187'
                WHERE ordernumber = 'P2503020000310' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459132'
                WHERE ordernumber = 'P2503020000315' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125653'
                WHERE ordernumber = 'P2503020000318' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222289'
                WHERE ordernumber = 'P2503020000319' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376510'
                WHERE ordernumber = 'P2503020000320' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117640'
                WHERE ordernumber = 'P2503020000321' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245624'
                WHERE ordernumber = 'P2503020000323' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459135'
                WHERE ordernumber = 'P2503020000324' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459136'
                WHERE ordernumber = 'P2503020000325' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459138'
                WHERE ordernumber = 'P2503020000327' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459140'
                WHERE ordernumber = 'P2503020000328' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459141'
                WHERE ordernumber = 'P2503020000329' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430793'
                WHERE ordernumber = 'P2503020000331' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92802'
                WHERE ordernumber = 'P2503020000332' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403634'
                WHERE ordernumber = 'P2503020000333' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401353'
                WHERE ordernumber = 'P2503020000334' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456961'
                WHERE ordernumber = 'P2503020000336' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100451'
                WHERE ordernumber = 'P2503020000343' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459050'
                WHERE ordernumber = 'P2503020000344' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459144'
                WHERE ordernumber = 'P2503020000345' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459142'
                WHERE ordernumber = 'P2503020000346' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459145'
                WHERE ordernumber = 'P2503020000347' 
            
2025-03-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459139'
                WHERE ordernumber = 'P2503020000349' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459137'
                WHERE ordernumber = 'P2503020000352' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399585'
                WHERE ordernumber = 'P2503020000353' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352122'
                WHERE ordernumber = 'P2503020000356' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459147'
                WHERE ordernumber = 'P2503020000360' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337993'
                WHERE ordernumber = 'P2503020000361' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221949'
                WHERE ordernumber = 'P2503020000364' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347080'
                WHERE ordernumber = 'P2503020000365' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433762'
                WHERE ordernumber = 'P2503020000367' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459151'
                WHERE ordernumber = 'P2503020000368' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389004'
                WHERE ordernumber = 'P2503020000369' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459152'
                WHERE ordernumber = 'P2503020000370' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459153'
                WHERE ordernumber = 'P2503020000372' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96631'
                WHERE ordernumber = 'P2503020000374' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459154'
                WHERE ordernumber = 'P2503020000375' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '134258'
                WHERE ordernumber = 'P2503020000376' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457511'
                WHERE ordernumber = 'P2503020000378' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459155'
                WHERE ordernumber = 'P2503020000379' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '441099'
                WHERE ordernumber = 'P2503020000384' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459156'
                WHERE ordernumber = 'P2503020000386' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318695'
                WHERE ordernumber = 'P2503020000388' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459157'
                WHERE ordernumber = 'P2503020000390' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459158'
                WHERE ordernumber = 'P2503020000397' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433956'
                WHERE ordernumber = 'P2503020000400' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459160'
                WHERE ordernumber = 'P2503020000403' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459161'
                WHERE ordernumber = 'P2503020000405' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267291'
                WHERE ordernumber = 'P2503020000409' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459162'
                WHERE ordernumber = 'P2503020000412' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459163'
                WHERE ordernumber = 'P2503020000413' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459165'
                WHERE ordernumber = 'P2503020000417' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346460'
                WHERE ordernumber = 'P2503020000421' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459166'
                WHERE ordernumber = 'P2503020000422' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459164'
                WHERE ordernumber = 'P2503020000423' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418451'
                WHERE ordernumber = 'P2503020000427' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456394'
                WHERE ordernumber = 'P2503020000428' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107639'
                WHERE ordernumber = 'P2503020000430' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375740'
                WHERE ordernumber = 'P2503020000433' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221498'
                WHERE ordernumber = 'P2503020000435' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '448300'
                WHERE ordernumber = 'P2503020000438' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334317'
                WHERE ordernumber = 'P2503020000441' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459167'
                WHERE ordernumber = 'P2503020000443' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430143'
                WHERE ordernumber = 'P2503020000447' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399328'
                WHERE ordernumber = 'P2503020000449' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459168'
                WHERE ordernumber = 'P2503020000454' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428330'
                WHERE ordernumber = 'P2503020000458' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459169'
                WHERE ordernumber = 'P2503020000459' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459170'
                WHERE ordernumber = 'P2503020000463' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457765'
                WHERE ordernumber = 'P2503020000464' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275320'
                WHERE ordernumber = 'P2503020000465' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459171'
                WHERE ordernumber = 'P2503020000469' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458243'
                WHERE ordernumber = 'P2503020000475' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455441'
                WHERE ordernumber = 'P2503020000482' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459172'
                WHERE ordernumber = 'P2503020000483' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459173'
                WHERE ordernumber = 'P2503020000485' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316303'
                WHERE ordernumber = 'P2503020000489' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330152'
                WHERE ordernumber = 'P2503020000491' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459175'
                WHERE ordernumber = 'P2503020000492' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298412'
                WHERE ordernumber = 'P2503020000493' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282280'
                WHERE ordernumber = 'P2503020000494' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459176'
                WHERE ordernumber = 'P2503020000495' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459177'
                WHERE ordernumber = 'P2503020000497' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456500'
                WHERE ordernumber = 'P2503020000498' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459174'
                WHERE ordernumber = 'P2503020000499' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287880'
                WHERE ordernumber = 'P2503020000501' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459178'
                WHERE ordernumber = 'P2503020000503' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131727'
                WHERE ordernumber = 'P2503020000505' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459179'
                WHERE ordernumber = 'P2503020000506' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459180'
                WHERE ordernumber = 'P2503020000507' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459181'
                WHERE ordernumber = 'P2503020000508' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456235'
                WHERE ordernumber = 'P2503020000510' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219343'
                WHERE ordernumber = 'P2503020000513' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459182'
                WHERE ordernumber = 'P2503020000514' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302230'
                WHERE ordernumber = 'P2503020000516' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459183'
                WHERE ordernumber = 'P2503020000517' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159544'
                WHERE ordernumber = 'P2503020000530' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245591'
                WHERE ordernumber = 'P2503020000533' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459185'
                WHERE ordernumber = 'P2503020000535' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293335'
                WHERE ordernumber = 'P2503020000539' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459186'
                WHERE ordernumber = 'P2503020000542' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227057'
                WHERE ordernumber = 'P2503020000545' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459187'
                WHERE ordernumber = 'P2503020000548' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425779'
                WHERE ordernumber = 'P2503020000556' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459189'
                WHERE ordernumber = 'P2503020000558' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425779'
                WHERE ordernumber = 'P2503020000560' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459190'
                WHERE ordernumber = 'P2503020000562' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459191'
                WHERE ordernumber = 'P2503020000572' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284936'
                WHERE ordernumber = 'P2503020000573' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459192'
                WHERE ordernumber = 'P2503020000574' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459193'
                WHERE ordernumber = 'P2503020000575' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279286'
                WHERE ordernumber = 'P2503020000577' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244822'
                WHERE ordernumber = 'P2503020000579' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459195'
                WHERE ordernumber = 'P2503020000580' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416617'
                WHERE ordernumber = 'P2503020000583' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416617'
                WHERE ordernumber = 'P2503020000584' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459196'
                WHERE ordernumber = 'P2503020000585' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390879'
                WHERE ordernumber = 'P2503020000586' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459198'
                WHERE ordernumber = 'P2503020000592' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457764'
                WHERE ordernumber = 'P2503020000595' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458746'
                WHERE ordernumber = 'P2503020000598' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459199'
                WHERE ordernumber = 'P2503020000599' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459200'
                WHERE ordernumber = 'P2503020000600' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392861'
                WHERE ordernumber = 'P2503020000602' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459201'
                WHERE ordernumber = 'P2503020000607' 
            
2025-03-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459203'
                WHERE ordernumber = 'P2503020000609' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401701'
                WHERE ordernumber = 'P2503020000611' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459205'
                WHERE ordernumber = 'P2503020000615' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459206'
                WHERE ordernumber = 'P2503020000620' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459204'
                WHERE ordernumber = 'P2503020000621' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459207'
                WHERE ordernumber = 'P2503020000622' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457153'
                WHERE ordernumber = 'P2503020000624' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276080'
                WHERE ordernumber = 'P2503020000626' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459208'
                WHERE ordernumber = 'P2503020000628' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459209'
                WHERE ordernumber = 'P2503020000629' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391255'
                WHERE ordernumber = 'P2503020000630' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459210'
                WHERE ordernumber = 'P2503020000632' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '309215'
                WHERE ordernumber = 'P2503020000636' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459211'
                WHERE ordernumber = 'P2503020000637' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '91003'
                WHERE ordernumber = 'P2503020000643' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386548'
                WHERE ordernumber = 'P2503020000651' 
            
2025-03-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408411'
                WHERE ordernumber = 'P2503020000656'