2024-07-19 01:00:03 -- 將會員中心id寫入data-lake
2024-07-19 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-07-18%';
        
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384474'
                WHERE ordernumber = 'P630718102334640' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99427'
                WHERE ordernumber = 'P630718102724423' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P420718105938268' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335730'
                WHERE ordernumber = 'P420718110253373' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401417'
                WHERE ordernumber = 'P180718110316641' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401819'
                WHERE ordernumber = 'P180718110425930' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401819'
                WHERE ordernumber = 'P180718110452614' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401818'
                WHERE ordernumber = 'P180718110631832' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401823'
                WHERE ordernumber = 'P180718111135653' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401824'
                WHERE ordernumber = 'P420718111500493' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320796'
                WHERE ordernumber = 'P180718111540687' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348437'
                WHERE ordernumber = 'P180718111700116' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392160'
                WHERE ordernumber = 'P190718111822227' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332196'
                WHERE ordernumber = 'P420718112045482' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225197'
                WHERE ordernumber = 'P180718112242393' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389260'
                WHERE ordernumber = 'P200718112323396' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401826'
                WHERE ordernumber = 'P180718112523912' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401825'
                WHERE ordernumber = 'P190718112525883' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310921'
                WHERE ordernumber = 'P190718112636215' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350016'
                WHERE ordernumber = 'P180718113500762' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401724'
                WHERE ordernumber = 'P630718113559656' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401827'
                WHERE ordernumber = 'P200718113602195' 
            
2024-07-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240110'
                WHERE ordernumber = 'P180718113951604' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401679'
                WHERE ordernumber = 'P420718114241979' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381179'
                WHERE ordernumber = 'P420718114436630' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167929'
                WHERE ordernumber = 'P200718115145971' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401829'
                WHERE ordernumber = 'P180718115449389' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401831'
                WHERE ordernumber = 'P180718115757179' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351655'
                WHERE ordernumber = 'P180718120546902' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401835'
                WHERE ordernumber = 'P630718120757637' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401836'
                WHERE ordernumber = 'P420718121121582' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401838'
                WHERE ordernumber = 'P200718121443608' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401837'
                WHERE ordernumber = 'P420718121611564' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401839'
                WHERE ordernumber = 'P420718121931135' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401800'
                WHERE ordernumber = 'P180718122241245' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297135'
                WHERE ordernumber = 'P420718122755923' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294892'
                WHERE ordernumber = 'P420718122958376' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401842'
                WHERE ordernumber = 'P180718123259801' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166311'
                WHERE ordernumber = 'P200718123657130' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377568'
                WHERE ordernumber = 'P180718123704466' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166311'
                WHERE ordernumber = 'P200718123805669' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401845'
                WHERE ordernumber = 'P180718124541334' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401845'
                WHERE ordernumber = 'P180718124630461' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306291'
                WHERE ordernumber = 'P190718124842282' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401847'
                WHERE ordernumber = 'P180718125103397' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401296'
                WHERE ordernumber = 'P190718125134849' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140510'
                WHERE ordernumber = 'P180718125251605' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282036'
                WHERE ordernumber = 'P200718125435962' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401848'
                WHERE ordernumber = 'P180718125518636' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326775'
                WHERE ordernumber = 'P420718125900896' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386984'
                WHERE ordernumber = 'P180718130030410' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401850'
                WHERE ordernumber = 'P420718130105761' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94648'
                WHERE ordernumber = 'P200718130119665' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401851'
                WHERE ordernumber = 'P180718130948317' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401853'
                WHERE ordernumber = 'P200718131237969' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401852'
                WHERE ordernumber = 'P180718131245350' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401854'
                WHERE ordernumber = 'P180718131549582' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401855'
                WHERE ordernumber = 'P420718131945491' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393810'
                WHERE ordernumber = 'P180718132230654' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396655'
                WHERE ordernumber = 'P630718132507818' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270218'
                WHERE ordernumber = 'P200718132523351' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401857'
                WHERE ordernumber = 'P200718132920969' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397076'
                WHERE ordernumber = 'P180718133029948' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401859'
                WHERE ordernumber = 'P180718133403256' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401860'
                WHERE ordernumber = 'P190718133801920' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340676'
                WHERE ordernumber = 'P180718134111901' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401863'
                WHERE ordernumber = 'P180718134553668' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401865'
                WHERE ordernumber = 'P180718134739288' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285172'
                WHERE ordernumber = 'P630718134826604' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369507'
                WHERE ordernumber = 'P420718134956558' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96480'
                WHERE ordernumber = 'P180718135222555' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328300'
                WHERE ordernumber = 'P420718135422168' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371295'
                WHERE ordernumber = 'P190718135510445' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296943'
                WHERE ordernumber = 'P420718135954398' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103186'
                WHERE ordernumber = 'P420718140110493' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274671'
                WHERE ordernumber = 'P190718140947522' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80649'
                WHERE ordernumber = 'P420718141530176' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401869'
                WHERE ordernumber = 'P180718141618154' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383100'
                WHERE ordernumber = 'P190718142528755' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401872'
                WHERE ordernumber = 'P180718143200274' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95373'
                WHERE ordernumber = 'P420718143306764' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163121'
                WHERE ordernumber = 'P200718144535986' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401874'
                WHERE ordernumber = 'P180718144755846' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379036'
                WHERE ordernumber = 'P420718144926220' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401873'
                WHERE ordernumber = 'P180718145250562' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401875'
                WHERE ordernumber = 'P200718145617642' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401876'
                WHERE ordernumber = 'P180718145824299' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401878'
                WHERE ordernumber = 'P180718150003413' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401877'
                WHERE ordernumber = 'P420718150030652' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401879'
                WHERE ordernumber = 'P180718150104388' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227100'
                WHERE ordernumber = 'P180718150205828' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363966'
                WHERE ordernumber = 'P420718150233748' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401878'
                WHERE ordernumber = 'P180718150254648' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401881'
                WHERE ordernumber = 'P180718150709544' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401882'
                WHERE ordernumber = 'P420718150841247' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401883'
                WHERE ordernumber = 'P200718150932670' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401885'
                WHERE ordernumber = 'P190718151425713' 
            
2024-07-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397977'
                WHERE ordernumber = 'P630718151654677' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401886'
                WHERE ordernumber = 'P180718151946329' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121185'
                WHERE ordernumber = 'P180718152349925' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249425'
                WHERE ordernumber = 'P200718152637207' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214003'
                WHERE ordernumber = 'P200718152955650' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121863'
                WHERE ordernumber = 'P180718153001227' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400098'
                WHERE ordernumber = 'P200718153130861' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86775'
                WHERE ordernumber = 'P180718153140379' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401892'
                WHERE ordernumber = 'P180718153633111' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388814'
                WHERE ordernumber = 'P420718153720545' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401893'
                WHERE ordernumber = 'P180718153831936' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388711'
                WHERE ordernumber = 'P180718154302393' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401894'
                WHERE ordernumber = 'P420718154709976' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '158000'
                WHERE ordernumber = 'P200718155017280' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364605'
                WHERE ordernumber = 'P200718155431793' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401898'
                WHERE ordernumber = 'P420718155523760' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401899'
                WHERE ordernumber = 'P180718155605572' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401896'
                WHERE ordernumber = 'P420718155631864' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401900'
                WHERE ordernumber = 'P180718160137217' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295853'
                WHERE ordernumber = 'P630718160343162' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401901'
                WHERE ordernumber = 'P420718160441687' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401902'
                WHERE ordernumber = 'P180718160543630' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312381'
                WHERE ordernumber = 'P200718160722419' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '135689'
                WHERE ordernumber = 'P180718161020585' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401903'
                WHERE ordernumber = 'P180718161151226' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P180718161321728' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401904'
                WHERE ordernumber = 'P190718161604995' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401905'
                WHERE ordernumber = 'P420718162002489' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390264'
                WHERE ordernumber = 'P420718162101892' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401906'
                WHERE ordernumber = 'P420718162611816' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401906'
                WHERE ordernumber = 'P420718162752846' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242459'
                WHERE ordernumber = 'P190718163055518' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235961'
                WHERE ordernumber = 'P200718163258160' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378446'
                WHERE ordernumber = 'P190718163303715' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401907'
                WHERE ordernumber = 'P180718163433945' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401908'
                WHERE ordernumber = 'P200718163552563' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341981'
                WHERE ordernumber = 'P420718163754252' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401909'
                WHERE ordernumber = 'P190718164025935' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248185'
                WHERE ordernumber = 'P190718164140861' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401910'
                WHERE ordernumber = 'P190718164449581' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401911'
                WHERE ordernumber = 'P420718164653244' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401912'
                WHERE ordernumber = 'P420718164949436' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98455'
                WHERE ordernumber = 'P180718165024882' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '135124'
                WHERE ordernumber = 'P200718165029861' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395863'
                WHERE ordernumber = 'P180718165057607' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401914'
                WHERE ordernumber = 'P180718165217616' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401915'
                WHERE ordernumber = 'P420718165337114' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '140423'
                WHERE ordernumber = 'P630718165349994' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '143978'
                WHERE ordernumber = 'P180718165604198' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397198'
                WHERE ordernumber = 'P200718165631956' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180718165719226' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401917'
                WHERE ordernumber = 'P180718165837950' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401918'
                WHERE ordernumber = 'P420718165945763' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386126'
                WHERE ordernumber = 'P180718170034793' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401919'
                WHERE ordernumber = 'P190718170046971' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396908'
                WHERE ordernumber = 'P630718170244599' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401922'
                WHERE ordernumber = 'P420718171314194' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393465'
                WHERE ordernumber = 'P180718171433624' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401923'
                WHERE ordernumber = 'P180718171610440' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401924'
                WHERE ordernumber = 'P190718172037820' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401925'
                WHERE ordernumber = 'P420718172100934' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399715'
                WHERE ordernumber = 'P200718172206461' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401675'
                WHERE ordernumber = 'P200718172500210' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401927'
                WHERE ordernumber = 'P180718172708516' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401928'
                WHERE ordernumber = 'P420718173037222' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306336'
                WHERE ordernumber = 'P190718173409725' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401929'
                WHERE ordernumber = 'P200718173454665' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '243898'
                WHERE ordernumber = 'P200718174246117' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401930'
                WHERE ordernumber = 'P200718174447920' 
            
2024-07-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310470'
                WHERE ordernumber = 'P200718175023525' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '310470'
                WHERE ordernumber = 'P200718175107443' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401931'
                WHERE ordernumber = 'P190718175109685' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401932'
                WHERE ordernumber = 'P420718175139324' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401933'
                WHERE ordernumber = 'P190718175354712' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '341726'
                WHERE ordernumber = 'P420718175417158' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '332962'
                WHERE ordernumber = 'P200718175803460' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401935'
                WHERE ordernumber = 'P420718180203696' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401936'
                WHERE ordernumber = 'P190718180314137' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401937'
                WHERE ordernumber = 'P180718180346130' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401938'
                WHERE ordernumber = 'P180718180531268' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '224033'
                WHERE ordernumber = 'P180718180856127' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '160954'
                WHERE ordernumber = 'P200718181132167' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401940'
                WHERE ordernumber = 'P420718181613258' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401941'
                WHERE ordernumber = 'P190718181632711' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '378608'
                WHERE ordernumber = 'P190718181830146' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '381473'
                WHERE ordernumber = 'P200718182116520' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401942'
                WHERE ordernumber = 'P180718182234989' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '332900'
                WHERE ordernumber = 'P420718182423357' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '296980'
                WHERE ordernumber = 'P420718182559347' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '242789'
                WHERE ordernumber = 'P180718183313123' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '248589'
                WHERE ordernumber = 'P420718183511393' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '381760'
                WHERE ordernumber = 'P190718183839780' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401944'
                WHERE ordernumber = 'P180718184024120' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '381760'
                WHERE ordernumber = 'P190718184126804' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '385555'
                WHERE ordernumber = 'P630718184238391' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '310246'
                WHERE ordernumber = 'P200718184921686' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401945'
                WHERE ordernumber = 'P190718185004858' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '237422'
                WHERE ordernumber = 'P190718185631740' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401946'
                WHERE ordernumber = 'P200718185723258' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401947'
                WHERE ordernumber = 'P200718185943804' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401948'
                WHERE ordernumber = 'P200718190216947' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '234470'
                WHERE ordernumber = 'P200718190331800' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '118908'
                WHERE ordernumber = 'P190718190352693' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '315327'
                WHERE ordernumber = 'P200718190454834' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400669'
                WHERE ordernumber = 'P200718190613461' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '150491'
                WHERE ordernumber = 'P200718190655847' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '298550'
                WHERE ordernumber = 'P200718190908708' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '391040'
                WHERE ordernumber = 'P190718191246273' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401950'
                WHERE ordernumber = 'P190718191537912' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '377543'
                WHERE ordernumber = 'P190718192532987' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '155149'
                WHERE ordernumber = 'P200718192605627' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401952'
                WHERE ordernumber = 'P200718192957987' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401953'
                WHERE ordernumber = 'P190718193137845' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '29379'
                WHERE ordernumber = 'P200718193238950' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '341422'
                WHERE ordernumber = 'P190718193250986' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401954'
                WHERE ordernumber = 'P190718193448211' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '225352'
                WHERE ordernumber = 'P190718193731580' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401955'
                WHERE ordernumber = 'P200718193818412' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '384066'
                WHERE ordernumber = 'P190718193952571' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401956'
                WHERE ordernumber = 'P200718194509281' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401957'
                WHERE ordernumber = 'P190718194632346' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401769'
                WHERE ordernumber = 'P200718194648352' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '300777'
                WHERE ordernumber = 'P630718195511460' 
            
2024-07-19 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '103462'
                WHERE ordernumber = 'P200718200015241'