2024-08-07 01:00:03 -- 將會員中心id寫入data-lake
2024-08-07 01:00:03 -- 
            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-08-06%';
        
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319592'
                WHERE ordernumber = 'P630806104728848' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321147'
                WHERE ordernumber = 'P180806110118524' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405695'
                WHERE ordernumber = 'P420806110533895' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405696'
                WHERE ordernumber = 'P190806110835202' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216961'
                WHERE ordernumber = 'P190806110959639' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405697'
                WHERE ordernumber = 'P420806111108808' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225726'
                WHERE ordernumber = 'P200806111333726' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405698'
                WHERE ordernumber = 'P420806111728992' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399677'
                WHERE ordernumber = 'P200806112016710' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405700'
                WHERE ordernumber = 'P200806112444430' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402669'
                WHERE ordernumber = 'P630806112942509' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405580'
                WHERE ordernumber = 'P180806113510683' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '46359'
                WHERE ordernumber = 'P420806114209272' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405709'
                WHERE ordernumber = 'P200806114433181' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '134885'
                WHERE ordernumber = 'P180806114513432' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386479'
                WHERE ordernumber = 'P200806115826503' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180806115937684' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405713'
                WHERE ordernumber = 'P180806120302578' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218629'
                WHERE ordernumber = 'P180806120631245' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337407'
                WHERE ordernumber = 'P180806120709123' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381202'
                WHERE ordernumber = 'P180806121003915' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343835'
                WHERE ordernumber = 'P420806121105419' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395700'
                WHERE ordernumber = 'P200806121110871' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405714'
                WHERE ordernumber = 'P180806121131253' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167176'
                WHERE ordernumber = 'P200806121526501' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405715'
                WHERE ordernumber = 'P420806121627633' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314336'
                WHERE ordernumber = 'P180806121719644' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357571'
                WHERE ordernumber = 'P420806121854652' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207361'
                WHERE ordernumber = 'P180806122053907' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320506'
                WHERE ordernumber = 'P180806122209826' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99941'
                WHERE ordernumber = 'P180806122317844' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281172'
                WHERE ordernumber = 'P200806122439542' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405721'
                WHERE ordernumber = 'P190806122500391' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401538'
                WHERE ordernumber = 'P180806122507111' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405717'
                WHERE ordernumber = 'P420806122511775' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401538'
                WHERE ordernumber = 'P180806122549493' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137593'
                WHERE ordernumber = 'P190806122705786' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405724'
                WHERE ordernumber = 'P420806123139902' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405727'
                WHERE ordernumber = 'P420806124048331' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405728'
                WHERE ordernumber = 'P180806124908802' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405730'
                WHERE ordernumber = 'P200806125011648' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283775'
                WHERE ordernumber = 'P200806125258555' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212442'
                WHERE ordernumber = 'P180806125341629' 
            
2024-08-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405731'
                WHERE ordernumber = 'P420806125344448' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74449'
                WHERE ordernumber = 'P200806125421538' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405732'
                WHERE ordernumber = 'P420806125556924' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297950'
                WHERE ordernumber = 'P180806130445549' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405737'
                WHERE ordernumber = 'P200806131114171' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353678'
                WHERE ordernumber = 'P200806131223475' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383888'
                WHERE ordernumber = 'P180806131938489' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405739'
                WHERE ordernumber = 'P420806132309251' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405742'
                WHERE ordernumber = 'P420806132524152' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98968'
                WHERE ordernumber = 'P200806132826187' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358932'
                WHERE ordernumber = 'P180806133147973' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234402'
                WHERE ordernumber = 'P200806133911432' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378495'
                WHERE ordernumber = 'P180806133945694' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405746'
                WHERE ordernumber = 'P200806134026254' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95646'
                WHERE ordernumber = 'P420806134241497' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405752'
                WHERE ordernumber = 'P420806134823747' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '36444'
                WHERE ordernumber = 'P630806135300218' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180806135747287' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327883'
                WHERE ordernumber = 'P420806140033947' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405757'
                WHERE ordernumber = 'P200806140233233' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405759'
                WHERE ordernumber = 'P180806140352974' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405763'
                WHERE ordernumber = 'P190806141206775' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327883'
                WHERE ordernumber = 'P420806141438902' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405765'
                WHERE ordernumber = 'P180806141528725' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405768'
                WHERE ordernumber = 'P190806141609557' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405769'
                WHERE ordernumber = 'P180806141718761' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268481'
                WHERE ordernumber = 'P200806141720889' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396266'
                WHERE ordernumber = 'P180806142009222' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405770'
                WHERE ordernumber = 'P200806142050539' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405771'
                WHERE ordernumber = 'P180806142234827' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405774'
                WHERE ordernumber = 'P180806142555401' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237868'
                WHERE ordernumber = 'P180806142822604' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405778'
                WHERE ordernumber = 'P180806143415709' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405779'
                WHERE ordernumber = 'P420806143440665' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405780'
                WHERE ordernumber = 'P180806143741394' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403522'
                WHERE ordernumber = 'P630806143749885' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219149'
                WHERE ordernumber = 'P200806143934199' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317371'
                WHERE ordernumber = 'P180806144022249' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211642'
                WHERE ordernumber = 'P190806144142649' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396508'
                WHERE ordernumber = 'P180806144152565' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317371'
                WHERE ordernumber = 'P180806144412171' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405782'
                WHERE ordernumber = 'P420806144609360' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278884'
                WHERE ordernumber = 'P420806144832970' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405785'
                WHERE ordernumber = 'P420806145218234' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405784'
                WHERE ordernumber = 'P180806145255195' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372783'
                WHERE ordernumber = 'P420806145306946' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405787'
                WHERE ordernumber = 'P190806145632356' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229424'
                WHERE ordernumber = 'P190806145750356' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405789'
                WHERE ordernumber = 'P180806145813770' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405790'
                WHERE ordernumber = 'P420806150155391' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374747'
                WHERE ordernumber = 'P180806150242662' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405790'
                WHERE ordernumber = 'P420806150405322' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405791'
                WHERE ordernumber = 'P200806150527667' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242349'
                WHERE ordernumber = 'P200806150605521' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101722'
                WHERE ordernumber = 'P180806150842934' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215575'
                WHERE ordernumber = 'P180806151233723' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404709'
                WHERE ordernumber = 'P180806151640578' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '55438'
                WHERE ordernumber = 'P420806151640553' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314628'
                WHERE ordernumber = 'P420806151702536' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405796'
                WHERE ordernumber = 'P200806152439885' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81108'
                WHERE ordernumber = 'P180806152457258' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396908'
                WHERE ordernumber = 'P630806152738477' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405797'
                WHERE ordernumber = 'P180806152739601' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291414'
                WHERE ordernumber = 'P180806152827934' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405798'
                WHERE ordernumber = 'P420806153057915' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405799'
                WHERE ordernumber = 'P180806153158256' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405800'
                WHERE ordernumber = 'P190806153241995' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160114'
                WHERE ordernumber = 'P180806153551979' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213101'
                WHERE ordernumber = 'P200806153750493' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350391'
                WHERE ordernumber = 'P200806153839239' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404193'
                WHERE ordernumber = 'P180806154146183' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223991'
                WHERE ordernumber = 'P180806154527413' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320829'
                WHERE ordernumber = 'P180806154647810' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405802'
                WHERE ordernumber = 'P420806154927247' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405804'
                WHERE ordernumber = 'P180806155009479' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317043'
                WHERE ordernumber = 'P200806155512398' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405805'
                WHERE ordernumber = 'P180806155606974' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405806'
                WHERE ordernumber = 'P180806155736389' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405808'
                WHERE ordernumber = 'P180806160020584' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405809'
                WHERE ordernumber = 'P200806160130578' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405810'
                WHERE ordernumber = 'P180806160322710' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405811'
                WHERE ordernumber = 'P180806160533339' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405812'
                WHERE ordernumber = 'P200806160643322' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405813'
                WHERE ordernumber = 'P200806160739428' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305456'
                WHERE ordernumber = 'P200806160826186' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399425'
                WHERE ordernumber = 'P420806161320459' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116607'
                WHERE ordernumber = 'P200806161826717' 
            
2024-08-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337262'
                WHERE ordernumber = 'P420806161939954' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405820'
                WHERE ordernumber = 'P180806162436295' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405822'
                WHERE ordernumber = 'P420806162711483' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405826'
                WHERE ordernumber = 'P180806162906991' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405828'
                WHERE ordernumber = 'P200806163037560' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238689'
                WHERE ordernumber = 'P200806163318730' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400400'
                WHERE ordernumber = 'P420806163352592' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405831'
                WHERE ordernumber = 'P180806163955635' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '223075'
                WHERE ordernumber = 'P190806164222286' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402412'
                WHERE ordernumber = 'P200806164242540' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405833'
                WHERE ordernumber = 'P190806164334679' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405834'
                WHERE ordernumber = 'P190806164510383' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '88849'
                WHERE ordernumber = 'P190806164639856' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405835'
                WHERE ordernumber = 'P420806164641862' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405836'
                WHERE ordernumber = 'P420806165008157' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346714'
                WHERE ordernumber = 'P180806165413987' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313171'
                WHERE ordernumber = 'P180806165854555' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218140'
                WHERE ordernumber = 'P180806170134569' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405843'
                WHERE ordernumber = 'P180806170457221' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405844'
                WHERE ordernumber = 'P180806170619731' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278985'
                WHERE ordernumber = 'P180806170827379' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '154931'
                WHERE ordernumber = 'P180806171559777' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405849'
                WHERE ordernumber = 'P420806172320534' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405850'
                WHERE ordernumber = 'P420806172635521' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '38288'
                WHERE ordernumber = 'P630806172810741' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399587'
                WHERE ordernumber = 'P630806172926678' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405852'
                WHERE ordernumber = 'P180806173121824' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305769'
                WHERE ordernumber = 'P420806173230459' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405853'
                WHERE ordernumber = 'P190806173416381' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379639'
                WHERE ordernumber = 'P630806173731792' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405856'
                WHERE ordernumber = 'P200806173950417' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390543'
                WHERE ordernumber = 'P200806174200610' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405858'
                WHERE ordernumber = 'P180806175004726' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81134'
                WHERE ordernumber = 'P180806175138568' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '308363'
                WHERE ordernumber = 'P180806175508381' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405862'
                WHERE ordernumber = 'P190806180237258' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404707'
                WHERE ordernumber = 'P180806180239669' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238978'
                WHERE ordernumber = 'P180806180442144' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220727'
                WHERE ordernumber = 'P200806180548317' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385743'
                WHERE ordernumber = 'P200806181057812' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405864'
                WHERE ordernumber = 'P180806181423354' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217936'
                WHERE ordernumber = 'P200806181503672' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405154'
                WHERE ordernumber = 'P180806181657448' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '112548'
                WHERE ordernumber = 'P180806182011377' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302037'
                WHERE ordernumber = 'P200806182337514' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405866'
                WHERE ordernumber = 'P180806182340856' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161520'
                WHERE ordernumber = 'P200806183037767' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '144448'
                WHERE ordernumber = 'P180806183106979' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285107'
                WHERE ordernumber = 'P200806183918289' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404307'
                WHERE ordernumber = 'P420806184407909' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '168433'
                WHERE ordernumber = 'P180806184613225' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405867'
                WHERE ordernumber = 'P200806185243865' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400061'
                WHERE ordernumber = 'P200806185836985' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405869'
                WHERE ordernumber = 'P180806190005705' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405869'
                WHERE ordernumber = 'P190806190600711' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '201824'
                WHERE ordernumber = 'P190806190724975' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '61566'
                WHERE ordernumber = 'P190806190808287' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405870'
                WHERE ordernumber = 'P190806190947356' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405871'
                WHERE ordernumber = 'P200806191035457' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405873'
                WHERE ordernumber = 'P190806191114147' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405874'
                WHERE ordernumber = 'P190806191342928' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405874'
                WHERE ordernumber = 'P190806191622435' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405875'
                WHERE ordernumber = 'P190806191746298' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405875'
                WHERE ordernumber = 'P190806191830159' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386588'
                WHERE ordernumber = 'P190806192241409' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405877'
                WHERE ordernumber = 'P200806192316366' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405878'
                WHERE ordernumber = 'P190806192449673' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405883'
                WHERE ordernumber = 'P190806192900861' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389567'
                WHERE ordernumber = 'P200806192936518' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405884'
                WHERE ordernumber = 'P190806193106427' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405886'
                WHERE ordernumber = 'P190806193406343' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217463'
                WHERE ordernumber = 'P630806193452682' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '77098'
                WHERE ordernumber = 'P200806194228528' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96739'
                WHERE ordernumber = 'P190806194243185' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304369'
                WHERE ordernumber = 'P630806194538209' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219253'
                WHERE ordernumber = 'P200806194948326' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348956'
                WHERE ordernumber = 'P190806195212475' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405888'
                WHERE ordernumber = 'P200806195219483' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405892'
                WHERE ordernumber = 'P200806195849875' 
            
2024-08-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405893'
                WHERE ordernumber = 'P200806200045966'