2024-05-21 01:00:01 -- 將會員中心id寫入data-lake
2024-05-21 01:00:01 -- 
            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-05-20%';
        
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '221802'
                WHERE ordernumber = 'P180520110645661' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '352006'
                WHERE ordernumber = 'P200520111232942' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '308957'
                WHERE ordernumber = 'P420520111242452' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '390916'
                WHERE ordernumber = 'P420520111947969' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '390917'
                WHERE ordernumber = 'P180520112501688' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '390918'
                WHERE ordernumber = 'P190520112520211' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '385825'
                WHERE ordernumber = 'P180520112632138' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '113488'
                WHERE ordernumber = 'P180520112855150' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '358464'
                WHERE ordernumber = 'P180520113537910' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '390920'
                WHERE ordernumber = 'P190520113615715' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '367183'
                WHERE ordernumber = 'P200520114104236' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '99933'
                WHERE ordernumber = 'P200520114209807' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '390923'
                WHERE ordernumber = 'P200520115234522' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '306474'
                WHERE ordernumber = 'P630520115644409' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '133547'
                WHERE ordernumber = 'P200520115806932' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '321668'
                WHERE ordernumber = 'P420520120030111' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '390924'
                WHERE ordernumber = 'P180520120355867' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '82007'
                WHERE ordernumber = 'P190520120530782' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '390925'
                WHERE ordernumber = 'P710520121110662' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '390926'
                WHERE ordernumber = 'P180520121115691' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '306481'
                WHERE ordernumber = 'P420520121205888' 
            
2024-05-21 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '390927'
                WHERE ordernumber = 'P180520121256484' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136792'
                WHERE ordernumber = 'P190520121333740' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218516'
                WHERE ordernumber = 'P190520121438690' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242518'
                WHERE ordernumber = 'P180520121627845' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289522'
                WHERE ordernumber = 'P190520121727145' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286575'
                WHERE ordernumber = 'P180520122235971' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385427'
                WHERE ordernumber = 'P200520124121777' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200520124314364' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390930'
                WHERE ordernumber = 'P180520125805480' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390931'
                WHERE ordernumber = 'P420520125831137' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212212'
                WHERE ordernumber = 'P190520125842468' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328235'
                WHERE ordernumber = 'P420520130105496' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390932'
                WHERE ordernumber = 'P180520130627808' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390900'
                WHERE ordernumber = 'P180520131044286' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385618'
                WHERE ordernumber = 'P420520131249240' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143853'
                WHERE ordernumber = 'P180520131507483' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390934'
                WHERE ordernumber = 'P180520131756721' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314569'
                WHERE ordernumber = 'P180520132219412' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390935'
                WHERE ordernumber = 'P790520132307477' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '74817'
                WHERE ordernumber = 'P420520132309141' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390937'
                WHERE ordernumber = 'P180520133212660' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '87091'
                WHERE ordernumber = 'P180520133630343' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390940'
                WHERE ordernumber = 'P190520133732137' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390941'
                WHERE ordernumber = 'P790520133939674' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390942'
                WHERE ordernumber = 'P200520134142501' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97445'
                WHERE ordernumber = 'P180520134147349' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390944'
                WHERE ordernumber = 'P200520134908914' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390946'
                WHERE ordernumber = 'P200520135411119' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390948'
                WHERE ordernumber = 'P180520135954472' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286023'
                WHERE ordernumber = 'P790520140404755' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390950'
                WHERE ordernumber = 'P710520140756741' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390950'
                WHERE ordernumber = 'P710520140925496' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390955'
                WHERE ordernumber = 'P200520141615880' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390954'
                WHERE ordernumber = 'P790520141636337' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390957'
                WHERE ordernumber = 'P790520141737873' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390956'
                WHERE ordernumber = 'P790520141953756' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P190520142829393' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '207158'
                WHERE ordernumber = 'P180520142933582' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180520143207684' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390962'
                WHERE ordernumber = 'P200520143930145' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390961'
                WHERE ordernumber = 'P710520144207505' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390963'
                WHERE ordernumber = 'P630520144314802' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '108151'
                WHERE ordernumber = 'P710520144446451' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '157229'
                WHERE ordernumber = 'P200520144913622' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387771'
                WHERE ordernumber = 'P790520145031532' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305444'
                WHERE ordernumber = 'P420520145152796' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390964'
                WHERE ordernumber = 'P710520145634820' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390965'
                WHERE ordernumber = 'P420520145823705' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390966'
                WHERE ordernumber = 'P200520150546113' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390968'
                WHERE ordernumber = 'P180520151159925' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389183'
                WHERE ordernumber = 'P200520151649554' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390970'
                WHERE ordernumber = 'P790520151702465' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389183'
                WHERE ordernumber = 'P200520151740615' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390969'
                WHERE ordernumber = 'P710520151838751' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390971'
                WHERE ordernumber = 'P180520151917126' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384921'
                WHERE ordernumber = 'P190520152225970' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390972'
                WHERE ordernumber = 'P790520152441498' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390911'
                WHERE ordernumber = 'P190520152501212' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217445'
                WHERE ordernumber = 'P190520152719870' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389657'
                WHERE ordernumber = 'P180520152854746' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390974'
                WHERE ordernumber = 'P190520152858666' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389657'
                WHERE ordernumber = 'P180520152904269' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P190520153046373' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387858'
                WHERE ordernumber = 'P200520153210779' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390975'
                WHERE ordernumber = 'P200520153342408' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390977'
                WHERE ordernumber = 'P420520153451719' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390976'
                WHERE ordernumber = 'P710520153712336' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390978'
                WHERE ordernumber = 'P710520153852364' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90395'
                WHERE ordernumber = 'P630520153905750' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390979'
                WHERE ordernumber = 'P200520154039736' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390980'
                WHERE ordernumber = 'P420520154108735' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363339'
                WHERE ordernumber = 'P200520154203351' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309439'
                WHERE ordernumber = 'P180520154339420' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390982'
                WHERE ordernumber = 'P790520154617173' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309439'
                WHERE ordernumber = 'P180520154740973' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390983'
                WHERE ordernumber = 'P200520154857963' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339562'
                WHERE ordernumber = 'P420520154916694' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390984'
                WHERE ordernumber = 'P710520154951635' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390986'
                WHERE ordernumber = 'P180520155224362' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390987'
                WHERE ordernumber = 'P200520155412878' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '69101'
                WHERE ordernumber = 'P790520155958473' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390989'
                WHERE ordernumber = 'P180520160059756' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390988'
                WHERE ordernumber = 'P180520160603400' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380749'
                WHERE ordernumber = 'P200520161122291' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390991'
                WHERE ordernumber = 'P790520161317150' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258305'
                WHERE ordernumber = 'P200520161425539' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390992'
                WHERE ordernumber = 'P420520161434587' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390993'
                WHERE ordernumber = 'P200520161522648' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390994'
                WHERE ordernumber = 'P200520161805254' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384798'
                WHERE ordernumber = 'P180520162301335' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390996'
                WHERE ordernumber = 'P420520162616268' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390995'
                WHERE ordernumber = 'P790520162627847' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390997'
                WHERE ordernumber = 'P420520162736621' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101144'
                WHERE ordernumber = 'P200520163724169' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102958'
                WHERE ordernumber = 'P200520163821242' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '165349'
                WHERE ordernumber = 'P180520163921195' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390999'
                WHERE ordernumber = 'P180520164244522' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '192237'
                WHERE ordernumber = 'P180520164438959' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391000'
                WHERE ordernumber = 'P710520164838448' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391002'
                WHERE ordernumber = 'P200520170417608' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312984'
                WHERE ordernumber = 'P180520170520329' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391003'
                WHERE ordernumber = 'P190520170545433' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391005'
                WHERE ordernumber = 'P200520171110223' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391004'
                WHERE ordernumber = 'P790520171112288' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275007'
                WHERE ordernumber = 'P200520171143782' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391006'
                WHERE ordernumber = 'P190520171252118' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384980'
                WHERE ordernumber = 'P200520171435821' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97663'
                WHERE ordernumber = 'P200520171516250' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391007'
                WHERE ordernumber = 'P180520171659907' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391008'
                WHERE ordernumber = 'P710520172118954' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285587'
                WHERE ordernumber = 'P200520172157223' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269812'
                WHERE ordernumber = 'P190520172314683' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391010'
                WHERE ordernumber = 'P180520172951872' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391012'
                WHERE ordernumber = 'P420520173655333' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257130'
                WHERE ordernumber = 'P180520174021773' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391015'
                WHERE ordernumber = 'P200520174432529' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391017'
                WHERE ordernumber = 'P200520174516335' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391019'
                WHERE ordernumber = 'P200520174745292' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391016'
                WHERE ordernumber = 'P420520174756149' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340529'
                WHERE ordernumber = 'P200520174831203' 
            
2024-05-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391020'
                WHERE ordernumber = 'P190520175045531' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391021'
                WHERE ordernumber = 'P420520175330882' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391022'
                WHERE ordernumber = 'P200520175748696' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384979'
                WHERE ordernumber = 'P200520180108564' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241324'
                WHERE ordernumber = 'P180520180540414' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391024'
                WHERE ordernumber = 'P180520180651471' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297428'
                WHERE ordernumber = 'P420520180711749' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102338'
                WHERE ordernumber = 'P200520181306635' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132012'
                WHERE ordernumber = 'P200520181439824' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384070'
                WHERE ordernumber = 'P180520181721681' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391026'
                WHERE ordernumber = 'P180520182103575' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361146'
                WHERE ordernumber = 'P200520182335944' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210579'
                WHERE ordernumber = 'P190520182629998' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391027'
                WHERE ordernumber = 'P190520182813143' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145817'
                WHERE ordernumber = 'P710520183539855' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390184'
                WHERE ordernumber = 'P420520183639348' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391028'
                WHERE ordernumber = 'P200520183749840' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391029'
                WHERE ordernumber = 'P200520185328882' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279861'
                WHERE ordernumber = 'P190520185711727' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391031'
                WHERE ordernumber = 'P200520190038901' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391033'
                WHERE ordernumber = 'P420520190803344' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377960'
                WHERE ordernumber = 'P200520191202330' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '75984'
                WHERE ordernumber = 'P190520191826468' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226592'
                WHERE ordernumber = 'P190520191953461' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391035'
                WHERE ordernumber = 'P790520192152582' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287653'
                WHERE ordernumber = 'P200520192213966' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278196'
                WHERE ordernumber = 'P190520193458884' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237701'
                WHERE ordernumber = 'P420520193647890' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391037'
                WHERE ordernumber = 'P420520193940672' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391039'
                WHERE ordernumber = 'P190520194414955' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216772'
                WHERE ordernumber = 'P630520194639235' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391040'
                WHERE ordernumber = 'P190520194741370' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391046'
                WHERE ordernumber = 'P710520205202334' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391049'
                WHERE ordernumber = 'P710520211631974' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387744'
                WHERE ordernumber = 'P630520212100728' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391053'
                WHERE ordernumber = 'P710520213622643' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391057'
                WHERE ordernumber = 'P710520214438896' 
            
2024-05-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391055'
                WHERE ordernumber = 'P790520215402463'