2024-05-06 01:00:02 -- 將會員中心id寫入data-lake
2024-05-06 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-05-05%';
        
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388408'
                WHERE ordernumber = 'P630505103643432' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388411'
                WHERE ordernumber = 'P630505104441426' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388413'
                WHERE ordernumber = 'P630505105812361' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249748'
                WHERE ordernumber = 'P180505110255768' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386405'
                WHERE ordernumber = 'P180505110334937' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388415'
                WHERE ordernumber = 'P190505110714172' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388416'
                WHERE ordernumber = 'P180505110736810' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279055'
                WHERE ordernumber = 'P180505110817826' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388413'
                WHERE ordernumber = 'P630505110913527' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378637'
                WHERE ordernumber = 'P180505111158117' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388413'
                WHERE ordernumber = 'P630505111404909' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388081'
                WHERE ordernumber = 'P790505111633945' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360486'
                WHERE ordernumber = 'P420505111832710' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '131676'
                WHERE ordernumber = 'P180505112311708' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388418'
                WHERE ordernumber = 'P200505112514819' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388419'
                WHERE ordernumber = 'P180505113008869' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388421'
                WHERE ordernumber = 'P200505113027967' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388422'
                WHERE ordernumber = 'P200505113152219' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282202'
                WHERE ordernumber = 'P180505113528890' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388420'
                WHERE ordernumber = 'P630505113719162' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377535'
                WHERE ordernumber = 'P200505113756838' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235059'
                WHERE ordernumber = 'P200505114108479' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388423'
                WHERE ordernumber = 'P790505114426678' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388424'
                WHERE ordernumber = 'P180505114617759' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283600'
                WHERE ordernumber = 'P180505114744637' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388425'
                WHERE ordernumber = 'P790505114806417' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235075'
                WHERE ordernumber = 'P180505114921422' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388426'
                WHERE ordernumber = 'P790505115131165' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225290'
                WHERE ordernumber = 'P180505115451795' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388427'
                WHERE ordernumber = 'P630505120149743' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388429'
                WHERE ordernumber = 'P200505121203320' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383754'
                WHERE ordernumber = 'P180505121557941' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255478'
                WHERE ordernumber = 'P180505121824916' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388430'
                WHERE ordernumber = 'P630505122123743' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388431'
                WHERE ordernumber = 'P180505122522768' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388433'
                WHERE ordernumber = 'P420505123148789' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388434'
                WHERE ordernumber = 'P630505123240623' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388435'
                WHERE ordernumber = 'P180505123316167' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388436'
                WHERE ordernumber = 'P790505123437982' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388437'
                WHERE ordernumber = 'P180505123605205' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99246'
                WHERE ordernumber = 'P180505123648844' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388437'
                WHERE ordernumber = 'P180505123751988' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388438'
                WHERE ordernumber = 'P630505124256775' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388440'
                WHERE ordernumber = 'P790505124759933' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383705'
                WHERE ordernumber = 'P790505125121253' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388442'
                WHERE ordernumber = 'P180505125157733' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388443'
                WHERE ordernumber = 'P420505125325615' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388444'
                WHERE ordernumber = 'P190505125646779' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388445'
                WHERE ordernumber = 'P630505130007540' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345922'
                WHERE ordernumber = 'P200505130436705' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388446'
                WHERE ordernumber = 'P420505130452347' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388448'
                WHERE ordernumber = 'P420505130639211' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137581'
                WHERE ordernumber = 'P180505130742448' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348229'
                WHERE ordernumber = 'P420505131155706' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388449'
                WHERE ordernumber = 'P200505131229267' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289355'
                WHERE ordernumber = 'P420505131254886' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388450'
                WHERE ordernumber = 'P200505131346196' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318257'
                WHERE ordernumber = 'P200505131521262' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349197'
                WHERE ordernumber = 'P790505131638912' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107559'
                WHERE ordernumber = 'P180505131739192' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318257'
                WHERE ordernumber = 'P200505132104295' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388451'
                WHERE ordernumber = 'P790505132748375' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324459'
                WHERE ordernumber = 'P180505132846727' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388452'
                WHERE ordernumber = 'P200505133003455' 
            
2024-05-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388455'
                WHERE ordernumber = 'P180505133625240' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99251'
                WHERE ordernumber = 'P200505133626179' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387207'
                WHERE ordernumber = 'P420505133759600' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388456'
                WHERE ordernumber = 'P420505133919838' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388457'
                WHERE ordernumber = 'P180505134040224' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379176'
                WHERE ordernumber = 'P180505134147126' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388452'
                WHERE ordernumber = 'P200505134254721' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388452'
                WHERE ordernumber = 'P200505134335596' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388452'
                WHERE ordernumber = 'P200505134351605' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388458'
                WHERE ordernumber = 'P790505134431515' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388459'
                WHERE ordernumber = 'P180505134509227' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388460'
                WHERE ordernumber = 'P420505134519640' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365648'
                WHERE ordernumber = 'P790505134731722' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319139'
                WHERE ordernumber = 'P180505134751350' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388461'
                WHERE ordernumber = 'P630505134941354' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82244'
                WHERE ordernumber = 'P200505135134367' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388462'
                WHERE ordernumber = 'P630505135251961' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388463'
                WHERE ordernumber = 'P630505135637183' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352970'
                WHERE ordernumber = 'P200505135655482' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352970'
                WHERE ordernumber = 'P200505135757383' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388465'
                WHERE ordernumber = 'P420505135844268' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388464'
                WHERE ordernumber = 'P630505135909862' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388466'
                WHERE ordernumber = 'P630505140154314' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388467'
                WHERE ordernumber = 'P630505140346526' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388468'
                WHERE ordernumber = 'P420505141536347' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '7373'
                WHERE ordernumber = 'P180505141546719' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388470'
                WHERE ordernumber = 'P420505141740515' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74739'
                WHERE ordernumber = 'P790505142135305' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388471'
                WHERE ordernumber = 'P180505142252397' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380665'
                WHERE ordernumber = 'P180505142422721' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388472'
                WHERE ordernumber = 'P420505142615508' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354366'
                WHERE ordernumber = 'P180505142759952' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143180'
                WHERE ordernumber = 'P180505143357419' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388475'
                WHERE ordernumber = 'P180505143517803' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388476'
                WHERE ordernumber = 'P180505144151111' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386742'
                WHERE ordernumber = 'P180505144318961' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133740'
                WHERE ordernumber = 'P200505144346180' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388477'
                WHERE ordernumber = 'P200505144504153' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388453'
                WHERE ordernumber = 'P180505144527752' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '49080'
                WHERE ordernumber = 'P180505144707408' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388478'
                WHERE ordernumber = 'P420505144920483' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388479'
                WHERE ordernumber = 'P790505145114233' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349215'
                WHERE ordernumber = 'P200505145157521' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386982'
                WHERE ordernumber = 'P420505145554867' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388480'
                WHERE ordernumber = 'P420505145952837' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240188'
                WHERE ordernumber = 'P200505150102662' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388481'
                WHERE ordernumber = 'P180505150307717' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388482'
                WHERE ordernumber = 'P190505150348823' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '51992'
                WHERE ordernumber = 'P420505151125832' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315726'
                WHERE ordernumber = 'P420505151232552' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388483'
                WHERE ordernumber = 'P420505151951746' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380869'
                WHERE ordernumber = 'P180505152039962' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380869'
                WHERE ordernumber = 'P180505152212343' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380869'
                WHERE ordernumber = 'P180505152358153' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388484'
                WHERE ordernumber = 'P200505152431778' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388485'
                WHERE ordernumber = 'P190505152501916' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388486'
                WHERE ordernumber = 'P180505152644916' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388488'
                WHERE ordernumber = 'P180505153329384' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388489'
                WHERE ordernumber = 'P200505153652776' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377383'
                WHERE ordernumber = 'P420505153821762' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388490'
                WHERE ordernumber = 'P200505153824657' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388491'
                WHERE ordernumber = 'P630505153900382' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388492'
                WHERE ordernumber = 'P420505153952469' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388493'
                WHERE ordernumber = 'P420505154053494' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388495'
                WHERE ordernumber = 'P190505154536828' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388497'
                WHERE ordernumber = 'P630505154920302' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388494'
                WHERE ordernumber = 'P200505155057147' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381977'
                WHERE ordernumber = 'P200505155144528' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230319'
                WHERE ordernumber = 'P200505155241378' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388498'
                WHERE ordernumber = 'P420505155358286' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93935'
                WHERE ordernumber = 'P180505155509357' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388500'
                WHERE ordernumber = 'P200505155632173' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388499'
                WHERE ordernumber = 'P630505155641728' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388501'
                WHERE ordernumber = 'P180505160217455' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388496'
                WHERE ordernumber = 'P420505160300763' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382351'
                WHERE ordernumber = 'P630505160301463' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359909'
                WHERE ordernumber = 'P790505160718994' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388503'
                WHERE ordernumber = 'P200505161009498' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350562'
                WHERE ordernumber = 'P190505161038162' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161965'
                WHERE ordernumber = 'P200505161101385' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388504'
                WHERE ordernumber = 'P420505161307740' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111859'
                WHERE ordernumber = 'P190505161458617' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345438'
                WHERE ordernumber = 'P180505161635483' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157229'
                WHERE ordernumber = 'P200505161716261' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388506'
                WHERE ordernumber = 'P420505161848477' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388507'
                WHERE ordernumber = 'P420505162031244' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388508'
                WHERE ordernumber = 'P200505162708603' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388510'
                WHERE ordernumber = 'P630505162720727' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388511'
                WHERE ordernumber = 'P190505162742132' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388509'
                WHERE ordernumber = 'P420505162829448' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388512'
                WHERE ordernumber = 'P200505162852582' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388513'
                WHERE ordernumber = 'P190505163207583' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388515'
                WHERE ordernumber = 'P420505163745765' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388516'
                WHERE ordernumber = 'P180505163826548' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237921'
                WHERE ordernumber = 'P200505164137410' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388517'
                WHERE ordernumber = 'P630505164255128' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388518'
                WHERE ordernumber = 'P200505164323577' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388519'
                WHERE ordernumber = 'P180505164358776' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285730'
                WHERE ordernumber = 'P200505164419543' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388520'
                WHERE ordernumber = 'P420505164421642' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388521'
                WHERE ordernumber = 'P180505164734694' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388522'
                WHERE ordernumber = 'P200505165048355' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388523'
                WHERE ordernumber = 'P630505165400397' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99472'
                WHERE ordernumber = 'P790505165456422' 
            
2024-05-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293764'
                WHERE ordernumber = 'P200505165741216' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312946'
                WHERE ordernumber = 'P200505165823319' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295620'
                WHERE ordernumber = 'P200505170122348' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388524'
                WHERE ordernumber = 'P420505170702737' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103507'
                WHERE ordernumber = 'P200505170806977' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208430'
                WHERE ordernumber = 'P200505170917362' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388525'
                WHERE ordernumber = 'P200505171246547' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388526'
                WHERE ordernumber = 'P630505171506469' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307899'
                WHERE ordernumber = 'P200505171521365' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388527'
                WHERE ordernumber = 'P200505171726449' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388528'
                WHERE ordernumber = 'P200505171807729' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388529'
                WHERE ordernumber = 'P200505171914301' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378210'
                WHERE ordernumber = 'P200505171952281' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388530'
                WHERE ordernumber = 'P200505172340176' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388531'
                WHERE ordernumber = 'P630505172924627' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219545'
                WHERE ordernumber = 'P190505172926200' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388533'
                WHERE ordernumber = 'P790505173120591' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190505173407552' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384830'
                WHERE ordernumber = 'P420505173924991' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388537'
                WHERE ordernumber = 'P200505174009715' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388538'
                WHERE ordernumber = 'P420505174051376' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388536'
                WHERE ordernumber = 'P790505174212877' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388539'
                WHERE ordernumber = 'P200505174300685' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388540'
                WHERE ordernumber = 'P420505174502657' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388541'
                WHERE ordernumber = 'P180505174528752' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388542'
                WHERE ordernumber = 'P190505174619890' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345472'
                WHERE ordernumber = 'P790505174749746' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200505174842664' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388351'
                WHERE ordernumber = 'P200505175125278' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388544'
                WHERE ordernumber = 'P200505175237735' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388543'
                WHERE ordernumber = 'P420505175339732' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388545'
                WHERE ordernumber = 'P420505180011568' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388546'
                WHERE ordernumber = 'P790505180234297' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388548'
                WHERE ordernumber = 'P200505180647457' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388547'
                WHERE ordernumber = 'P630505180706178' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233716'
                WHERE ordernumber = 'P180505180956861' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388549'
                WHERE ordernumber = 'P180505181106659' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388552'
                WHERE ordernumber = 'P180505181637618' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388554'
                WHERE ordernumber = 'P790505181851920' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388556'
                WHERE ordernumber = 'P630505182032293' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388557'
                WHERE ordernumber = 'P790505182227964' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237175'
                WHERE ordernumber = 'P200505182522160' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346618'
                WHERE ordernumber = 'P200505183526593' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388559'
                WHERE ordernumber = 'P200505184101685' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141288'
                WHERE ordernumber = 'P200505184357734' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388561'
                WHERE ordernumber = 'P200505184512607' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326414'
                WHERE ordernumber = 'P200505184607661' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388562'
                WHERE ordernumber = 'P200505184956488' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274566'
                WHERE ordernumber = 'P200505185530375' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388564'
                WHERE ordernumber = 'P420505185535856' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388565'
                WHERE ordernumber = 'P790505185936241' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165807'
                WHERE ordernumber = 'P420505190055688' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388566'
                WHERE ordernumber = 'P630505190238478' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340129'
                WHERE ordernumber = 'P190505190430895' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388567'
                WHERE ordernumber = 'P200505191109255' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388569'
                WHERE ordernumber = 'P200505191158169' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388568'
                WHERE ordernumber = 'P190505191159444' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388570'
                WHERE ordernumber = 'P190505191345873' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388571'
                WHERE ordernumber = 'P190505191600717' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388572'
                WHERE ordernumber = 'P200505191710397' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245821'
                WHERE ordernumber = 'P630505191716969' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388573'
                WHERE ordernumber = 'P190505191721541' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388575'
                WHERE ordernumber = 'P200505192503140' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388179'
                WHERE ordernumber = 'P200505192722493' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388577'
                WHERE ordernumber = 'P190505193604213' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388578'
                WHERE ordernumber = 'P190505193918592' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388579'
                WHERE ordernumber = 'P190505194945547' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388580'
                WHERE ordernumber = 'P630505195342405' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388581'
                WHERE ordernumber = 'P630505195948525' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388582'
                WHERE ordernumber = 'P790505200753137' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388583'
                WHERE ordernumber = 'P630505211107231' 
            
2024-05-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '37015'
                WHERE ordernumber = 'P630505211127605'