2024-04-20 01:00:02 -- 將會員中心id寫入data-lake
2024-04-20 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-04-19%';
        
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332639'
                WHERE ordernumber = 'P630419103532118' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136644'
                WHERE ordernumber = 'P180419110147305' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386070'
                WHERE ordernumber = 'P630419110149254' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382636'
                WHERE ordernumber = 'P190419110159330' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386071'
                WHERE ordernumber = 'P630419110200512' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386007'
                WHERE ordernumber = 'P200419110402770' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164176'
                WHERE ordernumber = 'P200419110504367' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386072'
                WHERE ordernumber = 'P180419110540994' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386073'
                WHERE ordernumber = 'P190419110607310' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386074'
                WHERE ordernumber = 'P190419110647350' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118908'
                WHERE ordernumber = 'P180419110724525' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '203006'
                WHERE ordernumber = 'P190419110857572' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271903'
                WHERE ordernumber = 'P420419110933617' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353917'
                WHERE ordernumber = 'P180419111412572' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386075'
                WHERE ordernumber = 'P190419111423613' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386076'
                WHERE ordernumber = 'P190419111614730' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114527'
                WHERE ordernumber = 'P200419111932572' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386078'
                WHERE ordernumber = 'P180419111938160' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291533'
                WHERE ordernumber = 'P200419112138175' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347607'
                WHERE ordernumber = 'P420419112247470' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386079'
                WHERE ordernumber = 'P200419112523403' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386080'
                WHERE ordernumber = 'P200419112657537' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312800'
                WHERE ordernumber = 'P180419112733321' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386081'
                WHERE ordernumber = 'P630419112956191' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386082'
                WHERE ordernumber = 'P420419113201608' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383175'
                WHERE ordernumber = 'P190419113536926' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271033'
                WHERE ordernumber = 'P200419113709548' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350529'
                WHERE ordernumber = 'P200419113900932' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386083'
                WHERE ordernumber = 'P180419114447955' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331560'
                WHERE ordernumber = 'P180419114538364' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386084'
                WHERE ordernumber = 'P200419114616411' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386085'
                WHERE ordernumber = 'P420419114704277' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352496'
                WHERE ordernumber = 'P200419114806468' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298619'
                WHERE ordernumber = 'P420419114825338' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240584'
                WHERE ordernumber = 'P200419115229835' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386086'
                WHERE ordernumber = 'P420419115955916' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276944'
                WHERE ordernumber = 'P200419120008325' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371964'
                WHERE ordernumber = 'P420419120230579' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386088'
                WHERE ordernumber = 'P420419121905244' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386029'
                WHERE ordernumber = 'P180419122054286' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '227590'
                WHERE ordernumber = 'P200419122248350' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P180419122633989' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100968'
                WHERE ordernumber = 'P200419122718821' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '89018'
                WHERE ordernumber = 'P190419122859647' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386089'
                WHERE ordernumber = 'P630419122958288' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102068'
                WHERE ordernumber = 'P190419123014281' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287408'
                WHERE ordernumber = 'P180419123517398' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386090'
                WHERE ordernumber = 'P180419123751485' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386091'
                WHERE ordernumber = 'P180419124048778' 
            
2024-04-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386092'
                WHERE ordernumber = 'P200419124111462' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384910'
                WHERE ordernumber = 'P180419124253307' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384910'
                WHERE ordernumber = 'P180419124318697' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345655'
                WHERE ordernumber = 'P200419124551910' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172874'
                WHERE ordernumber = 'P180419124928223' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386094'
                WHERE ordernumber = 'P420419125406364' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386095'
                WHERE ordernumber = 'P200419125448468' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382566'
                WHERE ordernumber = 'P420419125600326' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382548'
                WHERE ordernumber = 'P590419125720281' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386096'
                WHERE ordernumber = 'P200419130308567' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248874'
                WHERE ordernumber = 'P180419130348414' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386097'
                WHERE ordernumber = 'P180419130612255' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97293'
                WHERE ordernumber = 'P200419130811413' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386098'
                WHERE ordernumber = 'P420419131109187' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386099'
                WHERE ordernumber = 'P420419131337731' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293225'
                WHERE ordernumber = 'P180419131422377' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385428'
                WHERE ordernumber = 'P590419131658143' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258488'
                WHERE ordernumber = 'P180419132225362' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386100'
                WHERE ordernumber = 'P420419132341782' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250500'
                WHERE ordernumber = 'P420419133123891' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386101'
                WHERE ordernumber = 'P180419133149507' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385688'
                WHERE ordernumber = 'P200419133723252' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385688'
                WHERE ordernumber = 'P200419133752792' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386102'
                WHERE ordernumber = 'P630419134038207' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385635'
                WHERE ordernumber = 'P180419134126776' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111012'
                WHERE ordernumber = 'P180419134544549' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386104'
                WHERE ordernumber = 'P200419135239836' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96900'
                WHERE ordernumber = 'P180419135348656' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345528'
                WHERE ordernumber = 'P420419135428311' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '51539'
                WHERE ordernumber = 'P180419135825462' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386105'
                WHERE ordernumber = 'P420419135941275' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212330'
                WHERE ordernumber = 'P200419140057354' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236167'
                WHERE ordernumber = 'P200419140221136' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305697'
                WHERE ordernumber = 'P190419140255587' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386106'
                WHERE ordernumber = 'P420419140359319' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386107'
                WHERE ordernumber = 'P190419141037805' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386108'
                WHERE ordernumber = 'P180419141136408' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386108'
                WHERE ordernumber = 'P180419141433329' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353694'
                WHERE ordernumber = 'P190419141541461' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386109'
                WHERE ordernumber = 'P420419141841479' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386110'
                WHERE ordernumber = 'P200419142213386' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '30556'
                WHERE ordernumber = 'P190419142250795' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386056'
                WHERE ordernumber = 'P180419142408755' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386056'
                WHERE ordernumber = 'P180419142428725' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312984'
                WHERE ordernumber = 'P190419142537706' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130789'
                WHERE ordernumber = 'P180419143601492' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309849'
                WHERE ordernumber = 'P180419143823313' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386112'
                WHERE ordernumber = 'P190419143833522' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386113'
                WHERE ordernumber = 'P420419144102576' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386114'
                WHERE ordernumber = 'P190419144507270' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100896'
                WHERE ordernumber = 'P180419144711801' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112682'
                WHERE ordernumber = 'P180419145026204' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136443'
                WHERE ordernumber = 'P200419145308282' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386115'
                WHERE ordernumber = 'P420419145757918' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348562'
                WHERE ordernumber = 'P180419145824295' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386117'
                WHERE ordernumber = 'P200419145909870' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297805'
                WHERE ordernumber = 'P200419150315578' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386119'
                WHERE ordernumber = 'P180419150528142' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386120'
                WHERE ordernumber = 'P200419150815526' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218542'
                WHERE ordernumber = 'P180419151442224' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386121'
                WHERE ordernumber = 'P180419152028766' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386122'
                WHERE ordernumber = 'P200419152416175' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386123'
                WHERE ordernumber = 'P180419152643888' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299720'
                WHERE ordernumber = 'P190419152733749' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300869'
                WHERE ordernumber = 'P420419152823162' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386125'
                WHERE ordernumber = 'P180419152937506' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383119'
                WHERE ordernumber = 'P420419153215336' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230555'
                WHERE ordernumber = 'P200419153257807' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386126'
                WHERE ordernumber = 'P190419153300122' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383119'
                WHERE ordernumber = 'P420419153351217' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335527'
                WHERE ordernumber = 'P190419153510953' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386127'
                WHERE ordernumber = 'P420419153525709' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271189'
                WHERE ordernumber = 'P190419153611293' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271189'
                WHERE ordernumber = 'P180419153817449' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386128'
                WHERE ordernumber = 'P190419154106181' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271189'
                WHERE ordernumber = 'P180419154354338' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386129'
                WHERE ordernumber = 'P200419154632826' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212946'
                WHERE ordernumber = 'P180419154711246' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386130'
                WHERE ordernumber = 'P180419160124530' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214879'
                WHERE ordernumber = 'P180419160429941' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386131'
                WHERE ordernumber = 'P200419160443897' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386133'
                WHERE ordernumber = 'P200419160606661' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '71783'
                WHERE ordernumber = 'P420419161520520' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386135'
                WHERE ordernumber = 'P200419161554403' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360115'
                WHERE ordernumber = 'P180419161601398' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236637'
                WHERE ordernumber = 'P200419161746811' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386136'
                WHERE ordernumber = 'P180419161749172' 
            
2024-04-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386137'
                WHERE ordernumber = 'P190419161809642' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225132'
                WHERE ordernumber = 'P190419162036414' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287386'
                WHERE ordernumber = 'P180419162456963' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366089'
                WHERE ordernumber = 'P630419162950489' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386139'
                WHERE ordernumber = 'P420419163535189' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386142'
                WHERE ordernumber = 'P200419165127615' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213314'
                WHERE ordernumber = 'P190419165716515' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130968'
                WHERE ordernumber = 'P180419165745994' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257299'
                WHERE ordernumber = 'P200419170009510' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386144'
                WHERE ordernumber = 'P420419170039184' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386143'
                WHERE ordernumber = 'P630419170251226' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386145'
                WHERE ordernumber = 'P180419170332156' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287807'
                WHERE ordernumber = 'P420419170547765' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386146'
                WHERE ordernumber = 'P180419170548988' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234780'
                WHERE ordernumber = 'P200419170740114' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386148'
                WHERE ordernumber = 'P200419171119971' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386149'
                WHERE ordernumber = 'P180419171310350' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358469'
                WHERE ordernumber = 'P200419171415509' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299368'
                WHERE ordernumber = 'P630419171456545' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386150'
                WHERE ordernumber = 'P200419171639515' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380361'
                WHERE ordernumber = 'P590419171724711' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386151'
                WHERE ordernumber = 'P190419171740897' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386153'
                WHERE ordernumber = 'P420419172132278' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210229'
                WHERE ordernumber = 'P420419172226969' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349641'
                WHERE ordernumber = 'P180419172327384' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382646'
                WHERE ordernumber = 'P420419172412598' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378510'
                WHERE ordernumber = 'P180419172939250' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96695'
                WHERE ordernumber = 'P180419173027364' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386154'
                WHERE ordernumber = 'P180419173304979' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243518'
                WHERE ordernumber = 'P180419173352159' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386155'
                WHERE ordernumber = 'P420419173445219' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383918'
                WHERE ordernumber = 'P180419173639834' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222680'
                WHERE ordernumber = 'P200419174015468' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104036'
                WHERE ordernumber = 'P180419174639927' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386156'
                WHERE ordernumber = 'P190419174733767' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268715'
                WHERE ordernumber = 'P190419174916287' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386157'
                WHERE ordernumber = 'P420419175004510' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386159'
                WHERE ordernumber = 'P190419175803626' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386160'
                WHERE ordernumber = 'P200419180017917' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379635'
                WHERE ordernumber = 'P200419180101931' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283188'
                WHERE ordernumber = 'P180419180105311' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P200419180137646' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269816'
                WHERE ordernumber = 'P200419180327374' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340532'
                WHERE ordernumber = 'P420419180453620' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310793'
                WHERE ordernumber = 'P180419181245368' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283520'
                WHERE ordernumber = 'P200419181737984' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125653'
                WHERE ordernumber = 'P180419182118238' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283749'
                WHERE ordernumber = 'P200419182243878' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282020'
                WHERE ordernumber = 'P190419182412340' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64160'
                WHERE ordernumber = 'P180419182428294' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375533'
                WHERE ordernumber = 'P190419182513242' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386162'
                WHERE ordernumber = 'P180419182553778' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386163'
                WHERE ordernumber = 'P190419182704514' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214589'
                WHERE ordernumber = 'P190419182953317' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359812'
                WHERE ordernumber = 'P190419183124356' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386164'
                WHERE ordernumber = 'P200419183157143' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343629'
                WHERE ordernumber = 'P200419183307660' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243002'
                WHERE ordernumber = 'P200419183346321' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356438'
                WHERE ordernumber = 'P200419183737707' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386165'
                WHERE ordernumber = 'P200419183842172' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386167'
                WHERE ordernumber = 'P200419184111303' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386168'
                WHERE ordernumber = 'P190419184315876' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214728'
                WHERE ordernumber = 'P190419184422834' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P420419184443814' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296046'
                WHERE ordernumber = 'P630419185011700' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386169'
                WHERE ordernumber = 'P190419185018584' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385818'
                WHERE ordernumber = 'P200419185209608' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386170'
                WHERE ordernumber = 'P190419185224214' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386170'
                WHERE ordernumber = 'P190419185342249' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321982'
                WHERE ordernumber = 'P420419185434581' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98992'
                WHERE ordernumber = 'P190419190926784' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386171'
                WHERE ordernumber = 'P200419190950151' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309869'
                WHERE ordernumber = 'P420419191026375' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386172'
                WHERE ordernumber = 'P190419191110611' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161831'
                WHERE ordernumber = 'P630419191322523' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259831'
                WHERE ordernumber = 'P420419191336951' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386173'
                WHERE ordernumber = 'P420419191824593' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334987'
                WHERE ordernumber = 'P420419191902291' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '24372'
                WHERE ordernumber = 'P200419192923112' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386175'
                WHERE ordernumber = 'P200419193041468' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386176'
                WHERE ordernumber = 'P590419193306506' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386162'
                WHERE ordernumber = 'P190419193513610' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246436'
                WHERE ordernumber = 'P190419193908980' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386177'
                WHERE ordernumber = 'P630419194348845' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386178'
                WHERE ordernumber = 'P630419201805324' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386180'
                WHERE ordernumber = 'P630419205627576' 
            
2024-04-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346893'
                WHERE ordernumber = 'P630419212022918' 
            
2024-04-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386184'
                WHERE ordernumber = 'P630419215448366'