2023-11-29 01:00:02 -- 將會員中心id寫入data-lake
2023-11-29 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 '2023-11-28%';
        
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '44719'
                WHERE ordernumber = 'P191128110228630' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349704'
                WHERE ordernumber = 'P181128110350329' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348889'
                WHERE ordernumber = 'P201128110458907' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214179'
                WHERE ordernumber = 'P181128111101939' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349706'
                WHERE ordernumber = 'P181128111235340' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97539'
                WHERE ordernumber = 'P201128111518909' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97539'
                WHERE ordernumber = 'P201128111606121' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348096'
                WHERE ordernumber = 'P181128111914547' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349708'
                WHERE ordernumber = 'P201128111916155' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97539'
                WHERE ordernumber = 'P201128112056124' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349709'
                WHERE ordernumber = 'P191128112442319' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349711'
                WHERE ordernumber = 'P191128112733730' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313349'
                WHERE ordernumber = 'P181128113926554' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349713'
                WHERE ordernumber = 'P201128114235607' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349714'
                WHERE ordernumber = 'P191128114311994' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349715'
                WHERE ordernumber = 'P181128114323657' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250013'
                WHERE ordernumber = 'P201128114556586' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349716'
                WHERE ordernumber = 'P181128114558175' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349717'
                WHERE ordernumber = 'P191128114942197' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349719'
                WHERE ordernumber = 'P181128115301806' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349720'
                WHERE ordernumber = 'P181128115325733' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275999'
                WHERE ordernumber = 'P181128115433958' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349722'
                WHERE ordernumber = 'P181128115637122' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181128120144301' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349653'
                WHERE ordernumber = 'P421128121129428' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349726'
                WHERE ordernumber = 'P201128121140336' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349727'
                WHERE ordernumber = 'P181128121147518' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349728'
                WHERE ordernumber = 'P181128121323981' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97572'
                WHERE ordernumber = 'P201128121326272' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349728'
                WHERE ordernumber = 'P181128121438955' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349725'
                WHERE ordernumber = 'P181128121705606' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349730'
                WHERE ordernumber = 'P201128122006758' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349071'
                WHERE ordernumber = 'P421128122250242' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349732'
                WHERE ordernumber = 'P191128122445984' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349734'
                WHERE ordernumber = 'P421128123018505' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130760'
                WHERE ordernumber = 'P191128123652663' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318961'
                WHERE ordernumber = 'P191128124410176' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345449'
                WHERE ordernumber = 'P421128124559440' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '109027'
                WHERE ordernumber = 'P191128125259555' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349737'
                WHERE ordernumber = 'P191128125726783' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349738'
                WHERE ordernumber = 'P191128130400643' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349740'
                WHERE ordernumber = 'P191128131559437' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343747'
                WHERE ordernumber = 'P421128131608386' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349742'
                WHERE ordernumber = 'P191128132050489' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98145'
                WHERE ordernumber = 'P201128132127877' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315890'
                WHERE ordernumber = 'P191128132234967' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317028'
                WHERE ordernumber = 'P191128132351195' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349744'
                WHERE ordernumber = 'P421128132732652' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349745'
                WHERE ordernumber = 'P191128132812891' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349745'
                WHERE ordernumber = 'P191128133014860' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349746'
                WHERE ordernumber = 'P191128133110573' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349747'
                WHERE ordernumber = 'P201128133156730' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259366'
                WHERE ordernumber = 'P191128133205847' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229745'
                WHERE ordernumber = 'P201128133306891' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349751'
                WHERE ordernumber = 'P191128134206129' 
            
2023-11-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349405'
                WHERE ordernumber = 'P201128134416934' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90101'
                WHERE ordernumber = 'P201128134926602' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289794'
                WHERE ordernumber = 'P201128135240516' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145633'
                WHERE ordernumber = 'P191128135424747' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313744'
                WHERE ordernumber = 'P421128135749699' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340614'
                WHERE ordernumber = 'P421128140835747' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349756'
                WHERE ordernumber = 'P421128141214228' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '44602'
                WHERE ordernumber = 'P421128141431457' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213823'
                WHERE ordernumber = 'P201128141520191' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P201128141550716' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301528'
                WHERE ordernumber = 'P201128141756174' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211997'
                WHERE ordernumber = 'P191128141922397' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349760'
                WHERE ordernumber = 'P191128142159506' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349761'
                WHERE ordernumber = 'P201128142538353' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341685'
                WHERE ordernumber = 'P191128142812704' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349763'
                WHERE ordernumber = 'P201128143238880' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349764'
                WHERE ordernumber = 'P191128144235135' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156751'
                WHERE ordernumber = 'P191128145115493' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123242'
                WHERE ordernumber = 'P191128145856495' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '134877'
                WHERE ordernumber = 'P201128150006394' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349767'
                WHERE ordernumber = 'P421128150151593' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349768'
                WHERE ordernumber = 'P181128150204560' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267051'
                WHERE ordernumber = 'P201128150239236' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349769'
                WHERE ordernumber = 'P421128150351486' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314571'
                WHERE ordernumber = 'P181128150946729' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336523'
                WHERE ordernumber = 'P201128151115575' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349771'
                WHERE ordernumber = 'P421128151137202' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349772'
                WHERE ordernumber = 'P191128151305519' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344238'
                WHERE ordernumber = 'P421128151905804' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349773'
                WHERE ordernumber = 'P201128152355936' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102352'
                WHERE ordernumber = 'P191128152954400' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349775'
                WHERE ordernumber = 'P201128153117902' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349777'
                WHERE ordernumber = 'P191128153747261' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345354'
                WHERE ordernumber = 'P191128154552783' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112057'
                WHERE ordernumber = 'P191128154945732' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112057'
                WHERE ordernumber = 'P191128155021369' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345354'
                WHERE ordernumber = 'P191128155122260' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285581'
                WHERE ordernumber = 'P201128155240393' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104445'
                WHERE ordernumber = 'P191128155926328' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349782'
                WHERE ordernumber = 'P191128160207277' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98346'
                WHERE ordernumber = 'P421128160458792' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313055'
                WHERE ordernumber = 'P421128160751843' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300529'
                WHERE ordernumber = 'P201128161114464' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349590'
                WHERE ordernumber = 'P191128161641810' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '44781'
                WHERE ordernumber = 'P201128161735840' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '61970'
                WHERE ordernumber = 'P191128162146654' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222604'
                WHERE ordernumber = 'P201128163223772' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222604'
                WHERE ordernumber = 'P201128163346598' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P191128163452764' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349789'
                WHERE ordernumber = 'P191128163700192' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349791'
                WHERE ordernumber = 'P421128163953899' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217480'
                WHERE ordernumber = 'P191128164017918' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349794'
                WHERE ordernumber = 'P191128164809805' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349687'
                WHERE ordernumber = 'P191128165231313' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246380'
                WHERE ordernumber = 'P191128165340833' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276042'
                WHERE ordernumber = 'P201128165619688' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335887'
                WHERE ordernumber = 'P191128165625700' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347529'
                WHERE ordernumber = 'P201128170347456' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342180'
                WHERE ordernumber = 'P201128170827154' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349796'
                WHERE ordernumber = 'P191128170937708' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102830'
                WHERE ordernumber = 'P201128170949678' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319044'
                WHERE ordernumber = 'P191128172012996' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235307'
                WHERE ordernumber = 'P201128172157214' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228024'
                WHERE ordernumber = 'P201128172343631' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349797'
                WHERE ordernumber = 'P191128172404531' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342690'
                WHERE ordernumber = 'P191128172807210' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292038'
                WHERE ordernumber = 'P201128172832802' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325358'
                WHERE ordernumber = 'P421128173008929' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161876'
                WHERE ordernumber = 'P201128173224959' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '52059'
                WHERE ordernumber = 'P421128173332920' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260525'
                WHERE ordernumber = 'P191128173553421' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349803'
                WHERE ordernumber = 'P191128174352305' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349805'
                WHERE ordernumber = 'P191128174713820' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349807'
                WHERE ordernumber = 'P191128175124948' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349798'
                WHERE ordernumber = 'P181128180639663' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P181128180810802' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244207'
                WHERE ordernumber = 'P191128181304664' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349812'
                WHERE ordernumber = 'P181128183002427' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255157'
                WHERE ordernumber = 'P201128183256706' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349814'
                WHERE ordernumber = 'P421128183509703' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '179269'
                WHERE ordernumber = 'P201128183551836' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349815'
                WHERE ordernumber = 'P191128183846965' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349815'
                WHERE ordernumber = 'P191128183952875' 
            
2023-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90618'
                WHERE ordernumber = 'P201128184230533' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P191128184233383' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349818'
                WHERE ordernumber = 'P201128184820766' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347553'
                WHERE ordernumber = 'P201128184829177' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349820'
                WHERE ordernumber = 'P191128185257116' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349821'
                WHERE ordernumber = 'P421128185503605' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349822'
                WHERE ordernumber = 'P191128190224822' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283181'
                WHERE ordernumber = 'P201128191106615' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349825'
                WHERE ordernumber = 'P191128192206169' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349826'
                WHERE ordernumber = 'P191128192351654' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349828'
                WHERE ordernumber = 'P201128192458646' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349829'
                WHERE ordernumber = 'P421128192713859' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348733'
                WHERE ordernumber = 'P191128193706346' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234124'
                WHERE ordernumber = 'P421128194322324' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207158'
                WHERE ordernumber = 'P191128194540379' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349830'
                WHERE ordernumber = 'P201128194757328' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306214'
                WHERE ordernumber = 'P191128195839120' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158690'
                WHERE ordernumber = 'P421128195854384' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322190'
                WHERE ordernumber = 'P201128200154748' 
            
2023-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349832'
                WHERE ordernumber = 'P201128200426184'