2024-05-01 01:00:02 -- 將會員中心id寫入data-lake
2024-05-01 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-30%';
        
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387596'
                WHERE ordernumber = 'P630430101533822' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93448'
                WHERE ordernumber = 'P630430103301599' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371908'
                WHERE ordernumber = 'P420430110419369' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387603'
                WHERE ordernumber = 'P180430110805830' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331196'
                WHERE ordernumber = 'P420430111155476' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343197'
                WHERE ordernumber = 'P200430112702257' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '40686'
                WHERE ordernumber = 'P200430112745975' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277912'
                WHERE ordernumber = 'P200430112907457' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162716'
                WHERE ordernumber = 'P190430113409958' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387607'
                WHERE ordernumber = 'P200430113545814' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294892'
                WHERE ordernumber = 'P420430113905531' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387608'
                WHERE ordernumber = 'P420430113949759' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180430114020473' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387609'
                WHERE ordernumber = 'P190430114127575' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387612'
                WHERE ordernumber = 'P180430114942901' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279253'
                WHERE ordernumber = 'P180430115650207' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125116'
                WHERE ordernumber = 'P190430115916514' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101715'
                WHERE ordernumber = 'P200430120403977' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387613'
                WHERE ordernumber = 'P200430120557609' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228032'
                WHERE ordernumber = 'P180430120813595' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209230'
                WHERE ordernumber = 'P200430120937428' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112637'
                WHERE ordernumber = 'P180430121102300' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260080'
                WHERE ordernumber = 'P180430121842222' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387617'
                WHERE ordernumber = 'P200430122431298' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385428'
                WHERE ordernumber = 'P590430123115368' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387619'
                WHERE ordernumber = 'P200430123139204' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387620'
                WHERE ordernumber = 'P180430123452384' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209114'
                WHERE ordernumber = 'P180430123545397' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297814'
                WHERE ordernumber = 'P420430123659331' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387621'
                WHERE ordernumber = 'P630430123805531' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145009'
                WHERE ordernumber = 'P180430124114630' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343598'
                WHERE ordernumber = 'P200430124315546' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387624'
                WHERE ordernumber = 'P420430125306732' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145336'
                WHERE ordernumber = 'P200430125615790' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387605'
                WHERE ordernumber = 'P180430125624380' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269919'
                WHERE ordernumber = 'P180430125741656' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342567'
                WHERE ordernumber = 'P420430130717310' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387626'
                WHERE ordernumber = 'P200430130901232' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297623'
                WHERE ordernumber = 'P420430130916217' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387461'
                WHERE ordernumber = 'P590430130918363' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387627'
                WHERE ordernumber = 'P180430131155241' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314585'
                WHERE ordernumber = 'P180430131401512' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297623'
                WHERE ordernumber = 'P420430131456769' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387628'
                WHERE ordernumber = 'P180430131742678' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212791'
                WHERE ordernumber = 'P180430132313691' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165934'
                WHERE ordernumber = 'P180430132429950' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387629'
                WHERE ordernumber = 'P180430132857504' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235901'
                WHERE ordernumber = 'P200430133640734' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387630'
                WHERE ordernumber = 'P180430133828659' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114320'
                WHERE ordernumber = 'P180430134002237' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238188'
                WHERE ordernumber = 'P200430134131871' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208327'
                WHERE ordernumber = 'P180430134138629' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364588'
                WHERE ordernumber = 'P180430134357641' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387632'
                WHERE ordernumber = 'P180430134631530' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387633'
                WHERE ordernumber = 'P180430135128715' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235509'
                WHERE ordernumber = 'P200430135213593' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135323'
                WHERE ordernumber = 'P200430135935280' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387634'
                WHERE ordernumber = 'P180430140704689' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387635'
                WHERE ordernumber = 'P180430140829803' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377659'
                WHERE ordernumber = 'P180430141715741' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387636'
                WHERE ordernumber = 'P180430141906658' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387637'
                WHERE ordernumber = 'P180430142011332' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387638'
                WHERE ordernumber = 'P180430142132537' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387639'
                WHERE ordernumber = 'P190430142241333' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387637'
                WHERE ordernumber = 'P180430142543329' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345721'
                WHERE ordernumber = 'P200430142848789' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85920'
                WHERE ordernumber = 'P180430143114675' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P190430143141320' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386821'
                WHERE ordernumber = 'P200430143236692' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348568'
                WHERE ordernumber = 'P180430143331693' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387644'
                WHERE ordernumber = 'P180430143700943' 
            
2024-05-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357114'
                WHERE ordernumber = 'P180430143928897' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286571'
                WHERE ordernumber = 'P200430144656519' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387645'
                WHERE ordernumber = 'P590430145257811' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315321'
                WHERE ordernumber = 'P420430145317386' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135323'
                WHERE ordernumber = 'P200430145344412' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387647'
                WHERE ordernumber = 'P200430145745745' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387647'
                WHERE ordernumber = 'P200430145841955' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387649'
                WHERE ordernumber = 'P200430150234957' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287063'
                WHERE ordernumber = 'P180430150309990' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378799'
                WHERE ordernumber = 'P200430150525601' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93448'
                WHERE ordernumber = 'P630430150810180' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256467'
                WHERE ordernumber = 'P180430152043849' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387651'
                WHERE ordernumber = 'P630430152049997' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387652'
                WHERE ordernumber = 'P420430152103500' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364983'
                WHERE ordernumber = 'P180430152205723' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330820'
                WHERE ordernumber = 'P190430152706880' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381810'
                WHERE ordernumber = 'P630430152933641' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387650'
                WHERE ordernumber = 'P200430153004767' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381810'
                WHERE ordernumber = 'P630430153020147' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387653'
                WHERE ordernumber = 'P630430153208806' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363838'
                WHERE ordernumber = 'P420430153342296' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80905'
                WHERE ordernumber = 'P180430153428524' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387655'
                WHERE ordernumber = 'P190430153502902' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '51896'
                WHERE ordernumber = 'P200430153638381' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387657'
                WHERE ordernumber = 'P200430153908262' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387554'
                WHERE ordernumber = 'P200430153956366' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387658'
                WHERE ordernumber = 'P200430154149133' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267203'
                WHERE ordernumber = 'P190430154642306' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387659'
                WHERE ordernumber = 'P420430154901382' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387101'
                WHERE ordernumber = 'P190430154954686' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387101'
                WHERE ordernumber = 'P190430155024979' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221676'
                WHERE ordernumber = 'P180430155030451' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387660'
                WHERE ordernumber = 'P420430155424367' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P180430155546436' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387662'
                WHERE ordernumber = 'P420430155932486' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '151758'
                WHERE ordernumber = 'P180430160340128' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106911'
                WHERE ordernumber = 'P200430161137979' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278667'
                WHERE ordernumber = 'P200430161348457' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106911'
                WHERE ordernumber = 'P200430161642482' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387666'
                WHERE ordernumber = 'P180430162451343' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222195'
                WHERE ordernumber = 'P200430162636598' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363344'
                WHERE ordernumber = 'P200430162709585' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387664'
                WHERE ordernumber = 'P590430162744666' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387668'
                WHERE ordernumber = 'P180430163150693' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387669'
                WHERE ordernumber = 'P630430163714882' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387671'
                WHERE ordernumber = 'P630430164651679' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381625'
                WHERE ordernumber = 'P200430170442916' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P180430171354963' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387673'
                WHERE ordernumber = 'P630430172432313' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288667'
                WHERE ordernumber = 'P200430172913459' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103534'
                WHERE ordernumber = 'P630430172941756' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387674'
                WHERE ordernumber = 'P180430173327815' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387598'
                WHERE ordernumber = 'P630430173341405' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387675'
                WHERE ordernumber = 'P180430173650290' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387676'
                WHERE ordernumber = 'P200430173729810' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352794'
                WHERE ordernumber = 'P200430174039899' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387678'
                WHERE ordernumber = 'P630430174142930' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374711'
                WHERE ordernumber = 'P420430174645709' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387680'
                WHERE ordernumber = 'P200430174723917' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325137'
                WHERE ordernumber = 'P200430174827169' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387681'
                WHERE ordernumber = 'P630430175433800' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232171'
                WHERE ordernumber = 'P180430175827449' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365232'
                WHERE ordernumber = 'P420430175836661' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220663'
                WHERE ordernumber = 'P180430180031149' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387682'
                WHERE ordernumber = 'P200430180906688' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387684'
                WHERE ordernumber = 'P200430181109939' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387685'
                WHERE ordernumber = 'P180430181448296' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387686'
                WHERE ordernumber = 'P190430181537573' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387683'
                WHERE ordernumber = 'P590430181739753' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387004'
                WHERE ordernumber = 'P190430181957293' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246436'
                WHERE ordernumber = 'P180430182107569' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247021'
                WHERE ordernumber = 'P190430182350981' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343777'
                WHERE ordernumber = 'P180430182720826' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387689'
                WHERE ordernumber = 'P590430182820341' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353740'
                WHERE ordernumber = 'P420430183029311' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384207'
                WHERE ordernumber = 'P630430183447536' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347369'
                WHERE ordernumber = 'P200430184012203' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387690'
                WHERE ordernumber = 'P630430184410940' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387691'
                WHERE ordernumber = 'P190430184643316' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '182079'
                WHERE ordernumber = 'P200430185124396' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378311'
                WHERE ordernumber = 'P190430185333152' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384951'
                WHERE ordernumber = 'P420430185818500' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117899'
                WHERE ordernumber = 'P190430185826535' 
            
2024-05-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387693'
                WHERE ordernumber = 'P420430190553674' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386366'
                WHERE ordernumber = 'P590430190820505' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379762'
                WHERE ordernumber = 'P200430190957441' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387695'
                WHERE ordernumber = 'P420430191058454' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '255951'
                WHERE ordernumber = 'P200430191941227' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387696'
                WHERE ordernumber = 'P420430191940407' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387697'
                WHERE ordernumber = 'P420430192101691' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387698'
                WHERE ordernumber = 'P590430192629113' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387699'
                WHERE ordernumber = 'P200430192820364' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208484'
                WHERE ordernumber = 'P190430193829142' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232485'
                WHERE ordernumber = 'P630430194237760' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387701'
                WHERE ordernumber = 'P200430194301351' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387701'
                WHERE ordernumber = 'P200430194306839' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387701'
                WHERE ordernumber = 'P200430194310501' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '21240'
                WHERE ordernumber = 'P630430194357728' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387703'
                WHERE ordernumber = 'P200430194440357' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387704'
                WHERE ordernumber = 'P420430194747465' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387702'
                WHERE ordernumber = 'P590430195022298' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387705'
                WHERE ordernumber = 'P630430195440867' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227260'
                WHERE ordernumber = 'P190430195833305' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137197'
                WHERE ordernumber = 'P420430200209851' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276492'
                WHERE ordernumber = 'P200430200314447' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387707'
                WHERE ordernumber = 'P630430202748432' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '38288'
                WHERE ordernumber = 'P630430204841932' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387713'
                WHERE ordernumber = 'P630430211729372' 
            
2024-05-01 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387714'
                WHERE ordernumber = 'P590430213617888'