2024-02-19 01:00:02 -- 將會員中心id寫入data-lake
2024-02-19 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-02-18%';
        
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377786'
                WHERE ordernumber = 'P200218110112634' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377787'
                WHERE ordernumber = 'P190218110151682' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377788'
                WHERE ordernumber = 'P200218110216867' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377790'
                WHERE ordernumber = 'P200218110305884' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377791'
                WHERE ordernumber = 'P200218110410478' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259166'
                WHERE ordernumber = 'P190218110534184' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358899'
                WHERE ordernumber = 'P200218110539388' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334744'
                WHERE ordernumber = 'P200218110625982' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128881'
                WHERE ordernumber = 'P190218110800754' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377792'
                WHERE ordernumber = 'P200218110856890' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377792'
                WHERE ordernumber = 'P200218111023561' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377793'
                WHERE ordernumber = 'P180218111029445' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280564'
                WHERE ordernumber = 'P180218111230884' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305277'
                WHERE ordernumber = 'P420218111230147' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377795'
                WHERE ordernumber = 'P200218111249169' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377582'
                WHERE ordernumber = 'P420218111323715' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377794'
                WHERE ordernumber = 'P190218111347714' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '373870'
                WHERE ordernumber = 'P420218111511969' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377797'
                WHERE ordernumber = 'P180218111617521' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377798'
                WHERE ordernumber = 'P190218111826960' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313201'
                WHERE ordernumber = 'P180218111940474' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377801'
                WHERE ordernumber = 'P190218112525231' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377802'
                WHERE ordernumber = 'P180218112712553' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377803'
                WHERE ordernumber = 'P190218112810730' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263922'
                WHERE ordernumber = 'P200218112948697' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99900'
                WHERE ordernumber = 'P200218113449506' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377800'
                WHERE ordernumber = 'P190218113514987' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298669'
                WHERE ordernumber = 'P200218113552746' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298669'
                WHERE ordernumber = 'P200218113620517' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241800'
                WHERE ordernumber = 'P190218113748195' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377804'
                WHERE ordernumber = 'P180218113910715' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241800'
                WHERE ordernumber = 'P190218113927624' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377805'
                WHERE ordernumber = 'P190218114036358' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352675'
                WHERE ordernumber = 'P180218114040727' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377806'
                WHERE ordernumber = 'P420218114316906' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377807'
                WHERE ordernumber = 'P180218114547277' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258522'
                WHERE ordernumber = 'P180218114656403' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377808'
                WHERE ordernumber = 'P180218115244270' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377809'
                WHERE ordernumber = 'P420218115353603' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98125'
                WHERE ordernumber = 'P200218120005684' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372704'
                WHERE ordernumber = 'P420218121613633' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372704'
                WHERE ordernumber = 'P420218121637296' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377811'
                WHERE ordernumber = 'P420218122331162' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377812'
                WHERE ordernumber = 'P420218122424253' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276728'
                WHERE ordernumber = 'P420218122458915' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377810'
                WHERE ordernumber = 'P180218122549460' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357912'
                WHERE ordernumber = 'P180218123201956' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213262'
                WHERE ordernumber = 'P180218123848993' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213625'
                WHERE ordernumber = 'P180218124209218' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224056'
                WHERE ordernumber = 'P420218124234822' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257369'
                WHERE ordernumber = 'P200218124317317' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377817'
                WHERE ordernumber = 'P180218124818134' 
            
2024-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377818'
                WHERE ordernumber = 'P200218124918190' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259709'
                WHERE ordernumber = 'P180218125310620' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259709'
                WHERE ordernumber = 'P180218125759493' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106191'
                WHERE ordernumber = 'P180218130141142' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377820'
                WHERE ordernumber = 'P420218130435233' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349282'
                WHERE ordernumber = 'P180218130535270' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377239'
                WHERE ordernumber = 'P180218131035287' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352970'
                WHERE ordernumber = 'P200218131148644' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233276'
                WHERE ordernumber = 'P200218131417258' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377823'
                WHERE ordernumber = 'P420218131510346' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377824'
                WHERE ordernumber = 'P200218131532648' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377825'
                WHERE ordernumber = 'P180218131822532' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367872'
                WHERE ordernumber = 'P420218132003741' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377827'
                WHERE ordernumber = 'P200218132136872' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377828'
                WHERE ordernumber = 'P420218132317999' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274867'
                WHERE ordernumber = 'P200218132430366' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377829'
                WHERE ordernumber = 'P420218132432914' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377830'
                WHERE ordernumber = 'P420218132544296' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234358'
                WHERE ordernumber = 'P180218132731524' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377832'
                WHERE ordernumber = 'P180218132846146' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377833'
                WHERE ordernumber = 'P180218133100469' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377834'
                WHERE ordernumber = 'P420218133313652' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351148'
                WHERE ordernumber = 'P180218133314472' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377835'
                WHERE ordernumber = 'P420218133520276' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377836'
                WHERE ordernumber = 'P420218133621803' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377837'
                WHERE ordernumber = 'P180218133655828' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377838'
                WHERE ordernumber = 'P180218133751774' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377839'
                WHERE ordernumber = 'P420218133811416' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377840'
                WHERE ordernumber = 'P200218133922226' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377841'
                WHERE ordernumber = 'P180218133943436' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377842'
                WHERE ordernumber = 'P180218134241895' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377843'
                WHERE ordernumber = 'P420218134326359' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368724'
                WHERE ordernumber = 'P420218134538759' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129423'
                WHERE ordernumber = 'P180218134632325' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377845'
                WHERE ordernumber = 'P180218135022840' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368724'
                WHERE ordernumber = 'P420218135036523' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377430'
                WHERE ordernumber = 'P200218135037921' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377844'
                WHERE ordernumber = 'P180218135206712' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377846'
                WHERE ordernumber = 'P420218135300200' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377847'
                WHERE ordernumber = 'P420218135642960' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377848'
                WHERE ordernumber = 'P180218135726464' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377849'
                WHERE ordernumber = 'P180218135924571' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351835'
                WHERE ordernumber = 'P180218140043912' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377851'
                WHERE ordernumber = 'P180218140332357' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376683'
                WHERE ordernumber = 'P200218140404459' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306610'
                WHERE ordernumber = 'P180218140730538' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P180218141236376' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231451'
                WHERE ordernumber = 'P190218141237406' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377852'
                WHERE ordernumber = 'P180218141448538' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345773'
                WHERE ordernumber = 'P190218141527501' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227161'
                WHERE ordernumber = 'P420218141655268' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345773'
                WHERE ordernumber = 'P190218141723200' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299632'
                WHERE ordernumber = 'P190218141802922' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377852'
                WHERE ordernumber = 'P180218141826407' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283780'
                WHERE ordernumber = 'P190218141916423' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248343'
                WHERE ordernumber = 'P420218142011184' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377853'
                WHERE ordernumber = 'P180218142120544' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377854'
                WHERE ordernumber = 'P190218142150535' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '78089'
                WHERE ordernumber = 'P190218142355546' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377855'
                WHERE ordernumber = 'P180218142903795' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377856'
                WHERE ordernumber = 'P420218142937458' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74563'
                WHERE ordernumber = 'P420218143109754' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286421'
                WHERE ordernumber = 'P180218143118414' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377858'
                WHERE ordernumber = 'P180218143301511' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377859'
                WHERE ordernumber = 'P180218143529533' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377860'
                WHERE ordernumber = 'P180218143633303' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377353'
                WHERE ordernumber = 'P420218143652373' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377861'
                WHERE ordernumber = 'P420218143815526' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377862'
                WHERE ordernumber = 'P180218143923383' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377863'
                WHERE ordernumber = 'P180218144035934' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241444'
                WHERE ordernumber = 'P180218144206623' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377864'
                WHERE ordernumber = 'P180218144320654' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377865'
                WHERE ordernumber = 'P180218144510203' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278689'
                WHERE ordernumber = 'P180218144811212' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377866'
                WHERE ordernumber = 'P420218144909170' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377867'
                WHERE ordernumber = 'P180218145015700' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377869'
                WHERE ordernumber = 'P180218145150968' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162301'
                WHERE ordernumber = 'P180218145456214' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377872'
                WHERE ordernumber = 'P180218145924690' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377871'
                WHERE ordernumber = 'P420218145933600' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239986'
                WHERE ordernumber = 'P200218150238296' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344159'
                WHERE ordernumber = 'P180218150337297' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377255'
                WHERE ordernumber = 'P420218150413236' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377873'
                WHERE ordernumber = 'P180218150505600' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377874'
                WHERE ordernumber = 'P420218150624365' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347073'
                WHERE ordernumber = 'P200218150737340' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366154'
                WHERE ordernumber = 'P420218150743906' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377875'
                WHERE ordernumber = 'P180218150914676' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223912'
                WHERE ordernumber = 'P180218151019952' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377877'
                WHERE ordernumber = 'P200218151812111' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180218151947801' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354447'
                WHERE ordernumber = 'P180218152137606' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377880'
                WHERE ordernumber = 'P200218152148991' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377880'
                WHERE ordernumber = 'P200218152235705' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377881'
                WHERE ordernumber = 'P180218152607664' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377884'
                WHERE ordernumber = 'P180218152824758' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278722'
                WHERE ordernumber = 'P180218153122249' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354447'
                WHERE ordernumber = 'P180218153236568' 
            
2024-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98048'
                WHERE ordernumber = 'P200218153428995' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377887'
                WHERE ordernumber = 'P180218153526273' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341237'
                WHERE ordernumber = 'P180218153637917' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320796'
                WHERE ordernumber = 'P180218153752265' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367527'
                WHERE ordernumber = 'P200218153952845' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377888'
                WHERE ordernumber = 'P180218154059347' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341237'
                WHERE ordernumber = 'P180218154217975' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230606'
                WHERE ordernumber = 'P180218154314529' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355223'
                WHERE ordernumber = 'P180218154656380' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377892'
                WHERE ordernumber = 'P180218160305384' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377893'
                WHERE ordernumber = 'P180218160536818' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297301'
                WHERE ordernumber = 'P180218160757730' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377894'
                WHERE ordernumber = 'P180218161120709' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314293'
                WHERE ordernumber = 'P200218161136678' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364195'
                WHERE ordernumber = 'P420218161450443' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377895'
                WHERE ordernumber = 'P180218161619826' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320725'
                WHERE ordernumber = 'P420218161853237' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377896'
                WHERE ordernumber = 'P180218161918246' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377897'
                WHERE ordernumber = 'P180218162028630' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275131'
                WHERE ordernumber = 'P180218162134746' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251344'
                WHERE ordernumber = 'P180218162219855' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377898'
                WHERE ordernumber = 'P420218162452366' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377737'
                WHERE ordernumber = 'P420218162622659' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377899'
                WHERE ordernumber = 'P180218162654363' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302437'
                WHERE ordernumber = 'P200218162739712' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '155278'
                WHERE ordernumber = 'P200218162813530' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377900'
                WHERE ordernumber = 'P180218162903275' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159187'
                WHERE ordernumber = 'P420218163126203' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316917'
                WHERE ordernumber = 'P200218163146358' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283871'
                WHERE ordernumber = 'P180218163201841' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377901'
                WHERE ordernumber = 'P420218163305788' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377902'
                WHERE ordernumber = 'P420218163448400' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377903'
                WHERE ordernumber = 'P180218163523551' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377904'
                WHERE ordernumber = 'P420218163614664' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377905'
                WHERE ordernumber = 'P180218163648515' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377906'
                WHERE ordernumber = 'P420218163746694' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377907'
                WHERE ordernumber = 'P180218163912474' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377908'
                WHERE ordernumber = 'P420218163957806' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106086'
                WHERE ordernumber = 'P180218164201925' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377909'
                WHERE ordernumber = 'P420218164304732' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282154'
                WHERE ordernumber = 'P200218164318251' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354432'
                WHERE ordernumber = 'P180218164331768' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282154'
                WHERE ordernumber = 'P200218164441826' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377910'
                WHERE ordernumber = 'P420218164534585' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '184559'
                WHERE ordernumber = 'P190218164535512' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377911'
                WHERE ordernumber = 'P190218164602605' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377912'
                WHERE ordernumber = 'P190218164743966' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377913'
                WHERE ordernumber = 'P420218164829569' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343931'
                WHERE ordernumber = 'P180218165004206' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240423'
                WHERE ordernumber = 'P190218165100453' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377914'
                WHERE ordernumber = 'P200218165202253' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377916'
                WHERE ordernumber = 'P420218165644186' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377917'
                WHERE ordernumber = 'P180218165656801' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377918'
                WHERE ordernumber = 'P420218165823944' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96922'
                WHERE ordernumber = 'P180218165926971' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377919'
                WHERE ordernumber = 'P180218170435284' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272413'
                WHERE ordernumber = 'P180218170526989' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P420218170808752' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '91771'
                WHERE ordernumber = 'P200218170945273' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377921'
                WHERE ordernumber = 'P420218171007404' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274265'
                WHERE ordernumber = 'P200218171310753' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377922'
                WHERE ordernumber = 'P180218171336477' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377923'
                WHERE ordernumber = 'P180218171510426' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377924'
                WHERE ordernumber = 'P180218171633918' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '37789'
                WHERE ordernumber = 'P200218171708831' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377925'
                WHERE ordernumber = 'P200218171927645' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377926'
                WHERE ordernumber = 'P420218172156542' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377927'
                WHERE ordernumber = 'P200218172250282' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377928'
                WHERE ordernumber = 'P420218172445261' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377930'
                WHERE ordernumber = 'P180218172700880' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377929'
                WHERE ordernumber = 'P420218172710159' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358306'
                WHERE ordernumber = 'P180218172916975' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377932'
                WHERE ordernumber = 'P420218172924802' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377933'
                WHERE ordernumber = 'P420218173049447' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377934'
                WHERE ordernumber = 'P420218173309871' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377936'
                WHERE ordernumber = 'P200218173405118' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377935'
                WHERE ordernumber = 'P180218173416414' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377938'
                WHERE ordernumber = 'P180218173740282' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219813'
                WHERE ordernumber = 'P200218174206513' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377939'
                WHERE ordernumber = 'P180218174434165' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377940'
                WHERE ordernumber = 'P200218174437278' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372811'
                WHERE ordernumber = 'P180218174802992' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372811'
                WHERE ordernumber = 'P180218174836769' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235352'
                WHERE ordernumber = 'P190218175050994' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352669'
                WHERE ordernumber = 'P180218175125619' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377943'
                WHERE ordernumber = 'P420218175150849' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377944'
                WHERE ordernumber = 'P180218175218626' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366123'
                WHERE ordernumber = 'P420218175908366' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377945'
                WHERE ordernumber = 'P180218180024901' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377945'
                WHERE ordernumber = 'P180218180151992' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377948'
                WHERE ordernumber = 'P200218181010335' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157868'
                WHERE ordernumber = 'P180218181021613' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157868'
                WHERE ordernumber = 'P180218181056710' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339468'
                WHERE ordernumber = 'P200218181150548' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93404'
                WHERE ordernumber = 'P180218181615680' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282856'
                WHERE ordernumber = 'P420218181726233' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180218182203478' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377951'
                WHERE ordernumber = 'P180218182318886' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377952'
                WHERE ordernumber = 'P200218183053346' 
            
2024-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377953'
                WHERE ordernumber = 'P180218183357378' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '91003'
                WHERE ordernumber = 'P190218184520876' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282773'
                WHERE ordernumber = 'P200218184707223' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377954'
                WHERE ordernumber = 'P190218184831571' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295893'
                WHERE ordernumber = 'P420218184951574' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377955'
                WHERE ordernumber = 'P200218185046932' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311660'
                WHERE ordernumber = 'P190218185155597' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314903'
                WHERE ordernumber = 'P190218185608864' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377954'
                WHERE ordernumber = 'P190218185926985' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377956'
                WHERE ordernumber = 'P190218190252850' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '106604'
                WHERE ordernumber = 'P190218190506737' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374652'
                WHERE ordernumber = 'P190218190752997' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371785'
                WHERE ordernumber = 'P420218190921360' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353667'
                WHERE ordernumber = 'P420218191213380' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377959'
                WHERE ordernumber = 'P190218191622688' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287936'
                WHERE ordernumber = 'P200218191628355' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377960'
                WHERE ordernumber = 'P200218191733632' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377962'
                WHERE ordernumber = 'P200218192044423' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377961'
                WHERE ordernumber = 'P190218192046397' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365102'
                WHERE ordernumber = 'P200218192244961' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377963'
                WHERE ordernumber = 'P190218192324434' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377964'
                WHERE ordernumber = 'P190218192453581' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377965'
                WHERE ordernumber = 'P190218193656942' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377966'
                WHERE ordernumber = 'P190218193819350' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '255873'
                WHERE ordernumber = 'P200218194837214' 
            
2024-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377969'
                WHERE ordernumber = 'P190218195429378'