2024-02-18 01:00:02 -- 將會員中心id寫入data-lake
2024-02-18 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-02-17%';
        
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377580'
                WHERE ordernumber = 'P420217104134423' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377582'
                WHERE ordernumber = 'P420217105842289' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311650'
                WHERE ordernumber = 'P200217110222160' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377583'
                WHERE ordernumber = 'P200217110358310' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '144374'
                WHERE ordernumber = 'P190217110409565' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227424'
                WHERE ordernumber = 'P190217110522823' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227203'
                WHERE ordernumber = 'P190217110605310' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377584'
                WHERE ordernumber = 'P420217110650628' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345808'
                WHERE ordernumber = 'P180217110749887' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88259'
                WHERE ordernumber = 'P190217110840429' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94539'
                WHERE ordernumber = 'P200217110846128' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377586'
                WHERE ordernumber = 'P420217111128716' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377587'
                WHERE ordernumber = 'P190217111354626' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377588'
                WHERE ordernumber = 'P420217111459769' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377592'
                WHERE ordernumber = 'P190217112225802' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308600'
                WHERE ordernumber = 'P420217112631629' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374695'
                WHERE ordernumber = 'P180217112751886' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246107'
                WHERE ordernumber = 'P200217112803559' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281760'
                WHERE ordernumber = 'P190217112845489' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377596'
                WHERE ordernumber = 'P420217112953995' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377598'
                WHERE ordernumber = 'P420217113555209' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377599'
                WHERE ordernumber = 'P200217113612958' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281760'
                WHERE ordernumber = 'P190217113617444' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269520'
                WHERE ordernumber = 'P180217113759245' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377595'
                WHERE ordernumber = 'P420217113926132' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266367'
                WHERE ordernumber = 'P200217114034433' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266367'
                WHERE ordernumber = 'P200217114120969' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377595'
                WHERE ordernumber = 'P420217114146200' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P200217114202951' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377600'
                WHERE ordernumber = 'P180217114248486' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377601'
                WHERE ordernumber = 'P420217114313959' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264542'
                WHERE ordernumber = 'P180217114501802' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243305'
                WHERE ordernumber = 'P200217114652135' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361444'
                WHERE ordernumber = 'P180217114800967' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377603'
                WHERE ordernumber = 'P190217114853553' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159425'
                WHERE ordernumber = 'P200217114854344' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243305'
                WHERE ordernumber = 'P200217114918712' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377604'
                WHERE ordernumber = 'P180217114950508' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97989'
                WHERE ordernumber = 'P180217115035527' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377605'
                WHERE ordernumber = 'P420217115057310' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331547'
                WHERE ordernumber = 'P200217115118590' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377602'
                WHERE ordernumber = 'P420217115144149' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275812'
                WHERE ordernumber = 'P190217115158256' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377606'
                WHERE ordernumber = 'P420217115314416' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377607'
                WHERE ordernumber = 'P180217115349720' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377608'
                WHERE ordernumber = 'P190217115405190' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327936'
                WHERE ordernumber = 'P200217120249507' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377610'
                WHERE ordernumber = 'P190217120600526' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377612'
                WHERE ordernumber = 'P180217120801875' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377611'
                WHERE ordernumber = 'P420217120811259' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226416'
                WHERE ordernumber = 'P190217120932306' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P420217121143900' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208525'
                WHERE ordernumber = 'P190217121539273' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309439'
                WHERE ordernumber = 'P190217121834424' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309439'
                WHERE ordernumber = 'P190217121929929' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365805'
                WHERE ordernumber = 'P190217122511112' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377614'
                WHERE ordernumber = 'P420217122731299' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339653'
                WHERE ordernumber = 'P420217123246542' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377616'
                WHERE ordernumber = 'P190217123312776' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377619'
                WHERE ordernumber = 'P420217123401619' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345580'
                WHERE ordernumber = 'P200217123423545' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377615'
                WHERE ordernumber = 'P420217123442487' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377620'
                WHERE ordernumber = 'P420217123542814' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92045'
                WHERE ordernumber = 'P190217123549668' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377622'
                WHERE ordernumber = 'P420217123711439' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145633'
                WHERE ordernumber = 'P190217123807430' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377624'
                WHERE ordernumber = 'P190217124558341' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350514'
                WHERE ordernumber = 'P420217124654610' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377535'
                WHERE ordernumber = 'P200217124731193' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377273'
                WHERE ordernumber = 'P190217124830601' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377626'
                WHERE ordernumber = 'P190217125022851' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377627'
                WHERE ordernumber = 'P190217125656845' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377630'
                WHERE ordernumber = 'P190217125806818' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377629'
                WHERE ordernumber = 'P200217125810303' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321114'
                WHERE ordernumber = 'P190217125919678' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346441'
                WHERE ordernumber = 'P200217125919716' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377621'
                WHERE ordernumber = 'P180217130155651' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377631'
                WHERE ordernumber = 'P180217130336514' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377582'
                WHERE ordernumber = 'P420217130441330' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377632'
                WHERE ordernumber = 'P420217130613768' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343306'
                WHERE ordernumber = 'P180217130717765' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357089'
                WHERE ordernumber = 'P420217130743999' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240498'
                WHERE ordernumber = 'P200217130801321' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338249'
                WHERE ordernumber = 'P190217131659860' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136223'
                WHERE ordernumber = 'P200217131721535' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211564'
                WHERE ordernumber = 'P190217131753198' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361213'
                WHERE ordernumber = 'P190217131849243' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377634'
                WHERE ordernumber = 'P190217132323496' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257299'
                WHERE ordernumber = 'P200217132946160' 
            
2024-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376147'
                WHERE ordernumber = 'P190217132951828' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377569'
                WHERE ordernumber = 'P420217133031749' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377635'
                WHERE ordernumber = 'P420217133343384' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377636'
                WHERE ordernumber = 'P420217133608719' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369193'
                WHERE ordernumber = 'P200217134014194' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352175'
                WHERE ordernumber = 'P180217134329995' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377637'
                WHERE ordernumber = 'P180217134653443' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377638'
                WHERE ordernumber = 'P200217134856505' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131195'
                WHERE ordernumber = 'P190217135101228' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297104'
                WHERE ordernumber = 'P420217135104799' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102055'
                WHERE ordernumber = 'P200217135129552' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253287'
                WHERE ordernumber = 'P180217135144263' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345242'
                WHERE ordernumber = 'P180217135504599' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214934'
                WHERE ordernumber = 'P200217140047210' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353307'
                WHERE ordernumber = 'P200217141049267' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358072'
                WHERE ordernumber = 'P200217141403756' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377644'
                WHERE ordernumber = 'P180217141830401' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377645'
                WHERE ordernumber = 'P190217142256839' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154928'
                WHERE ordernumber = 'P420217142258631' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376296'
                WHERE ordernumber = 'P180217142318696' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377181'
                WHERE ordernumber = 'P190217142456949' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160169'
                WHERE ordernumber = 'P180217142748627' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377647'
                WHERE ordernumber = 'P200217142808216' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377647'
                WHERE ordernumber = 'P200217142842283' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349883'
                WHERE ordernumber = 'P190217142921650' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258964'
                WHERE ordernumber = 'P200217142928483' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377648'
                WHERE ordernumber = 'P200217143030254' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93632'
                WHERE ordernumber = 'P200217143105767' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377649'
                WHERE ordernumber = 'P180217143133372' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367527'
                WHERE ordernumber = 'P420217143415702' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367527'
                WHERE ordernumber = 'P420217143505390' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377650'
                WHERE ordernumber = 'P180217143745637' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377652'
                WHERE ordernumber = 'P420217143745859' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377653'
                WHERE ordernumber = 'P180217143904315' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377654'
                WHERE ordernumber = 'P190217143916360' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '50124'
                WHERE ordernumber = 'P180217144019382' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298067'
                WHERE ordernumber = 'P190217144022192' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377655'
                WHERE ordernumber = 'P180217144142787' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377656'
                WHERE ordernumber = 'P190217144241866' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342844'
                WHERE ordernumber = 'P420217144345415' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238634'
                WHERE ordernumber = 'P200217145012584' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180217145726256' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261156'
                WHERE ordernumber = 'P180217145913776' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377658'
                WHERE ordernumber = 'P420217150453592' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309204'
                WHERE ordernumber = 'P200217150655256' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261156'
                WHERE ordernumber = 'P180217150704168' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377659'
                WHERE ordernumber = 'P190217150921658' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377660'
                WHERE ordernumber = 'P180217151046506' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P190217151226459' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377660'
                WHERE ordernumber = 'P180217151244894' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377183'
                WHERE ordernumber = 'P190217151459914' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377183'
                WHERE ordernumber = 'P190217151532147' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377661'
                WHERE ordernumber = 'P200217151736773' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271235'
                WHERE ordernumber = 'P190217152401962' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377663'
                WHERE ordernumber = 'P190217152455523' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377664'
                WHERE ordernumber = 'P190217152551344' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214632'
                WHERE ordernumber = 'P190217152651900' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377666'
                WHERE ordernumber = 'P190217152748502' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376350'
                WHERE ordernumber = 'P190217153115964' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377668'
                WHERE ordernumber = 'P190217153222301' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283036'
                WHERE ordernumber = 'P190217153758325' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377670'
                WHERE ordernumber = 'P180217153953540' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377671'
                WHERE ordernumber = 'P190217154059780' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369795'
                WHERE ordernumber = 'P420217154243519' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95422'
                WHERE ordernumber = 'P190217154601816' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108125'
                WHERE ordernumber = 'P190217154740130' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377674'
                WHERE ordernumber = 'P420217154751392' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377675'
                WHERE ordernumber = 'P180217154806739' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269289'
                WHERE ordernumber = 'P420217154946140' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377676'
                WHERE ordernumber = 'P180217154957602' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228397'
                WHERE ordernumber = 'P190217155059476' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364886'
                WHERE ordernumber = 'P190217155237417' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236193'
                WHERE ordernumber = 'P190217155327341' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377677'
                WHERE ordernumber = 'P420217155426401' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267822'
                WHERE ordernumber = 'P180217155653988' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377678'
                WHERE ordernumber = 'P420217155707482' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377679'
                WHERE ordernumber = 'P200217155802755' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377680'
                WHERE ordernumber = 'P420217155847562' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377681'
                WHERE ordernumber = 'P420217160027534' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377682'
                WHERE ordernumber = 'P200217160305403' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377683'
                WHERE ordernumber = 'P180217160428282' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377684'
                WHERE ordernumber = 'P190217160505982' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336237'
                WHERE ordernumber = 'P420217160526483' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275250'
                WHERE ordernumber = 'P200217160618258' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275250'
                WHERE ordernumber = 'P200217160702860' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319102'
                WHERE ordernumber = 'P180217160741495' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377685'
                WHERE ordernumber = 'P420217160910216' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279239'
                WHERE ordernumber = 'P200217160935460' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377328'
                WHERE ordernumber = 'P180217160948266' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377328'
                WHERE ordernumber = 'P180217161016976' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338194'
                WHERE ordernumber = 'P190217161100908' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292423'
                WHERE ordernumber = 'P200217161114692' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377687'
                WHERE ordernumber = 'P420217161536559' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235347'
                WHERE ordernumber = 'P200217161901150' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377688'
                WHERE ordernumber = 'P190217161938132' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377690'
                WHERE ordernumber = 'P180217162056773' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377689'
                WHERE ordernumber = 'P190217162059360' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377467'
                WHERE ordernumber = 'P200217162103205' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377691'
                WHERE ordernumber = 'P190217162218771' 
            
2024-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377692'
                WHERE ordernumber = 'P180217162353407' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94565'
                WHERE ordernumber = 'P180217162546536' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365228'
                WHERE ordernumber = 'P420217162754739' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377694'
                WHERE ordernumber = 'P420217162833681' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377695'
                WHERE ordernumber = 'P190217162859226' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377698'
                WHERE ordernumber = 'P190217163046265' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '330285'
                WHERE ordernumber = 'P200217163722791' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348071'
                WHERE ordernumber = 'P420217163725608' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285699'
                WHERE ordernumber = 'P190217163910340' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377700'
                WHERE ordernumber = 'P190217164050882' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238134'
                WHERE ordernumber = 'P200217164208597' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278646'
                WHERE ordernumber = 'P180217164224316' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372740'
                WHERE ordernumber = 'P420217164403376' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377701'
                WHERE ordernumber = 'P180217164615557' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377702'
                WHERE ordernumber = 'P190217164619793' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348119'
                WHERE ordernumber = 'P420217165038387' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377704'
                WHERE ordernumber = 'P420217165304949' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377704'
                WHERE ordernumber = 'P420217165403206' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377703'
                WHERE ordernumber = 'P190217165619766' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377705'
                WHERE ordernumber = 'P190217165740794' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231594'
                WHERE ordernumber = 'P190217170110136' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212237'
                WHERE ordernumber = 'P190217170410518' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377706'
                WHERE ordernumber = 'P420217170919671' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '375020'
                WHERE ordernumber = 'P420217171106712' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299626'
                WHERE ordernumber = 'P200217171132125' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377707'
                WHERE ordernumber = 'P190217171359437' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377504'
                WHERE ordernumber = 'P420217171725626' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '163620'
                WHERE ordernumber = 'P190217172224202' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377708'
                WHERE ordernumber = 'P190217172301165' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218531'
                WHERE ordernumber = 'P190217172403949' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348093'
                WHERE ordernumber = 'P200217172442928' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377710'
                WHERE ordernumber = 'P200217172631683' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348093'
                WHERE ordernumber = 'P200217172831164' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377711'
                WHERE ordernumber = 'P190217173116705' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377713'
                WHERE ordernumber = 'P190217173420622' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377712'
                WHERE ordernumber = 'P420217173427748' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377711'
                WHERE ordernumber = 'P190217173511799' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '49039'
                WHERE ordernumber = 'P200217173522851' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377715'
                WHERE ordernumber = 'P420217174009560' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377716'
                WHERE ordernumber = 'P190217174501930' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377408'
                WHERE ordernumber = 'P420217174524963' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342655'
                WHERE ordernumber = 'P190217174557815' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377717'
                WHERE ordernumber = 'P420217174841559' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377718'
                WHERE ordernumber = 'P190217175107534' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377719'
                WHERE ordernumber = 'P420217175149248' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377721'
                WHERE ordernumber = 'P420217175321954' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160130'
                WHERE ordernumber = 'P190217175456174' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377408'
                WHERE ordernumber = 'P420217175535254' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377722'
                WHERE ordernumber = 'P190217175601484' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288937'
                WHERE ordernumber = 'P190217180120558' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377724'
                WHERE ordernumber = 'P190217180826233' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377725'
                WHERE ordernumber = 'P190217180925629' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377726'
                WHERE ordernumber = 'P190217181037504' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '27925'
                WHERE ordernumber = 'P190217181159799' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377728'
                WHERE ordernumber = 'P180217181215943' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377727'
                WHERE ordernumber = 'P420217181217208' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377729'
                WHERE ordernumber = 'P190217181308327' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362335'
                WHERE ordernumber = 'P180217181309453' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362335'
                WHERE ordernumber = 'P180217181406142' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377732'
                WHERE ordernumber = 'P180217181529123' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377315'
                WHERE ordernumber = 'P190217181603305' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377734'
                WHERE ordernumber = 'P180217181731246' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '255644'
                WHERE ordernumber = 'P420217181840589' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '133256'
                WHERE ordernumber = 'P180217182104261' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377736'
                WHERE ordernumber = 'P190217182145592' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377739'
                WHERE ordernumber = 'P200217182810626' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377740'
                WHERE ordernumber = 'P190217182820624' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377741'
                WHERE ordernumber = 'P180217182907343' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377742'
                WHERE ordernumber = 'P190217182942757' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '375259'
                WHERE ordernumber = 'P180217182954536' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240864'
                WHERE ordernumber = 'P200217183054116' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377744'
                WHERE ordernumber = 'P190217183208704' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377745'
                WHERE ordernumber = 'P420217183644698' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368945'
                WHERE ordernumber = 'P200217184149511' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377746'
                WHERE ordernumber = 'P190217184643243' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377586'
                WHERE ordernumber = 'P420217184653482' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377747'
                WHERE ordernumber = 'P190217184923987' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342978'
                WHERE ordernumber = 'P190217185413518' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377618'
                WHERE ordernumber = 'P190217185503134' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277785'
                WHERE ordernumber = 'P190217185647857' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '373821'
                WHERE ordernumber = 'P190217185921881' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342617'
                WHERE ordernumber = 'P190217190154312' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377748'
                WHERE ordernumber = 'P190217190327121' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367207'
                WHERE ordernumber = 'P190217190450949' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '216155'
                WHERE ordernumber = 'P420217190708360' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305914'
                WHERE ordernumber = 'P200217190818872' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377749'
                WHERE ordernumber = 'P420217190842121' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377750'
                WHERE ordernumber = 'P190217191111462' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377751'
                WHERE ordernumber = 'P190217191305207' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377753'
                WHERE ordernumber = 'P200217192331488' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '373453'
                WHERE ordernumber = 'P200217192534212' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '132818'
                WHERE ordernumber = 'P200217192643249' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '46166'
                WHERE ordernumber = 'P190217193106319' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377754'
                WHERE ordernumber = 'P420217193307708' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352675'
                WHERE ordernumber = 'P190217193316574' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377755'
                WHERE ordernumber = 'P190217193511746' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377756'
                WHERE ordernumber = 'P190217193647153' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377564'
                WHERE ordernumber = 'P190217193911291' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377757'
                WHERE ordernumber = 'P420217194016269' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377562'
                WHERE ordernumber = 'P200217195016214' 
            
2024-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377562'
                WHERE ordernumber = 'P200217195101527'