2023-12-29 01:00:02 -- 將會員中心id寫入data-lake
2023-12-29 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 '2023-12-28%';
        
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309225'
                WHERE ordernumber = 'P201228104616703' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339493'
                WHERE ordernumber = 'P201228105009207' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P191228105121935' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355899'
                WHERE ordernumber = 'P201228110941735' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249056'
                WHERE ordernumber = 'P201228111056997' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244882'
                WHERE ordernumber = 'P191228111140743' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299091'
                WHERE ordernumber = 'P191228112020717' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '169193'
                WHERE ordernumber = 'P191228112116128' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355908'
                WHERE ordernumber = 'P191228112301801' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355907'
                WHERE ordernumber = 'P191228112554409' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266731'
                WHERE ordernumber = 'P201228113145936' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P191228113355496' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P191228113720957' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355912'
                WHERE ordernumber = 'P201228113724302' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355913'
                WHERE ordernumber = 'P201228113830578' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '115320'
                WHERE ordernumber = 'P191228114211871' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212710'
                WHERE ordernumber = 'P191228114318572' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343158'
                WHERE ordernumber = 'P191228114405607' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352223'
                WHERE ordernumber = 'P191228115328687' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355915'
                WHERE ordernumber = 'P191228115630434' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '330216'
                WHERE ordernumber = 'P191228115812185' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278076'
                WHERE ordernumber = 'P181228120037690' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355918'
                WHERE ordernumber = 'P421228120538435' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355892'
                WHERE ordernumber = 'P421228120832691' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355921'
                WHERE ordernumber = 'P191228121808223' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300973'
                WHERE ordernumber = 'P201228121909881' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300973'
                WHERE ordernumber = 'P201228122018490' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355924'
                WHERE ordernumber = 'P191228122026478' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81093'
                WHERE ordernumber = 'P191228122055441' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355925'
                WHERE ordernumber = 'P421228122426858' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349243'
                WHERE ordernumber = 'P421228122525321' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355927'
                WHERE ordernumber = 'P201228122725682' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355931'
                WHERE ordernumber = 'P191228122922703' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355930'
                WHERE ordernumber = 'P201228122925594' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355932'
                WHERE ordernumber = 'P421228123017780' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '117373'
                WHERE ordernumber = 'P421228123330179' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355931'
                WHERE ordernumber = 'P191228123639977' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237400'
                WHERE ordernumber = 'P201228124000882' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301921'
                WHERE ordernumber = 'P191228124255495' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355935'
                WHERE ordernumber = 'P191228124409512' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355939'
                WHERE ordernumber = 'P191228125941290' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270893'
                WHERE ordernumber = 'P191228130124636' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346316'
                WHERE ordernumber = 'P191228130704703' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355944'
                WHERE ordernumber = 'P421228131233700' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '4'
                WHERE ordernumber = 'P191228131441231' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '65945'
                WHERE ordernumber = 'P201228132613934' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355948'
                WHERE ordernumber = 'P181228132904697' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355950'
                WHERE ordernumber = 'P191228133111115' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '260047'
                WHERE ordernumber = 'P181228133620180' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355954'
                WHERE ordernumber = 'P421228133836753' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355956'
                WHERE ordernumber = 'P181228134257358' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342876'
                WHERE ordernumber = 'P181228135325247' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355964'
                WHERE ordernumber = 'P421228140331501' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355966'
                WHERE ordernumber = 'P191228140454579' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355969'
                WHERE ordernumber = 'P201228140927884' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354775'
                WHERE ordernumber = 'P201228141144537' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288917'
                WHERE ordernumber = 'P201228141841975' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307224'
                WHERE ordernumber = 'P201228142202344' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355976'
                WHERE ordernumber = 'P201228142605854' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302167'
                WHERE ordernumber = 'P181228142824849' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129110'
                WHERE ordernumber = 'P191228142856942' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94241'
                WHERE ordernumber = 'P201228142917964' 
            
2023-12-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '89055'
                WHERE ordernumber = 'P201228143008181' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103830'
                WHERE ordernumber = 'P181228143307714' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355979'
                WHERE ordernumber = 'P421228144031785' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '87432'
                WHERE ordernumber = 'P181228144807612' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355982'
                WHERE ordernumber = 'P201228145341371' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355983'
                WHERE ordernumber = 'P421228145714114' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98155'
                WHERE ordernumber = 'P421228145926460' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355985'
                WHERE ordernumber = 'P421228150152828' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73074'
                WHERE ordernumber = 'P201228150516989' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355984'
                WHERE ordernumber = 'P181228150714358' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355991'
                WHERE ordernumber = 'P201228151728111' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252840'
                WHERE ordernumber = 'P201228151832531' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355992'
                WHERE ordernumber = 'P421228151844502' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305833'
                WHERE ordernumber = 'P181228152554533' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334505'
                WHERE ordernumber = 'P421228152717484' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355994'
                WHERE ordernumber = 'P201228153015322' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321141'
                WHERE ordernumber = 'P181228153057803' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355994'
                WHERE ordernumber = 'P201228153140663' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355995'
                WHERE ordernumber = 'P191228153602494' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249648'
                WHERE ordernumber = 'P201228153810400' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355996'
                WHERE ordernumber = 'P181228153918970' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355999'
                WHERE ordernumber = 'P181228154203490' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356000'
                WHERE ordernumber = 'P191228154359378' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356000'
                WHERE ordernumber = 'P191228154523908' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355997'
                WHERE ordernumber = 'P421228154632500' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355997'
                WHERE ordernumber = 'P421228154704194' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335123'
                WHERE ordernumber = 'P181228154745811' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354420'
                WHERE ordernumber = 'P181228154840208' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305137'
                WHERE ordernumber = 'P201228155038845' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316995'
                WHERE ordernumber = 'P181228155357188' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356005'
                WHERE ordernumber = 'P181228155744493' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356006'
                WHERE ordernumber = 'P181228155902121' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356009'
                WHERE ordernumber = 'P421228160032888' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356012'
                WHERE ordernumber = 'P201228160341220' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356013'
                WHERE ordernumber = 'P181228160413955' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356016'
                WHERE ordernumber = 'P421228160726336' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356012'
                WHERE ordernumber = 'P201228160936958' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356019'
                WHERE ordernumber = 'P181228161243699' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140097'
                WHERE ordernumber = 'P201228161331620' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325175'
                WHERE ordernumber = 'P201228161703588' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356021'
                WHERE ordernumber = 'P201228162029172' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356023'
                WHERE ordernumber = 'P181228162454853' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356024'
                WHERE ordernumber = 'P201228162659957' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356025'
                WHERE ordernumber = 'P201228162844249' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115647'
                WHERE ordernumber = 'P201228162943952' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356027'
                WHERE ordernumber = 'P191228163435650' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356027'
                WHERE ordernumber = 'P191228163525858' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356029'
                WHERE ordernumber = 'P181228163653648' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356030'
                WHERE ordernumber = 'P191228163725614' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356031'
                WHERE ordernumber = 'P181228163903490' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232447'
                WHERE ordernumber = 'P181228164045157' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356033'
                WHERE ordernumber = 'P181228164856764' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98904'
                WHERE ordernumber = 'P201228164934721' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356035'
                WHERE ordernumber = 'P181228165016951' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350899'
                WHERE ordernumber = 'P201228165150431' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356036'
                WHERE ordernumber = 'P181228165201323' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356038'
                WHERE ordernumber = 'P181228165331235' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355080'
                WHERE ordernumber = 'P201228165438622' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356042'
                WHERE ordernumber = 'P181228165454198' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356043'
                WHERE ordernumber = 'P191228165546534' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329786'
                WHERE ordernumber = 'P421228165608142' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356045'
                WHERE ordernumber = 'P421228165702184' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355853'
                WHERE ordernumber = 'P421228165821665' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163910'
                WHERE ordernumber = 'P201228165827713' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356047'
                WHERE ordernumber = 'P181228165847182' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P181228165958706' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289835'
                WHERE ordernumber = 'P181228170047645' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356048'
                WHERE ordernumber = 'P201228170449146' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356053'
                WHERE ordernumber = 'P421228171048744' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356054'
                WHERE ordernumber = 'P181228171217568' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356055'
                WHERE ordernumber = 'P421228171255337' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344736'
                WHERE ordernumber = 'P201228171309897' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100652'
                WHERE ordernumber = 'P201228171350820' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356056'
                WHERE ordernumber = 'P201228171545201' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356057'
                WHERE ordernumber = 'P191228171628805' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295562'
                WHERE ordernumber = 'P201228171830293' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277345'
                WHERE ordernumber = 'P421228171844925' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85099'
                WHERE ordernumber = 'P181228172100688' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246075'
                WHERE ordernumber = 'P181228172235160' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353989'
                WHERE ordernumber = 'P191228172236799' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118191'
                WHERE ordernumber = 'P201228172250145' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356062'
                WHERE ordernumber = 'P181228172555819' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118191'
                WHERE ordernumber = 'P201228172707266' 
            
2023-12-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159241'
                WHERE ordernumber = 'P191228172734664' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284155'
                WHERE ordernumber = 'P201228173041700' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356065'
                WHERE ordernumber = 'P201228173255741' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237655'
                WHERE ordernumber = 'P181228174023805' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356067'
                WHERE ordernumber = 'P421228174119821' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356068'
                WHERE ordernumber = 'P181228174917989' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356069'
                WHERE ordernumber = 'P421228174932867' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356070'
                WHERE ordernumber = 'P181228175056616' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99210'
                WHERE ordernumber = 'P181228175220177' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165839'
                WHERE ordernumber = 'P201228175448130' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112057'
                WHERE ordernumber = 'P191228175556832' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278680'
                WHERE ordernumber = 'P421228175722781' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356071'
                WHERE ordernumber = 'P181228175745583' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289859'
                WHERE ordernumber = 'P191228175809488' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339451'
                WHERE ordernumber = 'P421228180017310' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356072'
                WHERE ordernumber = 'P191228180203897' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161013'
                WHERE ordernumber = 'P191228180247399' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216897'
                WHERE ordernumber = 'P201228180508458' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140097'
                WHERE ordernumber = 'P201228180615359' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356074'
                WHERE ordernumber = 'P191228180615511' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106251'
                WHERE ordernumber = 'P181228180957792' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356075'
                WHERE ordernumber = 'P181228181106395' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251676'
                WHERE ordernumber = 'P181228181305364' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356076'
                WHERE ordernumber = 'P181228181413254' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287227'
                WHERE ordernumber = 'P181228181614400' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249234'
                WHERE ordernumber = 'P201228181618280' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287227'
                WHERE ordernumber = 'P181228181637444' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159756'
                WHERE ordernumber = 'P181228181737194' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356077'
                WHERE ordernumber = 'P181228181839548' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319987'
                WHERE ordernumber = 'P181228182010693' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291410'
                WHERE ordernumber = 'P201228182137894' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356080'
                WHERE ordernumber = 'P181228182233664' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356082'
                WHERE ordernumber = 'P181228182427188' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112919'
                WHERE ordernumber = 'P421228182505934' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P201228182648380' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254652'
                WHERE ordernumber = 'P191228182915998' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356083'
                WHERE ordernumber = 'P201228182949159' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356085'
                WHERE ordernumber = 'P201228183321854' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90263'
                WHERE ordernumber = 'P201228183439555' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356081'
                WHERE ordernumber = 'P181228183918725' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356081'
                WHERE ordernumber = 'P181228183939589' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266066'
                WHERE ordernumber = 'P181228184050894' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356087'
                WHERE ordernumber = 'P201228184107942' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339639'
                WHERE ordernumber = 'P181228184141929' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136008'
                WHERE ordernumber = 'P201228184205390' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '144711'
                WHERE ordernumber = 'P421228184244481' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299342'
                WHERE ordernumber = 'P421228184410824' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356088'
                WHERE ordernumber = 'P181228184440542' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356089'
                WHERE ordernumber = 'P191228184644315' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356091'
                WHERE ordernumber = 'P191228184834912' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342473'
                WHERE ordernumber = 'P201228184857794' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132801'
                WHERE ordernumber = 'P201228184945346' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356092'
                WHERE ordernumber = 'P191228184945971' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356089'
                WHERE ordernumber = 'P191228185012914' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356093'
                WHERE ordernumber = 'P191228185234134' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356089'
                WHERE ordernumber = 'P191228185304937' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356089'
                WHERE ordernumber = 'P191228185612259' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353795'
                WHERE ordernumber = 'P191228190110617' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243812'
                WHERE ordernumber = 'P191228190859723' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356098'
                WHERE ordernumber = 'P201228191302933' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352541'
                WHERE ordernumber = 'P191228191746501' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356100'
                WHERE ordernumber = 'P201228191816905' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164969'
                WHERE ordernumber = 'P191228192046332' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227773'
                WHERE ordernumber = 'P201228192149323' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287269'
                WHERE ordernumber = 'P191228192332631' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284627'
                WHERE ordernumber = 'P191228192503788' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238940'
                WHERE ordernumber = 'P191228192543509' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356106'
                WHERE ordernumber = 'P191228193201921' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356107'
                WHERE ordernumber = 'P421228193451209' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296316'
                WHERE ordernumber = 'P421228193825812' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355766'
                WHERE ordernumber = 'P201228193843407' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356109'
                WHERE ordernumber = 'P421228194102410' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353959'
                WHERE ordernumber = 'P191228194346261' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313696'
                WHERE ordernumber = 'P191228194428630' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103190'
                WHERE ordernumber = 'P191228194527731' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273232'
                WHERE ordernumber = 'P201228194531904' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347847'
                WHERE ordernumber = 'P421228194904209' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356112'
                WHERE ordernumber = 'P201228195034160' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270841'
                WHERE ordernumber = 'P201228195602710' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P201228195813286' 
            
2023-12-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356116'
                WHERE ordernumber = 'P201228200050443'