2024-03-09 01:00:02 -- 將會員中心id寫入data-lake
2024-03-09 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-03-08%';
        
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94231'
                WHERE ordernumber = 'P200308105959820' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239205'
                WHERE ordernumber = 'P180308110220253' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127781'
                WHERE ordernumber = 'P200308110245442' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P180308110333359' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95043'
                WHERE ordernumber = 'P200308110334245' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380568'
                WHERE ordernumber = 'P200308110457547' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209274'
                WHERE ordernumber = 'P180308110532403' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380569'
                WHERE ordernumber = 'P420308110537250' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380570'
                WHERE ordernumber = 'P180308110823483' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380571'
                WHERE ordernumber = 'P180308111008347' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380572'
                WHERE ordernumber = 'P200308111157794' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270405'
                WHERE ordernumber = 'P180308111230813' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270643'
                WHERE ordernumber = 'P200308111235751' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380573'
                WHERE ordernumber = 'P180308111355817' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380574'
                WHERE ordernumber = 'P420308111425533' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380575'
                WHERE ordernumber = 'P200308111512947' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380576'
                WHERE ordernumber = 'P180308111535613' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380577'
                WHERE ordernumber = 'P200308111859570' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380578'
                WHERE ordernumber = 'P200308112235310' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '323090'
                WHERE ordernumber = 'P180308112409730' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275674'
                WHERE ordernumber = 'P180308112507458' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380065'
                WHERE ordernumber = 'P200308112811164' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '140510'
                WHERE ordernumber = 'P180308112817961' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97938'
                WHERE ordernumber = 'P200308112906956' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272843'
                WHERE ordernumber = 'P200308113113339' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347607'
                WHERE ordernumber = 'P420308113209331' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284262'
                WHERE ordernumber = 'P180308113320185' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218728'
                WHERE ordernumber = 'P200308114118525' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348555'
                WHERE ordernumber = 'P190308114746413' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380581'
                WHERE ordernumber = 'P420308115505856' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380582'
                WHERE ordernumber = 'P190308115916666' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '186142'
                WHERE ordernumber = 'P180308115919695' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380584'
                WHERE ordernumber = 'P190308120126797' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111709'
                WHERE ordernumber = 'P180308120139473' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380583'
                WHERE ordernumber = 'P420308120140247' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380580'
                WHERE ordernumber = 'P590308120210808' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380585'
                WHERE ordernumber = 'P190308120801346' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380586'
                WHERE ordernumber = 'P420308121010804' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380587'
                WHERE ordernumber = 'P200308121123796' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380297'
                WHERE ordernumber = 'P590308121827699' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380589'
                WHERE ordernumber = 'P180308121952219' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380588'
                WHERE ordernumber = 'P200308122006578' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277922'
                WHERE ordernumber = 'P420308122603190' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380591'
                WHERE ordernumber = 'P420308123221204' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380592'
                WHERE ordernumber = 'P180308123309823' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380593'
                WHERE ordernumber = 'P200308123331199' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380452'
                WHERE ordernumber = 'P190308123508288' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380595'
                WHERE ordernumber = 'P200308123701425' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378334'
                WHERE ordernumber = 'P420308123709511' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378334'
                WHERE ordernumber = 'P420308123739389' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380596'
                WHERE ordernumber = 'P180308124348364' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369434'
                WHERE ordernumber = 'P200308124405540' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380594'
                WHERE ordernumber = 'P590308124430997' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '190141'
                WHERE ordernumber = 'P200308124442569' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380597'
                WHERE ordernumber = 'P180308124819836' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380598'
                WHERE ordernumber = 'P420308125049419' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380599'
                WHERE ordernumber = 'P420308125309367' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '33821'
                WHERE ordernumber = 'P200308125605493' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116208'
                WHERE ordernumber = 'P420308125810607' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380600'
                WHERE ordernumber = 'P420308130124831' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380601'
                WHERE ordernumber = 'P200308130239653' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284082'
                WHERE ordernumber = 'P180308130310702' 
            
2024-03-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363488'
                WHERE ordernumber = 'P180308130411937' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380202'
                WHERE ordernumber = 'P200308130520612' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338779'
                WHERE ordernumber = 'P420308130540282' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380602'
                WHERE ordernumber = 'P180308130809169' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277521'
                WHERE ordernumber = 'P200308130930130' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372200'
                WHERE ordernumber = 'P180308131152470' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265945'
                WHERE ordernumber = 'P190308131443299' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377388'
                WHERE ordernumber = 'P200308131719481' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290492'
                WHERE ordernumber = 'P180308131738806' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365634'
                WHERE ordernumber = 'P190308132029926' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '19347'
                WHERE ordernumber = 'P200308132237348' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248368'
                WHERE ordernumber = 'P200308133125968' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380606'
                WHERE ordernumber = 'P200308133743707' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379828'
                WHERE ordernumber = 'P200308133933236' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379914'
                WHERE ordernumber = 'P200308134018780' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359171'
                WHERE ordernumber = 'P180308134133244' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380328'
                WHERE ordernumber = 'P200308134246786' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124068'
                WHERE ordernumber = 'P180308134258969' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380607'
                WHERE ordernumber = 'P200308134834404' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320785'
                WHERE ordernumber = 'P200308135644967' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380609'
                WHERE ordernumber = 'P200308135758699' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286064'
                WHERE ordernumber = 'P200308135836391' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141900'
                WHERE ordernumber = 'P420308140227911' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275675'
                WHERE ordernumber = 'P180308140320423' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380610'
                WHERE ordernumber = 'P180308140614621' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380525'
                WHERE ordernumber = 'P180308140710376' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264003'
                WHERE ordernumber = 'P180308141036657' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380613'
                WHERE ordernumber = 'P200308141323494' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166122'
                WHERE ordernumber = 'P180308141809816' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380614'
                WHERE ordernumber = 'P180308141943266' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376355'
                WHERE ordernumber = 'P180308142114282' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364057'
                WHERE ordernumber = 'P200308142224340' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380615'
                WHERE ordernumber = 'P200308142405219' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380616'
                WHERE ordernumber = 'P180308142446695' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180308142631656' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380617'
                WHERE ordernumber = 'P590308143008128' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245281'
                WHERE ordernumber = 'P200308143236216' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380620'
                WHERE ordernumber = 'P420308143237738' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380621'
                WHERE ordernumber = 'P180308143728347' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380622'
                WHERE ordernumber = 'P190308144046159' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366066'
                WHERE ordernumber = 'P180308144244179' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279309'
                WHERE ordernumber = 'P180308144542626' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162857'
                WHERE ordernumber = 'P200308144758503' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380625'
                WHERE ordernumber = 'P180308144844555' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162857'
                WHERE ordernumber = 'P200308144858694' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380626'
                WHERE ordernumber = 'P190308144955853' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380625'
                WHERE ordernumber = 'P180308145049477' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315980'
                WHERE ordernumber = 'P590308145200968' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380627'
                WHERE ordernumber = 'P420308145927306' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336615'
                WHERE ordernumber = 'P180308150604117' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380629'
                WHERE ordernumber = 'P190308150803986' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380630'
                WHERE ordernumber = 'P190308150941487' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380631'
                WHERE ordernumber = 'P190308151050897' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380628'
                WHERE ordernumber = 'P590308151131592' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341049'
                WHERE ordernumber = 'P190308151139627' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337729'
                WHERE ordernumber = 'P420308151157308' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380633'
                WHERE ordernumber = 'P190308151459577' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258048'
                WHERE ordernumber = 'P200308151600278' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380634'
                WHERE ordernumber = 'P420308152009464' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380635'
                WHERE ordernumber = 'P200308152217638' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125508'
                WHERE ordernumber = 'P420308152310779' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380636'
                WHERE ordernumber = 'P180308152347573' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380637'
                WHERE ordernumber = 'P200308152520599' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163217'
                WHERE ordernumber = 'P200308152631305' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380638'
                WHERE ordernumber = 'P420308152723521' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380640'
                WHERE ordernumber = 'P420308153128630' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380641'
                WHERE ordernumber = 'P420308153328469' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380275'
                WHERE ordernumber = 'P180308153634902' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374299'
                WHERE ordernumber = 'P190308153837628' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380275'
                WHERE ordernumber = 'P180308153932974' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380642'
                WHERE ordernumber = 'P420308154444747' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380643'
                WHERE ordernumber = 'P200308154704540' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380645'
                WHERE ordernumber = 'P190308154719489' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236194'
                WHERE ordernumber = 'P180308154744135' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '184031'
                WHERE ordernumber = 'P200308154815735' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380647'
                WHERE ordernumber = 'P200308154918220' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380646'
                WHERE ordernumber = 'P200308155014120' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380644'
                WHERE ordernumber = 'P200308155035371' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380648'
                WHERE ordernumber = 'P200308155417548' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299335'
                WHERE ordernumber = 'P180308155541811' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380649'
                WHERE ordernumber = 'P200308155548229' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380649'
                WHERE ordernumber = 'P200308155640197' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380650'
                WHERE ordernumber = 'P190308160121993' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380199'
                WHERE ordernumber = 'P420308160304135' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '52478'
                WHERE ordernumber = 'P180308160358237' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212330'
                WHERE ordernumber = 'P200308162410209' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275563'
                WHERE ordernumber = 'P200308162500465' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224399'
                WHERE ordernumber = 'P200308162812760' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377167'
                WHERE ordernumber = 'P420308162901397' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224573'
                WHERE ordernumber = 'P200308163246340' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133618'
                WHERE ordernumber = 'P180308163400773' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380651'
                WHERE ordernumber = 'P420308163438644' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380652'
                WHERE ordernumber = 'P200308163600500' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351584'
                WHERE ordernumber = 'P420308163711958' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351584'
                WHERE ordernumber = 'P420308163755845' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261909'
                WHERE ordernumber = 'P180308164545892' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343232'
                WHERE ordernumber = 'P180308164940225' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374267'
                WHERE ordernumber = 'P420308165059224' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380653'
                WHERE ordernumber = 'P180308165432715' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347362'
                WHERE ordernumber = 'P180308165558799' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380654'
                WHERE ordernumber = 'P420308165852963' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380655'
                WHERE ordernumber = 'P180308170124622' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293946'
                WHERE ordernumber = 'P180308170312625' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378025'
                WHERE ordernumber = 'P200308170656976' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380657'
                WHERE ordernumber = 'P420308171628457' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380658'
                WHERE ordernumber = 'P180308171705731' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380659'
                WHERE ordernumber = 'P180308171819697' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380661'
                WHERE ordernumber = 'P180308171944120' 
            
2024-03-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379940'
                WHERE ordernumber = 'P200308171954967' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380662'
                WHERE ordernumber = 'P180308172151631' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228801'
                WHERE ordernumber = 'P180308172257619' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380301'
                WHERE ordernumber = 'P200308172340996' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380663'
                WHERE ordernumber = 'P200308172823964' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380664'
                WHERE ordernumber = 'P200308173124774' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380665'
                WHERE ordernumber = 'P180308173511492' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343835'
                WHERE ordernumber = 'P420308173630973' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343835'
                WHERE ordernumber = 'P420308173756867' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '49345'
                WHERE ordernumber = 'P200308174115280' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380666'
                WHERE ordernumber = 'P180308174114271' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266141'
                WHERE ordernumber = 'P200308174157272' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275394'
                WHERE ordernumber = 'P200308174229448' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277109'
                WHERE ordernumber = 'P200308174320747' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380667'
                WHERE ordernumber = 'P180308174320994' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346485'
                WHERE ordernumber = 'P180308174918425' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380668'
                WHERE ordernumber = 'P200308175034789' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251676'
                WHERE ordernumber = 'P180308175230562' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337596'
                WHERE ordernumber = 'P200308175304679' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95310'
                WHERE ordernumber = 'P190308175314661' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380669'
                WHERE ordernumber = 'P420308175356854' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95565'
                WHERE ordernumber = 'P180308175444843' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303767'
                WHERE ordernumber = 'P420308175601485' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333855'
                WHERE ordernumber = 'P180308175718984' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380670'
                WHERE ordernumber = 'P200308180214677' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380671'
                WHERE ordernumber = 'P180308180458542' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380672'
                WHERE ordernumber = 'P200308180515579' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380673'
                WHERE ordernumber = 'P190308180638683' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '85910'
                WHERE ordernumber = 'P180308180726380' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380674'
                WHERE ordernumber = 'P180308181827344' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380675'
                WHERE ordernumber = 'P200308181840818' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96100'
                WHERE ordernumber = 'P190308182041778' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380678'
                WHERE ordernumber = 'P200308182123841' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380679'
                WHERE ordernumber = 'P190308182415609' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380680'
                WHERE ordernumber = 'P420308182708563' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349826'
                WHERE ordernumber = 'P190308183021552' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380681'
                WHERE ordernumber = 'P200308183912396' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112218'
                WHERE ordernumber = 'P190308184044889' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379516'
                WHERE ordernumber = 'P420308184259160' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112218'
                WHERE ordernumber = 'P190308184314253' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255356'
                WHERE ordernumber = 'P190308184942507' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81933'
                WHERE ordernumber = 'P200308185015925' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212330'
                WHERE ordernumber = 'P200308185051841' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380682'
                WHERE ordernumber = 'P190308185107480' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380684'
                WHERE ordernumber = 'P420308185147932' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266600'
                WHERE ordernumber = 'P190308185350905' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104508'
                WHERE ordernumber = 'P190308185454720' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380686'
                WHERE ordernumber = 'P200308185552938' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380683'
                WHERE ordernumber = 'P200308185701842' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349185'
                WHERE ordernumber = 'P190308185711476' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380687'
                WHERE ordernumber = 'P420308190056965' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105986'
                WHERE ordernumber = 'P190308190207973' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380691'
                WHERE ordernumber = 'P420308190906136' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167388'
                WHERE ordernumber = 'P200308190932483' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380689'
                WHERE ordernumber = 'P190308191051354' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271915'
                WHERE ordernumber = 'P200308191409566' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380692'
                WHERE ordernumber = 'P420308191507552' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351463'
                WHERE ordernumber = 'P190308191745710' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380693'
                WHERE ordernumber = 'P420308191838579' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380688'
                WHERE ordernumber = 'P190308192604685' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380694'
                WHERE ordernumber = 'P190308193448784' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380695'
                WHERE ordernumber = 'P420308193607991' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378763'
                WHERE ordernumber = 'P200308193851491' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99971'
                WHERE ordernumber = 'P200308194012407' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380696'
                WHERE ordernumber = 'P420308194103482' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343808'
                WHERE ordernumber = 'P200308194118862' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380697'
                WHERE ordernumber = 'P190308194451149' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347700'
                WHERE ordernumber = 'P190308194715279' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380698'
                WHERE ordernumber = 'P200308194820897' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303576'
                WHERE ordernumber = 'P190308194937501' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236620'
                WHERE ordernumber = 'P190308195010990' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380699'
                WHERE ordernumber = 'P190308195316573' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '170293'
                WHERE ordernumber = 'P190308195412965' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254412'
                WHERE ordernumber = 'P190308195525829' 
            
2024-03-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236243'
                WHERE ordernumber = 'P200308195829114'