2024-06-19 01:00:02 -- 將會員中心id寫入data-lake
2024-06-19 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-06-18%';
        
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396533'
                WHERE ordernumber = 'P180618110345120' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237079'
                WHERE ordernumber = 'P200618110558689' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396535'
                WHERE ordernumber = 'P180618110708282' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396537'
                WHERE ordernumber = 'P200618110733401' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289505'
                WHERE ordernumber = 'P180618110840467' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381202'
                WHERE ordernumber = 'P180618111105993' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303137'
                WHERE ordernumber = 'P200618111148883' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396538'
                WHERE ordernumber = 'P200618111321504' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367263'
                WHERE ordernumber = 'P190618111456655' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360436'
                WHERE ordernumber = 'P180618111512853' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349708'
                WHERE ordernumber = 'P200618111627146' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396540'
                WHERE ordernumber = 'P630618112200892' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396541'
                WHERE ordernumber = 'P190618112213834' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94815'
                WHERE ordernumber = 'P200618112301529' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396127'
                WHERE ordernumber = 'P180618112748564' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218548'
                WHERE ordernumber = 'P200618112921632' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93652'
                WHERE ordernumber = 'P200618113008439' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396543'
                WHERE ordernumber = 'P180618113530887' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396546'
                WHERE ordernumber = 'P180618114537339' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P180618114633255' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P200618114755884' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396548'
                WHERE ordernumber = 'P420618114915294' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308957'
                WHERE ordernumber = 'P420618115025888' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396549'
                WHERE ordernumber = 'P180618115043642' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '88798'
                WHERE ordernumber = 'P180618115228420' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '17177'
                WHERE ordernumber = 'P630618115548893' 
            
2024-06-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '215833'
                WHERE ordernumber = 'P180618115848786' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396551'
                WHERE ordernumber = 'P180618120453639' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385517'
                WHERE ordernumber = 'P180618120603501' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396552'
                WHERE ordernumber = 'P420618120609729' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385398'
                WHERE ordernumber = 'P200618121005372' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396554'
                WHERE ordernumber = 'P420618121424764' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396555'
                WHERE ordernumber = 'P420618121752792' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396556'
                WHERE ordernumber = 'P180618121808748' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396557'
                WHERE ordernumber = 'P420618121932120' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118039'
                WHERE ordernumber = 'P180618122042276' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326762'
                WHERE ordernumber = 'P180618122732281' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118048'
                WHERE ordernumber = 'P200618122936923' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396560'
                WHERE ordernumber = 'P420618123037382' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396561'
                WHERE ordernumber = 'P200618123204865' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396562'
                WHERE ordernumber = 'P420618123310920' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396563'
                WHERE ordernumber = 'P180618123400868' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396564'
                WHERE ordernumber = 'P420618123455134' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226438'
                WHERE ordernumber = 'P200618123624117' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396565'
                WHERE ordernumber = 'P420618123626637' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275106'
                WHERE ordernumber = 'P200618123818801' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396566'
                WHERE ordernumber = 'P420618123822655' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396567'
                WHERE ordernumber = 'P420618124305758' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383470'
                WHERE ordernumber = 'P180618124327740' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393068'
                WHERE ordernumber = 'P200618124604762' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396569'
                WHERE ordernumber = 'P180618125215269' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81074'
                WHERE ordernumber = 'P200618125300657' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396570'
                WHERE ordernumber = 'P180618130028456' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384968'
                WHERE ordernumber = 'P420618130359788' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396571'
                WHERE ordernumber = 'P180618130816816' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396573'
                WHERE ordernumber = 'P200618131056831' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396572'
                WHERE ordernumber = 'P780618131133495' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396574'
                WHERE ordernumber = 'P200618131334719' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395782'
                WHERE ordernumber = 'P200618131512822' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396575'
                WHERE ordernumber = 'P780618131941824' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266551'
                WHERE ordernumber = 'P180618132911550' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394797'
                WHERE ordernumber = 'P420618132941735' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266551'
                WHERE ordernumber = 'P180618132958600' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P180618133242903' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251032'
                WHERE ordernumber = 'P180618133737291' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165516'
                WHERE ordernumber = 'P180618134040612' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336612'
                WHERE ordernumber = 'P200618134159185' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391544'
                WHERE ordernumber = 'P420618134300788' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396580'
                WHERE ordernumber = 'P180618134809332' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281300'
                WHERE ordernumber = 'P180618135516759' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396583'
                WHERE ordernumber = 'P630618140324695' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396584'
                WHERE ordernumber = 'P200618140457120' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396584'
                WHERE ordernumber = 'P200618140601729' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389109'
                WHERE ordernumber = 'P630618140625291' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103927'
                WHERE ordernumber = 'P200618140937692' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301837'
                WHERE ordernumber = 'P420618141620966' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230436'
                WHERE ordernumber = 'P180618142303636' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384016'
                WHERE ordernumber = 'P630618142653116' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396590'
                WHERE ordernumber = 'P180618142858949' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340358'
                WHERE ordernumber = 'P180618143733837' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218050'
                WHERE ordernumber = 'P180618144426264' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396591'
                WHERE ordernumber = 'P180618145330419' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396592'
                WHERE ordernumber = 'P630618145544944' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224573'
                WHERE ordernumber = 'P200618150314578' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245917'
                WHERE ordernumber = 'P180618150844309' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396593'
                WHERE ordernumber = 'P190618150924991' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396594'
                WHERE ordernumber = 'P180618151008752' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396595'
                WHERE ordernumber = 'P190618151137652' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396596'
                WHERE ordernumber = 'P420618151922201' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396597'
                WHERE ordernumber = 'P420618152458477' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270656'
                WHERE ordernumber = 'P200618152525397' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396598'
                WHERE ordernumber = 'P180618152724113' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396600'
                WHERE ordernumber = 'P180618153052391' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396601'
                WHERE ordernumber = 'P180618153206920' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396602'
                WHERE ordernumber = 'P190618153246603' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103395'
                WHERE ordernumber = 'P200618153303536' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396603'
                WHERE ordernumber = 'P180618153325311' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396605'
                WHERE ordernumber = 'P420618153711247' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396589'
                WHERE ordernumber = 'P420618153913950' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396607'
                WHERE ordernumber = 'P780618154719553' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396609'
                WHERE ordernumber = 'P180618155337196' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396610'
                WHERE ordernumber = 'P180618155520943' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396611'
                WHERE ordernumber = 'P420618160257306' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396612'
                WHERE ordernumber = 'P190618161133679' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396613'
                WHERE ordernumber = 'P780618161356805' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219582'
                WHERE ordernumber = 'P180618161850600' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391746'
                WHERE ordernumber = 'P420618162054477' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396614'
                WHERE ordernumber = 'P190618162311863' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396615'
                WHERE ordernumber = 'P190618162647891' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396616'
                WHERE ordernumber = 'P180618163127804' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262385'
                WHERE ordernumber = 'P200618163646309' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300227'
                WHERE ordernumber = 'P180618163852447' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396617'
                WHERE ordernumber = 'P200618164004619' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396618'
                WHERE ordernumber = 'P200618164315342' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396619'
                WHERE ordernumber = 'P190618164457690' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396620'
                WHERE ordernumber = 'P190618164808303' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293045'
                WHERE ordernumber = 'P180618165423848' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224228'
                WHERE ordernumber = 'P180618170229534' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301737'
                WHERE ordernumber = 'P200618170315294' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299129'
                WHERE ordernumber = 'P200618170810883' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396625'
                WHERE ordernumber = 'P420618171654737' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396626'
                WHERE ordernumber = 'P200618172010490' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396628'
                WHERE ordernumber = 'P200618172210338' 
            
2024-06-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396627'
                WHERE ordernumber = 'P180618172323185' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310554'
                WHERE ordernumber = 'P200618172522400' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303028'
                WHERE ordernumber = 'P180618172703377' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329353'
                WHERE ordernumber = 'P190618173511462' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99444'
                WHERE ordernumber = 'P200618173535684' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99444'
                WHERE ordernumber = 'P200618173606575' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94993'
                WHERE ordernumber = 'P200618173731610' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118593'
                WHERE ordernumber = 'P180618173751890' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396321'
                WHERE ordernumber = 'P420618173831359' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96699'
                WHERE ordernumber = 'P190618173835652' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288125'
                WHERE ordernumber = 'P200618173843524' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396631'
                WHERE ordernumber = 'P180618174212348' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125544'
                WHERE ordernumber = 'P190618174322114' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250500'
                WHERE ordernumber = 'P420618174505342' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343914'
                WHERE ordernumber = 'P200618174656363' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267490'
                WHERE ordernumber = 'P180618175446398' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396632'
                WHERE ordernumber = 'P200618175539232' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396633'
                WHERE ordernumber = 'P180618175806285' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74730'
                WHERE ordernumber = 'P420618180022713' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396634'
                WHERE ordernumber = 'P200618180109524' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354447'
                WHERE ordernumber = 'P630618180144760' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141131'
                WHERE ordernumber = 'P200618180227633' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396635'
                WHERE ordernumber = 'P420618180252695' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396636'
                WHERE ordernumber = 'P190618180415769' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271982'
                WHERE ordernumber = 'P180618180816440' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396637'
                WHERE ordernumber = 'P200618180936506' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305740'
                WHERE ordernumber = 'P200618181023634' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396638'
                WHERE ordernumber = 'P420618181221230' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396639'
                WHERE ordernumber = 'P180618181316873' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100500'
                WHERE ordernumber = 'P180618182009769' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104875'
                WHERE ordernumber = 'P180618182330358' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327044'
                WHERE ordernumber = 'P420618182332338' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396641'
                WHERE ordernumber = 'P180618182535985' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396642'
                WHERE ordernumber = 'P420618182556831' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327044'
                WHERE ordernumber = 'P420618182817525' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271064'
                WHERE ordernumber = 'P420618183323693' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100898'
                WHERE ordernumber = 'P420618183947856' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396640'
                WHERE ordernumber = 'P200618184020585' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379412'
                WHERE ordernumber = 'P190618184148318' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396644'
                WHERE ordernumber = 'P190618184356170' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395497'
                WHERE ordernumber = 'P200618184413904' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395497'
                WHERE ordernumber = 'P200618184423220' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396643'
                WHERE ordernumber = 'P200618184612746' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396645'
                WHERE ordernumber = 'P200618185031582' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321851'
                WHERE ordernumber = 'P190618185549528' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129280'
                WHERE ordernumber = 'P200618185603262' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396646'
                WHERE ordernumber = 'P200618185646182' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387045'
                WHERE ordernumber = 'P190618185745475' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P190618190032459' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396647'
                WHERE ordernumber = 'P190618190200198' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396648'
                WHERE ordernumber = 'P200618190320502' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396649'
                WHERE ordernumber = 'P190618190639261' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396650'
                WHERE ordernumber = 'P190618190849707' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396651'
                WHERE ordernumber = 'P190618191326716' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96695'
                WHERE ordernumber = 'P190618191603976' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396652'
                WHERE ordernumber = 'P190618191712825' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396653'
                WHERE ordernumber = 'P630618191821456' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200618192335163' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133033'
                WHERE ordernumber = 'P200618192420719' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390008'
                WHERE ordernumber = 'P190618193511834' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396655'
                WHERE ordernumber = 'P630618193808340' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161966'
                WHERE ordernumber = 'P200618194146765' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396656'
                WHERE ordernumber = 'P200618194234758' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393800'
                WHERE ordernumber = 'P190618194527594' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396657'
                WHERE ordernumber = 'P200618194621849' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312116'
                WHERE ordernumber = 'P200618195149813' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266742'
                WHERE ordernumber = 'P200618195307184' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341272'
                WHERE ordernumber = 'P200618195436396' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396508'
                WHERE ordernumber = 'P190618195859931' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387406'
                WHERE ordernumber = 'P780618202357478' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396662'
                WHERE ordernumber = 'P630618205418361' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396664'
                WHERE ordernumber = 'P630618211412783' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384207'
                WHERE ordernumber = 'P630618215636674' 
            
2024-06-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384207'
                WHERE ordernumber = 'P630618221124389'