2024-12-17 01:00:02 -- 將會員中心id寫入data-lake
2024-12-17 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 '2024-12-16%';
        
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436248'
                WHERE ordernumber = 'P2412160000129' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404822'
                WHERE ordernumber = 'P2412160000287' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304106'
                WHERE ordernumber = 'P2412160000337' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436249'
                WHERE ordernumber = 'P2412160000538' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2412160000624' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436249'
                WHERE ordernumber = 'P2412160000817' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436250'
                WHERE ordernumber = 'P2412160000919' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427023'
                WHERE ordernumber = 'P2412160001094' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '64180'
                WHERE ordernumber = 'P2412160001172' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206917'
                WHERE ordernumber = 'P2412160001293' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254390'
                WHERE ordernumber = 'P2412160001366' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331433'
                WHERE ordernumber = 'P2412160001482' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238273'
                WHERE ordernumber = 'P2412160001540' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425891'
                WHERE ordernumber = 'P2412160001675' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338215'
                WHERE ordernumber = 'P2412160001773' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '109155'
                WHERE ordernumber = 'P2412160001897' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436254'
                WHERE ordernumber = 'P2412160001935' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '134844'
                WHERE ordernumber = 'P2412160002090' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436255'
                WHERE ordernumber = 'P2412160002160' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257823'
                WHERE ordernumber = 'P2412160002314' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424629'
                WHERE ordernumber = 'P2412160002836' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419361'
                WHERE ordernumber = 'P2412160003436' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436259'
                WHERE ordernumber = 'P2412160003777' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392414'
                WHERE ordernumber = 'P2412160003829' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97359'
                WHERE ordernumber = 'P2412160003955' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2412160004086' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434479'
                WHERE ordernumber = 'P2412160004199' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212021'
                WHERE ordernumber = 'P2412160004266' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386127'
                WHERE ordernumber = 'P2412160004376' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2412160004514' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436261'
                WHERE ordernumber = 'P2412160004647' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '1220'
                WHERE ordernumber = 'P2412160004875' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2412160004994' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223251'
                WHERE ordernumber = 'P2412160005032' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2412160005159' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2412160005387' 
            
2024-12-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '32399'
                WHERE ordernumber = 'P2412160005463' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2412160005541' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212021'
                WHERE ordernumber = 'P2412160005736' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96208'
                WHERE ordernumber = 'P2412160005886' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2412160006231' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2412160006449' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320727'
                WHERE ordernumber = 'P2412160006518' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P2412160006657' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436269'
                WHERE ordernumber = 'P2412160006783' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436268'
                WHERE ordernumber = 'P2412160006921' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113932'
                WHERE ordernumber = 'P2412160007167' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436269'
                WHERE ordernumber = 'P2412160007284' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113932'
                WHERE ordernumber = 'P2412160007348' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436266'
                WHERE ordernumber = 'P2412160007490' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436262'
                WHERE ordernumber = 'P2412160007596' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268419'
                WHERE ordernumber = 'P2412160007625' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423797'
                WHERE ordernumber = 'P2412160007817' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430422'
                WHERE ordernumber = 'P2412160007934' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336712'
                WHERE ordernumber = 'P2412160008113' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262052'
                WHERE ordernumber = 'P2412160008270' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97525'
                WHERE ordernumber = 'P2412160008349' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397573'
                WHERE ordernumber = 'P2412160008471' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436280'
                WHERE ordernumber = 'P2412160008655' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41896'
                WHERE ordernumber = 'P2412160008752' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436281'
                WHERE ordernumber = 'P2412160008911' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260273'
                WHERE ordernumber = 'P2412160009387' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436283'
                WHERE ordernumber = 'P2412160009432' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436285'
                WHERE ordernumber = 'P2412160009534' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436284'
                WHERE ordernumber = 'P2412160009638' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429359'
                WHERE ordernumber = 'P2412160009727' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421735'
                WHERE ordernumber = 'P2412160009891' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436284'
                WHERE ordernumber = 'P2412160010480' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39815'
                WHERE ordernumber = 'P2412160010552' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436286'
                WHERE ordernumber = 'P2412160010865' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362321'
                WHERE ordernumber = 'P2412160011389' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436289'
                WHERE ordernumber = 'P2412160011478' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293405'
                WHERE ordernumber = 'P2412160011595' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365159'
                WHERE ordernumber = 'P2412160011825' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436293'
                WHERE ordernumber = 'P2412160011979' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436292'
                WHERE ordernumber = 'P2412160012170' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233917'
                WHERE ordernumber = 'P2412160012425' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416099'
                WHERE ordernumber = 'P2412160012573' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425077'
                WHERE ordernumber = 'P2412160012651' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P2412160013031' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436300'
                WHERE ordernumber = 'P2412160013227' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427498'
                WHERE ordernumber = 'P2412160013364' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436302'
                WHERE ordernumber = 'P2412160013481' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436301'
                WHERE ordernumber = 'P2412160013583' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2412160013793' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407938'
                WHERE ordernumber = 'P2412160014131' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436306'
                WHERE ordernumber = 'P2412160014334' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353684'
                WHERE ordernumber = 'P2412160014559' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436311'
                WHERE ordernumber = 'P2412160014862' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436313'
                WHERE ordernumber = 'P2412160015158' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436314'
                WHERE ordernumber = 'P2412160015349' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436316'
                WHERE ordernumber = 'P2412160015526' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436319'
                WHERE ordernumber = 'P2412160015789' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436321'
                WHERE ordernumber = 'P2412160015827' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270861'
                WHERE ordernumber = 'P2412160015910' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216729'
                WHERE ordernumber = 'P2412160016010' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436323'
                WHERE ordernumber = 'P2412160016116' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436323'
                WHERE ordernumber = 'P2412160016313' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436322'
                WHERE ordernumber = 'P2412160016418' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436326'
                WHERE ordernumber = 'P2412160016689' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436325'
                WHERE ordernumber = 'P2412160016799' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436327'
                WHERE ordernumber = 'P2412160016848' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388031'
                WHERE ordernumber = 'P2412160016931' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88985'
                WHERE ordernumber = 'P2412160017013' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228918'
                WHERE ordernumber = 'P2412160017175' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63554'
                WHERE ordernumber = 'P2412160017280' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432841'
                WHERE ordernumber = 'P2412160017379' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168535'
                WHERE ordernumber = 'P2412160017463' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436331'
                WHERE ordernumber = 'P2412160017613' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121245'
                WHERE ordernumber = 'P2412160019149' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436336'
                WHERE ordernumber = 'P2412160019589' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303973'
                WHERE ordernumber = 'P2412160019677' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436343'
                WHERE ordernumber = 'P2412160019853' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436340'
                WHERE ordernumber = 'P2412160020199' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323204'
                WHERE ordernumber = 'P2412160020574' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334953'
                WHERE ordernumber = 'P2412160020661' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436346'
                WHERE ordernumber = 'P2412160021666' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436346'
                WHERE ordernumber = 'P2412160021743' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436347'
                WHERE ordernumber = 'P2412160021854' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280009'
                WHERE ordernumber = 'P2412160021961' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436348'
                WHERE ordernumber = 'P2412160022087' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426026'
                WHERE ordernumber = 'P2412160022121' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219229'
                WHERE ordernumber = 'P2412160022353' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313542'
                WHERE ordernumber = 'P2412160022659' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136122'
                WHERE ordernumber = 'P2412160022714' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258236'
                WHERE ordernumber = 'P2412160022932' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121245'
                WHERE ordernumber = 'P2412160023090' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '42971'
                WHERE ordernumber = 'P2412160023229' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153121'
                WHERE ordernumber = 'P2412160023399' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209840'
                WHERE ordernumber = 'P2412160023551' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160054'
                WHERE ordernumber = 'P2412160023982' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81760'
                WHERE ordernumber = 'P2412160024360' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '25201'
                WHERE ordernumber = 'P2412160024470' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287903'
                WHERE ordernumber = 'P2412160025037' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436355'
                WHERE ordernumber = 'P2412160025623' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237288'
                WHERE ordernumber = 'P2412160025738' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386127'
                WHERE ordernumber = 'P2412160025850' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423712'
                WHERE ordernumber = 'P2412160025939' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436358'
                WHERE ordernumber = 'P2412160026131' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436358'
                WHERE ordernumber = 'P2412160026329' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436360'
                WHERE ordernumber = 'P2412160026582' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435114'
                WHERE ordernumber = 'P2412160027021' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436362'
                WHERE ordernumber = 'P2412160027138' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415382'
                WHERE ordernumber = 'P2412160027267' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238978'
                WHERE ordernumber = 'P2412160027459' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436364'
                WHERE ordernumber = 'P2412160027762' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103320'
                WHERE ordernumber = 'P2412160027990' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111289'
                WHERE ordernumber = 'P2412160028043' 
            
2024-12-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '77463'
                WHERE ordernumber = 'P2412160028158' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281086'
                WHERE ordernumber = 'P2412160028315' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281086'
                WHERE ordernumber = 'P2412160028516' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436371'
                WHERE ordernumber = 'P2412160028674' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80996'
                WHERE ordernumber = 'P2412160028798' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436370'
                WHERE ordernumber = 'P2412160028828' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245088'
                WHERE ordernumber = 'P2412160028957' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436366'
                WHERE ordernumber = 'P2412160029264' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418691'
                WHERE ordernumber = 'P2412160029330' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337254'
                WHERE ordernumber = 'P2412160029560' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430119'
                WHERE ordernumber = 'P2412160029734' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161910'
                WHERE ordernumber = 'P2412160029883' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436372'
                WHERE ordernumber = 'P2412160030154' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436375'
                WHERE ordernumber = 'P2412160030569' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238535'
                WHERE ordernumber = 'P2412160030694' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391040'
                WHERE ordernumber = 'P2412160030724' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '7087'
                WHERE ordernumber = 'P2412160030972' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396200'
                WHERE ordernumber = 'P2412160031070' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436376'
                WHERE ordernumber = 'P2412160031149' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141131'
                WHERE ordernumber = 'P2412160031386' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '144321'
                WHERE ordernumber = 'P2412160031435' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436378'
                WHERE ordernumber = 'P2412160031527' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436381'
                WHERE ordernumber = 'P2412160031843' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244844'
                WHERE ordernumber = 'P2412160031963' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436380'
                WHERE ordernumber = 'P2412160032053' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436382'
                WHERE ordernumber = 'P2412160032431' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436382'
                WHERE ordernumber = 'P2412160032578' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436384'
                WHERE ordernumber = 'P2412160032617' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76999'
                WHERE ordernumber = 'P2412160032792' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218185'
                WHERE ordernumber = 'P2412160032826' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436379'
                WHERE ordernumber = 'P2412160033095' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364595'
                WHERE ordernumber = 'P2412160033197' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436387'
                WHERE ordernumber = 'P2412160033265' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301616'
                WHERE ordernumber = 'P2412160033369' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364595'
                WHERE ordernumber = 'P2412160033436' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263902'
                WHERE ordernumber = 'P2412160033657' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436388'
                WHERE ordernumber = 'P2412160033738' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82910'
                WHERE ordernumber = 'P2412160033963' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436393'
                WHERE ordernumber = 'P2412160034032' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163359'
                WHERE ordernumber = 'P2412160034592' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327477'
                WHERE ordernumber = 'P2412160034676' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273246'
                WHERE ordernumber = 'P2412160034941' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436398'
                WHERE ordernumber = 'P2412160035024' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436399'
                WHERE ordernumber = 'P2412160035220' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128659'
                WHERE ordernumber = 'P2412160035375' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436402'
                WHERE ordernumber = 'P2412160035419' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165635'
                WHERE ordernumber = 'P2412160035546' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423797'
                WHERE ordernumber = 'P2412160035723' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363046'
                WHERE ordernumber = 'P2412160035974' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238657'
                WHERE ordernumber = 'P2412160036073' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143144'
                WHERE ordernumber = 'P2412160036588' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379256'
                WHERE ordernumber = 'P2412160036651' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436407'
                WHERE ordernumber = 'P2412160037086' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384509'
                WHERE ordernumber = 'P2412160037151' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436411'
                WHERE ordernumber = 'P2412160037232' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162020'
                WHERE ordernumber = 'P2412160037314' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436412'
                WHERE ordernumber = 'P2412160037458' 
            
2024-12-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436260'
                WHERE ordernumber = 'P2412160037550'