2025-02-11 01:00:02 -- 將會員中心id寫入data-lake
2025-02-11 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-10%';
        
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432196'
                WHERE ordernumber = 'P2502100000010' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455414'
                WHERE ordernumber = 'P2502100000013' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '292259'
                WHERE ordernumber = 'P2502100000014' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379086'
                WHERE ordernumber = 'P2502100000016' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455415'
                WHERE ordernumber = 'P2502100000019' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214719'
                WHERE ordernumber = 'P2502100000021' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455416'
                WHERE ordernumber = 'P2502100000025' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455417'
                WHERE ordernumber = 'P2502100000026' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232090'
                WHERE ordernumber = 'P2502100000029' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455419'
                WHERE ordernumber = 'P2502100000030' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425240'
                WHERE ordernumber = 'P2502100000031' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386076'
                WHERE ordernumber = 'P2502100000035' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224319'
                WHERE ordernumber = 'P2502100000036' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455418'
                WHERE ordernumber = 'P2502100000043' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455413'
                WHERE ordernumber = 'P2502100000044' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455420'
                WHERE ordernumber = 'P2502100000046' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P2502100000048' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '109157'
                WHERE ordernumber = 'P2502100000049' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455421'
                WHERE ordernumber = 'P2502100000050' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455422'
                WHERE ordernumber = 'P2502100000055' 
            
2025-02-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420785'
                WHERE ordernumber = 'P2502100000061' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104586'
                WHERE ordernumber = 'P2502100000062' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399685'
                WHERE ordernumber = 'P2502100000063' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '7906'
                WHERE ordernumber = 'P2502100000074' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455423'
                WHERE ordernumber = 'P2502100000077' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440728'
                WHERE ordernumber = 'P2502100000085' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433537'
                WHERE ordernumber = 'P2502100000086' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P2502100000088' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455424'
                WHERE ordernumber = 'P2502100000092' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214293'
                WHERE ordernumber = 'P2502100000098' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455425'
                WHERE ordernumber = 'P2502100000099' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431779'
                WHERE ordernumber = 'P2502100000101' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455427'
                WHERE ordernumber = 'P2502100000102' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405523'
                WHERE ordernumber = 'P2502100000106' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455428'
                WHERE ordernumber = 'P2502100000111' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455429'
                WHERE ordernumber = 'P2502100000113' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306350'
                WHERE ordernumber = 'P2502100000117' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305962'
                WHERE ordernumber = 'P2502100000121' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358717'
                WHERE ordernumber = 'P2502100000122' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454799'
                WHERE ordernumber = 'P2502100000124' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425140'
                WHERE ordernumber = 'P2502100000133' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455431'
                WHERE ordernumber = 'P2502100000135' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455432'
                WHERE ordernumber = 'P2502100000139' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166348'
                WHERE ordernumber = 'P2502100000144' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98869'
                WHERE ordernumber = 'P2502100000145' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '47319'
                WHERE ordernumber = 'P2502100000146' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245217'
                WHERE ordernumber = 'P2502100000150' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429811'
                WHERE ordernumber = 'P2502100000151' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455434'
                WHERE ordernumber = 'P2502100000152' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388725'
                WHERE ordernumber = 'P2502100000153' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455435'
                WHERE ordernumber = 'P2502100000161' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287225'
                WHERE ordernumber = 'P2502100000162' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455436'
                WHERE ordernumber = 'P2502100000166' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287225'
                WHERE ordernumber = 'P2502100000168' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274892'
                WHERE ordernumber = 'P2502100000170' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '453344'
                WHERE ordernumber = 'P2502100000171' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455437'
                WHERE ordernumber = 'P2502100000173' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455438'
                WHERE ordernumber = 'P2502100000178' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212515'
                WHERE ordernumber = 'P2502100000185' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423857'
                WHERE ordernumber = 'P2502100000186' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454825'
                WHERE ordernumber = 'P2502100000190' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251553'
                WHERE ordernumber = 'P2502100000193' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357556'
                WHERE ordernumber = 'P2502100000194' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '451549'
                WHERE ordernumber = 'P2502100000202' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101722'
                WHERE ordernumber = 'P2502100000203' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93899'
                WHERE ordernumber = 'P2502100000205' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455440'
                WHERE ordernumber = 'P2502100000208' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455443'
                WHERE ordernumber = 'P2502100000209' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385062'
                WHERE ordernumber = 'P2502100000213' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434566'
                WHERE ordernumber = 'P2502100000217' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455444'
                WHERE ordernumber = 'P2502100000226' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2502100000237' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159220'
                WHERE ordernumber = 'P2502100000242' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '30133'
                WHERE ordernumber = 'P2502100000244' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386961'
                WHERE ordernumber = 'P2502100000246' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455446'
                WHERE ordernumber = 'P2502100000248' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455447'
                WHERE ordernumber = 'P2502100000249' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158668'
                WHERE ordernumber = 'P2502100000253' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455078'
                WHERE ordernumber = 'P2502100000254' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455448'
                WHERE ordernumber = 'P2502100000258' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455448'
                WHERE ordernumber = 'P2502100000259' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111604'
                WHERE ordernumber = 'P2502100000263' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455450'
                WHERE ordernumber = 'P2502100000268' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438619'
                WHERE ordernumber = 'P2502100000269' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455450'
                WHERE ordernumber = 'P2502100000272' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381201'
                WHERE ordernumber = 'P2502100000275' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455451'
                WHERE ordernumber = 'P2502100000276' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166685'
                WHERE ordernumber = 'P2502100000280' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116131'
                WHERE ordernumber = 'P2502100000281' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455452'
                WHERE ordernumber = 'P2502100000282' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347462'
                WHERE ordernumber = 'P2502100000285' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454803'
                WHERE ordernumber = 'P2502100000287' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452216'
                WHERE ordernumber = 'P2502100000288' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455455'
                WHERE ordernumber = 'P2502100000293' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399308'
                WHERE ordernumber = 'P2502100000294' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455456'
                WHERE ordernumber = 'P2502100000297' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455457'
                WHERE ordernumber = 'P2502100000299' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455068'
                WHERE ordernumber = 'P2502100000300' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455458'
                WHERE ordernumber = 'P2502100000304' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455460'
                WHERE ordernumber = 'P2502100000307' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455456'
                WHERE ordernumber = 'P2502100000310' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271328'
                WHERE ordernumber = 'P2502100000311' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455459'
                WHERE ordernumber = 'P2502100000313' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455456'
                WHERE ordernumber = 'P2502100000314' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455461'
                WHERE ordernumber = 'P2502100000316' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455462'
                WHERE ordernumber = 'P2502100000317' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313048'
                WHERE ordernumber = 'P2502100000324' 
            
2025-02-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255573'
                WHERE ordernumber = 'P2502100000326' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110589'
                WHERE ordernumber = 'P2502100000331' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362264'
                WHERE ordernumber = 'P2502100000334' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455465'
                WHERE ordernumber = 'P2502100000338' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378322'
                WHERE ordernumber = 'P2502100000341' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400381'
                WHERE ordernumber = 'P2502100000347' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455466'
                WHERE ordernumber = 'P2502100000348' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114389'
                WHERE ordernumber = 'P2502100000350' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416386'
                WHERE ordernumber = 'P2502100000356' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455470'
                WHERE ordernumber = 'P2502100000364' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349608'
                WHERE ordernumber = 'P2502100000365' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455470'
                WHERE ordernumber = 'P2502100000366' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215837'
                WHERE ordernumber = 'P2502100000367' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455469'
                WHERE ordernumber = 'P2502100000368' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455471'
                WHERE ordernumber = 'P2502100000370' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455472'
                WHERE ordernumber = 'P2502100000373' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397239'
                WHERE ordernumber = 'P2502100000375' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264596'
                WHERE ordernumber = 'P2502100000381' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455346'
                WHERE ordernumber = 'P2502100000385' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455474'
                WHERE ordernumber = 'P2502100000386' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455473'
                WHERE ordernumber = 'P2502100000391' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455473'
                WHERE ordernumber = 'P2502100000392' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306476'
                WHERE ordernumber = 'P2502100000397' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453627'
                WHERE ordernumber = 'P2502100000400' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455476'
                WHERE ordernumber = 'P2502100000402' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455477'
                WHERE ordernumber = 'P2502100000405' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108089'
                WHERE ordernumber = 'P2502100000407' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P2502100000409' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455480'
                WHERE ordernumber = 'P2502100000417' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455483'
                WHERE ordernumber = 'P2502100000419' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455481'
                WHERE ordernumber = 'P2502100000420' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455482'
                WHERE ordernumber = 'P2502100000421' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311745'
                WHERE ordernumber = 'P2502100000424' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455486'
                WHERE ordernumber = 'P2502100000426' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455480'
                WHERE ordernumber = 'P2502100000428' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112329'
                WHERE ordernumber = 'P2502100000429' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287106'
                WHERE ordernumber = 'P2502100000430' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252246'
                WHERE ordernumber = 'P2502100000434' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108330'
                WHERE ordernumber = 'P2502100000442' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '62736'
                WHERE ordernumber = 'P2502100000445' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247765'
                WHERE ordernumber = 'P2502100000446' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455488'
                WHERE ordernumber = 'P2502100000451' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236502'
                WHERE ordernumber = 'P2502100000452' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118209'
                WHERE ordernumber = 'P2502100000459' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387269'
                WHERE ordernumber = 'P2502100000463' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114753'
                WHERE ordernumber = 'P2502100000464' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114753'
                WHERE ordernumber = 'P2502100000466' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226822'
                WHERE ordernumber = 'P2502100000470' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402156'
                WHERE ordernumber = 'P2502100000472' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426181'
                WHERE ordernumber = 'P2502100000473' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455489'
                WHERE ordernumber = 'P2502100000477' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455489'
                WHERE ordernumber = 'P2502100000478' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337464'
                WHERE ordernumber = 'P2502100000482' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248219'
                WHERE ordernumber = 'P2502100000485' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455492'
                WHERE ordernumber = 'P2502100000487' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283871'
                WHERE ordernumber = 'P2502100000489' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127600'
                WHERE ordernumber = 'P2502100000490' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2502100000493' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455494'
                WHERE ordernumber = 'P2502100000495' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455494'
                WHERE ordernumber = 'P2502100000496' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392018'
                WHERE ordernumber = 'P2502100000501' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295213'
                WHERE ordernumber = 'P2502100000505' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455497'
                WHERE ordernumber = 'P2502100000511' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452996'
                WHERE ordernumber = 'P2502100000516' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433040'
                WHERE ordernumber = 'P2502100000519' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81645'
                WHERE ordernumber = 'P2502100000520' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455498'
                WHERE ordernumber = 'P2502100000521' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364752'
                WHERE ordernumber = 'P2502100000522' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455499'
                WHERE ordernumber = 'P2502100000525' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455500'
                WHERE ordernumber = 'P2502100000526' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455501'
                WHERE ordernumber = 'P2502100000527' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455502'
                WHERE ordernumber = 'P2502100000530' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P2502100000533' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401109'
                WHERE ordernumber = 'P2502100000534' 
            
2025-02-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313567'
                WHERE ordernumber = 'P2502100000546'