2024-04-21 01:00:03 -- 將會員中心id寫入data-lake
2024-04-21 01:00:03 -- 
            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-20%';
        
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386197'
                WHERE ordernumber = 'P630420100217624' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141741'
                WHERE ordernumber = 'P630420104440921' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276379'
                WHERE ordernumber = 'P180420110135347' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386209'
                WHERE ordernumber = 'P190420110234935' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386207'
                WHERE ordernumber = 'P190420110329625' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386208'
                WHERE ordernumber = 'P180420110412259' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386208'
                WHERE ordernumber = 'P180420110422827' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86203'
                WHERE ordernumber = 'P180420110459908' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386211'
                WHERE ordernumber = 'P200420110610356' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386213'
                WHERE ordernumber = 'P190420110641224' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386212'
                WHERE ordernumber = 'P420420110644118' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '17704'
                WHERE ordernumber = 'P180420110901326' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386216'
                WHERE ordernumber = 'P190420111013500' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386215'
                WHERE ordernumber = 'P200420111025730' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386214'
                WHERE ordernumber = 'P420420111030367' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289394'
                WHERE ordernumber = 'P200420111229581' 
            
2024-04-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386217'
                WHERE ordernumber = 'P590420111506905' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P190420111512289' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235055'
                WHERE ordernumber = 'P200420111808269' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105553'
                WHERE ordernumber = 'P190420112129695' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291421'
                WHERE ordernumber = 'P180420112254657' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245271'
                WHERE ordernumber = 'P200420112843269' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377840'
                WHERE ordernumber = 'P200420112941521' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279525'
                WHERE ordernumber = 'P190420113319622' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261062'
                WHERE ordernumber = 'P200420113429555' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290291'
                WHERE ordernumber = 'P200420113714867' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315733'
                WHERE ordernumber = 'P190420113909430' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317859'
                WHERE ordernumber = 'P200420113917657' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378054'
                WHERE ordernumber = 'P200420114041882' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386220'
                WHERE ordernumber = 'P630420114744687' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104599'
                WHERE ordernumber = 'P420420114759169' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386221'
                WHERE ordernumber = 'P200420114829704' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '91950'
                WHERE ordernumber = 'P190420115238517' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386223'
                WHERE ordernumber = 'P420420115315482' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386224'
                WHERE ordernumber = 'P190420115459519' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290407'
                WHERE ordernumber = 'P200420115943200' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386225'
                WHERE ordernumber = 'P420420120104981' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133744'
                WHERE ordernumber = 'P200420120239493' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386226'
                WHERE ordernumber = 'P180420120447418' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386227'
                WHERE ordernumber = 'P180420120537990' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386228'
                WHERE ordernumber = 'P180420120845251' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264573'
                WHERE ordernumber = 'P200420121010585' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180420121038160' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158930'
                WHERE ordernumber = 'P180420121128787' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386229'
                WHERE ordernumber = 'P180420121348860' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386230'
                WHERE ordernumber = 'P180420121510712' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386231'
                WHERE ordernumber = 'P200420121740498' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386233'
                WHERE ordernumber = 'P180420121902155' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386232'
                WHERE ordernumber = 'P200420121906760' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386234'
                WHERE ordernumber = 'P180420122025932' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346622'
                WHERE ordernumber = 'P200420122318632' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386235'
                WHERE ordernumber = 'P420420123042925' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385593'
                WHERE ordernumber = 'P420420123335615' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386237'
                WHERE ordernumber = 'P180420123634714' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P200420123833750' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313973'
                WHERE ordernumber = 'P180420123904824' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386238'
                WHERE ordernumber = 'P180420124318458' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386239'
                WHERE ordernumber = 'P200420124441585' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283472'
                WHERE ordernumber = 'P180420124653123' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104036'
                WHERE ordernumber = 'P190420124811412' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386240'
                WHERE ordernumber = 'P200420125102610' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104036'
                WHERE ordernumber = 'P180420125255616' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216091'
                WHERE ordernumber = 'P190420125306440' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298979'
                WHERE ordernumber = 'P590420125758220' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247096'
                WHERE ordernumber = 'P180420125959172' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386242'
                WHERE ordernumber = 'P190420130009826' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386243'
                WHERE ordernumber = 'P190420130503462' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379469'
                WHERE ordernumber = 'P200420130616378' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386245'
                WHERE ordernumber = 'P180420131147298' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386246'
                WHERE ordernumber = 'P420420131433680' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386247'
                WHERE ordernumber = 'P200420131535957' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386248'
                WHERE ordernumber = 'P200420132200487' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302307'
                WHERE ordernumber = 'P200420132352316' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380926'
                WHERE ordernumber = 'P420420132443254' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386249'
                WHERE ordernumber = 'P200420132712944' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281451'
                WHERE ordernumber = 'P200420132758297' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386250'
                WHERE ordernumber = 'P180420132827452' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386251'
                WHERE ordernumber = 'P420420132955720' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386252'
                WHERE ordernumber = 'P190420133015335' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386253'
                WHERE ordernumber = 'P630420133036745' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386254'
                WHERE ordernumber = 'P180420133153243' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227565'
                WHERE ordernumber = 'P200420133208317' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143508'
                WHERE ordernumber = 'P200420133559353' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386255'
                WHERE ordernumber = 'P190420133859408' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385937'
                WHERE ordernumber = 'P420420134102138' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385937'
                WHERE ordernumber = 'P420420134408315' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369813'
                WHERE ordernumber = 'P200420134429639' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386257'
                WHERE ordernumber = 'P180420134512727' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244433'
                WHERE ordernumber = 'P420420134518375' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358762'
                WHERE ordernumber = 'P200420134701667' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385937'
                WHERE ordernumber = 'P420420134718504' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386259'
                WHERE ordernumber = 'P420420135611301' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284271'
                WHERE ordernumber = 'P200420135736197' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81134'
                WHERE ordernumber = 'P180420140207194' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337292'
                WHERE ordernumber = 'P180420140654171' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274867'
                WHERE ordernumber = 'P200420141014828' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257161'
                WHERE ordernumber = 'P190420141413272' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292521'
                WHERE ordernumber = 'P200420141433619' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386262'
                WHERE ordernumber = 'P200420141546644' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386263'
                WHERE ordernumber = 'P180420142035209' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386264'
                WHERE ordernumber = 'P200420142146983' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386265'
                WHERE ordernumber = 'P420420142358398' 
            
2024-04-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386265'
                WHERE ordernumber = 'P420420142431494' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386266'
                WHERE ordernumber = 'P420420143158989' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386267'
                WHERE ordernumber = 'P200420143510295' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386268'
                WHERE ordernumber = 'P180420143847671' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386269'
                WHERE ordernumber = 'P420420144159710' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386270'
                WHERE ordernumber = 'P190420144218514' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386271'
                WHERE ordernumber = 'P190420144310926' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386272'
                WHERE ordernumber = 'P420420144418536' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '356575'
                WHERE ordernumber = 'P200420144505479' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386273'
                WHERE ordernumber = 'P630420144509884' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385955'
                WHERE ordernumber = 'P190420144522753' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385955'
                WHERE ordernumber = 'P190420144540975' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286225'
                WHERE ordernumber = 'P630420145147129' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385953'
                WHERE ordernumber = 'P180420145410531' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386265'
                WHERE ordernumber = 'P420420145502384' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343783'
                WHERE ordernumber = 'P630420145519371' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386274'
                WHERE ordernumber = 'P190420145733132' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386275'
                WHERE ordernumber = 'P180420145757202' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386276'
                WHERE ordernumber = 'P180420150022571' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '252493'
                WHERE ordernumber = 'P190420150319806' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382783'
                WHERE ordernumber = 'P200420150932582' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378465'
                WHERE ordernumber = 'P200420151036384' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386277'
                WHERE ordernumber = 'P420420151138343' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386278'
                WHERE ordernumber = 'P200420151144271' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382848'
                WHERE ordernumber = 'P420420151308756' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386279'
                WHERE ordernumber = 'P200420151329165' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383738'
                WHERE ordernumber = 'P190420151344279' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266205'
                WHERE ordernumber = 'P420420151522947' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382850'
                WHERE ordernumber = 'P420420151655918' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386280'
                WHERE ordernumber = 'P630420151742330' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275306'
                WHERE ordernumber = 'P420420151823274' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382850'
                WHERE ordernumber = 'P420420151858712' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386281'
                WHERE ordernumber = 'P200420152040600' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386282'
                WHERE ordernumber = 'P420420152435174' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '135754'
                WHERE ordernumber = 'P420420152610741' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '294488'
                WHERE ordernumber = 'P190420152641738' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378552'
                WHERE ordernumber = 'P420420152900915' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386283'
                WHERE ordernumber = 'P190420153015129' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386284'
                WHERE ordernumber = 'P200420153435216' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297312'
                WHERE ordernumber = 'P420420153631638' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386286'
                WHERE ordernumber = 'P200420153639746' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161510'
                WHERE ordernumber = 'P420420153717414' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386287'
                WHERE ordernumber = 'P590420153929492' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247440'
                WHERE ordernumber = 'P180420154222347' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386288'
                WHERE ordernumber = 'P180420154339304' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386289'
                WHERE ordernumber = 'P630420154537388' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386290'
                WHERE ordernumber = 'P630420154625935' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238586'
                WHERE ordernumber = 'P200420154716624' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386292'
                WHERE ordernumber = 'P420420155002539' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386293'
                WHERE ordernumber = 'P200420155017395' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386294'
                WHERE ordernumber = 'P180420155228416' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '216847'
                WHERE ordernumber = 'P180420155349839' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386094'
                WHERE ordernumber = 'P420420155654192' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386291'
                WHERE ordernumber = 'P190420155719508' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386297'
                WHERE ordernumber = 'P420420160245575' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386298'
                WHERE ordernumber = 'P200420160454347' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386299'
                WHERE ordernumber = 'P200420161044482' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386300'
                WHERE ordernumber = 'P200420161306474' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '332571'
                WHERE ordernumber = 'P590420161452758' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358376'
                WHERE ordernumber = 'P180420161459822' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386301'
                WHERE ordernumber = 'P200420161558935' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386302'
                WHERE ordernumber = 'P180420161647401' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386303'
                WHERE ordernumber = 'P420420161710876' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386304'
                WHERE ordernumber = 'P190420161925778' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159425'
                WHERE ordernumber = 'P200420161949223' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386305'
                WHERE ordernumber = 'P180420162013503' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '123898'
                WHERE ordernumber = 'P200420162320492' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231037'
                WHERE ordernumber = 'P200420162527771' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386306'
                WHERE ordernumber = 'P200420162729550' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386307'
                WHERE ordernumber = 'P180420162741233' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242246'
                WHERE ordernumber = 'P200420163017708' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '376353'
                WHERE ordernumber = 'P180420163048786' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386308'
                WHERE ordernumber = 'P180420163215883' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386309'
                WHERE ordernumber = 'P420420163356285' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386310'
                WHERE ordernumber = 'P200420163519114' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386312'
                WHERE ordernumber = 'P200420163903884' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '72480'
                WHERE ordernumber = 'P180420163950691' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386314'
                WHERE ordernumber = 'P200420164021212' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100790'
                WHERE ordernumber = 'P200420164143143' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386060'
                WHERE ordernumber = 'P180420164451290' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386316'
                WHERE ordernumber = 'P180420164659712' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386315'
                WHERE ordernumber = 'P200420164703219' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277541'
                WHERE ordernumber = 'P200420164813906' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386317'
                WHERE ordernumber = 'P420420164825979' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386318'
                WHERE ordernumber = 'P590420164944664' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386313'
                WHERE ordernumber = 'P590420165450130' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '320376'
                WHERE ordernumber = 'P420420165710283' 
            
2024-04-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386321'
                WHERE ordernumber = 'P420420165926615' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386322'
                WHERE ordernumber = 'P590420165947274' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386320'
                WHERE ordernumber = 'P190420170032890' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '4'
                WHERE ordernumber = 'P420420170101706' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386323'
                WHERE ordernumber = 'P420420170420657' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '248308'
                WHERE ordernumber = 'P630420170516518' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386324'
                WHERE ordernumber = 'P180420170646309' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386325'
                WHERE ordernumber = 'P200420170701429' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386326'
                WHERE ordernumber = 'P420420170821433' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '307544'
                WHERE ordernumber = 'P420420170951305' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386327'
                WHERE ordernumber = 'P200420171048261' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386329'
                WHERE ordernumber = 'P190420171144791' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '105669'
                WHERE ordernumber = 'P200420171554596' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '236170'
                WHERE ordernumber = 'P180420171634444' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386332'
                WHERE ordernumber = 'P200420172025975' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '294345'
                WHERE ordernumber = 'P180420172159870' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '380840'
                WHERE ordernumber = 'P200420172614640' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '234035'
                WHERE ordernumber = 'P200420172749689' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386333'
                WHERE ordernumber = 'P180420173023530' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353684'
                WHERE ordernumber = 'P420420173327730' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386334'
                WHERE ordernumber = 'P200420173445315' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '104950'
                WHERE ordernumber = 'P630420173459157' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '229916'
                WHERE ordernumber = 'P630420173546304' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386205'
                WHERE ordernumber = 'P200420173804603' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386335'
                WHERE ordernumber = 'P420420173832436' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386336'
                WHERE ordernumber = 'P200420173902511' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '305954'
                WHERE ordernumber = 'P200420174007809' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386339'
                WHERE ordernumber = 'P200420174813443' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386340'
                WHERE ordernumber = 'P420420175522681' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '275311'
                WHERE ordernumber = 'P200420175826637' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386341'
                WHERE ordernumber = 'P420420175923589' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386342'
                WHERE ordernumber = 'P420420180100141' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386343'
                WHERE ordernumber = 'P420420180307439' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386344'
                WHERE ordernumber = 'P190420180655951' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386345'
                WHERE ordernumber = 'P420420181501177' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '240595'
                WHERE ordernumber = 'P180420181759543' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '269074'
                WHERE ordernumber = 'P180420181927161' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386346'
                WHERE ordernumber = 'P420420182137392' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '237579'
                WHERE ordernumber = 'P200420182354241' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386347'
                WHERE ordernumber = 'P420420182521255' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386348'
                WHERE ordernumber = 'P200420182643142' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386349'
                WHERE ordernumber = 'P420420182651853' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386350'
                WHERE ordernumber = 'P630420183300347' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '95131'
                WHERE ordernumber = 'P200420183413766' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '373005'
                WHERE ordernumber = 'P180420183556610' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386351'
                WHERE ordernumber = 'P180420184029316' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '276699'
                WHERE ordernumber = 'P190420184214775' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386352'
                WHERE ordernumber = 'P420420184312788' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386354'
                WHERE ordernumber = 'P190420184742949' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386353'
                WHERE ordernumber = 'P420420184744920' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386355'
                WHERE ordernumber = 'P420420185002879' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386356'
                WHERE ordernumber = 'P200420185033523' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386357'
                WHERE ordernumber = 'P200420185125304' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '292587'
                WHERE ordernumber = 'P420420185235664' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '76659'
                WHERE ordernumber = 'P420420190216140' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '28004'
                WHERE ordernumber = 'P200420191240502' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386358'
                WHERE ordernumber = 'P420420191423682' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386359'
                WHERE ordernumber = 'P200420191500575' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386360'
                WHERE ordernumber = 'P630420191558808' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '264478'
                WHERE ordernumber = 'P190420193124650' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386361'
                WHERE ordernumber = 'P420420193207339' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '46272'
                WHERE ordernumber = 'P630420193425831' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '385708'
                WHERE ordernumber = 'P420420193559600' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '288972'
                WHERE ordernumber = 'P200420193900387' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '382981'
                WHERE ordernumber = 'P630420194149701' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386362'
                WHERE ordernumber = 'P190420194710863' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '129318'
                WHERE ordernumber = 'P190420195439729' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386365'
                WHERE ordernumber = 'P630420201624998' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386365'
                WHERE ordernumber = 'P630420204815269' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386366'
                WHERE ordernumber = 'P590420205646386' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386368'
                WHERE ordernumber = 'P590420205713507' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '301651'
                WHERE ordernumber = 'P630420210502505' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386371'
                WHERE ordernumber = 'P630420214254650' 
            
2024-04-21 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386371'
                WHERE ordernumber = 'P630420214254650'