2024-09-05 01:00:02 -- 將會員中心id寫入data-lake
2024-09-05 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-09-04%';
        
2024-09-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418745'
                WHERE ordernumber = 'P420904110211587' 
            
2024-09-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '161874'
                WHERE ordernumber = 'P180904110253199' 
            
2024-09-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130187'
                WHERE ordernumber = 'P200904110343807' 
            
2024-09-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418742'
                WHERE ordernumber = 'P180904110425409' 
            
2024-09-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '78196'
                WHERE ordernumber = 'P200904110456664' 
            
2024-09-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279353'
                WHERE ordernumber = 'P190904110601968' 
            
2024-09-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243925'
                WHERE ordernumber = 'P180904110811836' 
            
2024-09-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418753'
                WHERE ordernumber = 'P420904111255394' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391928'
                WHERE ordernumber = 'P190904111329335' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '78196'
                WHERE ordernumber = 'P200904111500807' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418296'
                WHERE ordernumber = 'P200904111656759' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418756'
                WHERE ordernumber = 'P200904111826358' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286520'
                WHERE ordernumber = 'P180904111838406' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402080'
                WHERE ordernumber = 'P420904111845884' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301162'
                WHERE ordernumber = 'P200904111920565' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271216'
                WHERE ordernumber = 'P180904112259693' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414244'
                WHERE ordernumber = 'P200904112508587' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397129'
                WHERE ordernumber = 'P420904112658430' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80905'
                WHERE ordernumber = 'P180904112811837' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390142'
                WHERE ordernumber = 'P420904112909578' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350979'
                WHERE ordernumber = 'P200904113147338' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418764'
                WHERE ordernumber = 'P420904113609614' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418765'
                WHERE ordernumber = 'P200904113637741' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367501'
                WHERE ordernumber = 'P180904113755154' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339295'
                WHERE ordernumber = 'P190904113801294' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418766'
                WHERE ordernumber = 'P420904113812874' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414696'
                WHERE ordernumber = 'P190904113941459' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180904113950155' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418770'
                WHERE ordernumber = 'P420904113958748' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418773'
                WHERE ordernumber = 'P420904114115427' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418778'
                WHERE ordernumber = 'P420904114318441' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417616'
                WHERE ordernumber = 'P180904114337489' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374957'
                WHERE ordernumber = 'P420904114403279' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172874'
                WHERE ordernumber = 'P180904114445643' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383919'
                WHERE ordernumber = 'P420904114445257' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418772'
                WHERE ordernumber = 'P190904114630373' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418768'
                WHERE ordernumber = 'P200904114726391' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96152'
                WHERE ordernumber = 'P200904115709153' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418789'
                WHERE ordernumber = 'P420904120002584' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418789'
                WHERE ordernumber = 'P420904120137529' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418788'
                WHERE ordernumber = 'P200904120150791' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283209'
                WHERE ordernumber = 'P180904120428673' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '57214'
                WHERE ordernumber = 'P420904120826686' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332953'
                WHERE ordernumber = 'P420904120935631' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319375'
                WHERE ordernumber = 'P180904121100882' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418795'
                WHERE ordernumber = 'P420904121214713' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '57214'
                WHERE ordernumber = 'P420904121310890' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418789'
                WHERE ordernumber = 'P420904121435623' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418799'
                WHERE ordernumber = 'P420904121649379' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107950'
                WHERE ordernumber = 'P180904121918589' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418800'
                WHERE ordernumber = 'P420904121930496' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418799'
                WHERE ordernumber = 'P420904122156651' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '69907'
                WHERE ordernumber = 'P190904122758334' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190904122913678' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397934'
                WHERE ordernumber = 'P420904123123485' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97778'
                WHERE ordernumber = 'P180904123201432' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418812'
                WHERE ordernumber = 'P200904123205830' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158496'
                WHERE ordernumber = 'P420904123211156' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366335'
                WHERE ordernumber = 'P420904123453788' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404707'
                WHERE ordernumber = 'P180904123537334' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296801'
                WHERE ordernumber = 'P420904123559504' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418817'
                WHERE ordernumber = 'P200904124005634' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346553'
                WHERE ordernumber = 'P180904124007850' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327899'
                WHERE ordernumber = 'P180904124145884' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387808'
                WHERE ordernumber = 'P420904124213865' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327899'
                WHERE ordernumber = 'P180904124302793' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411207'
                WHERE ordernumber = 'P200904124434445' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343559'
                WHERE ordernumber = 'P180904124441301' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418821'
                WHERE ordernumber = 'P420904124623891' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418825'
                WHERE ordernumber = 'P420904125042915' 
            
2024-09-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418827'
                WHERE ordernumber = 'P420904125709538' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214193'
                WHERE ordernumber = 'P180904125846142' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418831'
                WHERE ordernumber = 'P420904130208311' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418799'
                WHERE ordernumber = 'P420904130414282' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '30133'
                WHERE ordernumber = 'P420904130548680' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167719'
                WHERE ordernumber = 'P200904130655585' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418833'
                WHERE ordernumber = 'P420904130703252' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270888'
                WHERE ordernumber = 'P420904130851875' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418836'
                WHERE ordernumber = 'P420904131013740' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167173'
                WHERE ordernumber = 'P200904131323133' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305345'
                WHERE ordernumber = 'P200904131420659' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418839'
                WHERE ordernumber = 'P420904132045574' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418840'
                WHERE ordernumber = 'P200904132336880' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418840'
                WHERE ordernumber = 'P200904132613475' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414356'
                WHERE ordernumber = 'P420904132637250' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318891'
                WHERE ordernumber = 'P200904133049926' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385059'
                WHERE ordernumber = 'P180904133348273' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388632'
                WHERE ordernumber = 'P200904133446377' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418849'
                WHERE ordernumber = 'P420904134132377' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292306'
                WHERE ordernumber = 'P200904134134272' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369762'
                WHERE ordernumber = 'P420904134227609' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224520'
                WHERE ordernumber = 'P180904134356746' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326714'
                WHERE ordernumber = 'P180904134622547' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234329'
                WHERE ordernumber = 'P180904134937614' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418853'
                WHERE ordernumber = 'P420904135253570' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286589'
                WHERE ordernumber = 'P420904140012226' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418861'
                WHERE ordernumber = 'P200904140156715' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338048'
                WHERE ordernumber = 'P190904140234864' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135897'
                WHERE ordernumber = 'P180904140501957' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109585'
                WHERE ordernumber = 'P190904140623253' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417586'
                WHERE ordernumber = 'P420904140915512' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408308'
                WHERE ordernumber = 'P180904141233877' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418867'
                WHERE ordernumber = 'P420904141252382' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371741'
                WHERE ordernumber = 'P180904141611288' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227610'
                WHERE ordernumber = 'P180904142036515' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385851'
                WHERE ordernumber = 'P200904142315872' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378186'
                WHERE ordernumber = 'P180904142346340' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173536'
                WHERE ordernumber = 'P420904142527357' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373451'
                WHERE ordernumber = 'P420904142552259' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418876'
                WHERE ordernumber = 'P420904143107437' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404419'
                WHERE ordernumber = 'P190904143340876' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386302'
                WHERE ordernumber = 'P180904143438469' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418878'
                WHERE ordernumber = 'P200904143445361' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418879'
                WHERE ordernumber = 'P200904143629377' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418880'
                WHERE ordernumber = 'P420904143714233' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394501'
                WHERE ordernumber = 'P420904143919298' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232174'
                WHERE ordernumber = 'P180904144104788' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418884'
                WHERE ordernumber = 'P420904144226114' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408917'
                WHERE ordernumber = 'P200904144355201' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238454'
                WHERE ordernumber = 'P200904144519284' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395607'
                WHERE ordernumber = 'P200904144627152' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418891'
                WHERE ordernumber = 'P180904145121279' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378646'
                WHERE ordernumber = 'P200904145452465' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418886'
                WHERE ordernumber = 'P180904145535620' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362212'
                WHERE ordernumber = 'P200904145725661' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418895'
                WHERE ordernumber = 'P420904150009520' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418896'
                WHERE ordernumber = 'P200904150014404' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128709'
                WHERE ordernumber = 'P420904150351444' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418897'
                WHERE ordernumber = 'P420904150526274' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '69376'
                WHERE ordernumber = 'P180904150612174' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418898'
                WHERE ordernumber = 'P420904150626989' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418902'
                WHERE ordernumber = 'P420904150827413' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418903'
                WHERE ordernumber = 'P420904151223751' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418908'
                WHERE ordernumber = 'P420904151409780' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255531'
                WHERE ordernumber = 'P200904151424175' 
            
2024-09-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265949'
                WHERE ordernumber = 'P200904151724186' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378213'
                WHERE ordernumber = 'P200904151828378' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388632'
                WHERE ordernumber = 'P200904151926912' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283997'
                WHERE ordernumber = 'P420904151952620' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418913'
                WHERE ordernumber = 'P420904152235932' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312743'
                WHERE ordernumber = 'P420904152517293' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418921'
                WHERE ordernumber = 'P200904153122865' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418924'
                WHERE ordernumber = 'P420904153229773' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418925'
                WHERE ordernumber = 'P190904153313954' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396908'
                WHERE ordernumber = 'P630904153412807' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418927'
                WHERE ordernumber = 'P200904153620991' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418929'
                WHERE ordernumber = 'P420904154013933' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418910'
                WHERE ordernumber = 'P200904154334564' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418932'
                WHERE ordernumber = 'P420904154513357' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418935'
                WHERE ordernumber = 'P420904154901373' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280466'
                WHERE ordernumber = 'P200904155250821' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415631'
                WHERE ordernumber = 'P420904155443501' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415631'
                WHERE ordernumber = 'P420904155844456' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418950'
                WHERE ordernumber = 'P200904160925541' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302736'
                WHERE ordernumber = 'P420904161239142' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397135'
                WHERE ordernumber = 'P200904161440437' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '27858'
                WHERE ordernumber = 'P200904161854381' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395285'
                WHERE ordernumber = 'P180904161859184' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '27858'
                WHERE ordernumber = 'P200904161907115' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280910'
                WHERE ordernumber = 'P200904162254691' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '294534'
                WHERE ordernumber = 'P200904162547149' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418958'
                WHERE ordernumber = 'P420904162644443' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418960'
                WHERE ordernumber = 'P420904162823652' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418962'
                WHERE ordernumber = 'P420904163047698' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418963'
                WHERE ordernumber = 'P420904163414639' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418926'
                WHERE ordernumber = 'P180904163927623' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418926'
                WHERE ordernumber = 'P180904163957150' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '269257'
                WHERE ordernumber = 'P200904164108947' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329880'
                WHERE ordernumber = 'P200904164319422' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416805'
                WHERE ordernumber = 'P180904164752306' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418971'
                WHERE ordernumber = 'P180904164859168' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '157035'
                WHERE ordernumber = 'P200904164936251' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418976'
                WHERE ordernumber = 'P420904165208209' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217480'
                WHERE ordernumber = 'P180904165323943' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402220'
                WHERE ordernumber = 'P420904165727691' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418981'
                WHERE ordernumber = 'P420904165906844' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372376'
                WHERE ordernumber = 'P420904170734142' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348622'
                WHERE ordernumber = 'P180904171348521' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418990'
                WHERE ordernumber = 'P420904171715788' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418992'
                WHERE ordernumber = 'P200904172025284' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97453'
                WHERE ordernumber = 'P200904172159721' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '125914'
                WHERE ordernumber = 'P180904172231814' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399717'
                WHERE ordernumber = 'P420904172254321' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P200904172321292' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '271852'
                WHERE ordernumber = 'P200904172437578' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418994'
                WHERE ordernumber = 'P200904172717161' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222161'
                WHERE ordernumber = 'P200904172816251' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '207380'
                WHERE ordernumber = 'P180904173021700' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418997'
                WHERE ordernumber = 'P420904173133836' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418998'
                WHERE ordernumber = 'P420904173240726' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '157398'
                WHERE ordernumber = 'P180904173340541' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390443'
                WHERE ordernumber = 'P180904173505740' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412893'
                WHERE ordernumber = 'P420904173525826' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319517'
                WHERE ordernumber = 'P420904173629320' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '335741'
                WHERE ordernumber = 'P420904173715569' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419003'
                WHERE ordernumber = 'P420904173905821' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388995'
                WHERE ordernumber = 'P180904173946482' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '331317'
                WHERE ordernumber = 'P420904174032225' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '80921'
                WHERE ordernumber = 'P200904174255530' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417316'
                WHERE ordernumber = 'P420904174526227' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415679'
                WHERE ordernumber = 'P420904174816525' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415679'
                WHERE ordernumber = 'P420904174948954' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419009'
                WHERE ordernumber = 'P200904175417411' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180904175459206' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113383'
                WHERE ordernumber = 'P180904175708482' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343257'
                WHERE ordernumber = 'P180904175833372' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343257'
                WHERE ordernumber = 'P180904175902822' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414693'
                WHERE ordernumber = 'P420904180259283' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386444'
                WHERE ordernumber = 'P200904180311895' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415160'
                WHERE ordernumber = 'P420904180503245' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400172'
                WHERE ordernumber = 'P590904180515834' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419013'
                WHERE ordernumber = 'P200904180659308' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419014'
                WHERE ordernumber = 'P200904180840375' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418586'
                WHERE ordernumber = 'P200904181039626' 
            
2024-09-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419016'
                WHERE ordernumber = 'P420904181056515' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419017'
                WHERE ordernumber = 'P180904181107424' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '282775'
                WHERE ordernumber = 'P200904181112739' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '392009'
                WHERE ordernumber = 'P180904181151560' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '167865'
                WHERE ordernumber = 'P420904181204637' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419014'
                WHERE ordernumber = 'P200904181224350' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '242381'
                WHERE ordernumber = 'P420904181245872' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419018'
                WHERE ordernumber = 'P180904181300898' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '91679'
                WHERE ordernumber = 'P200904181309378' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '407594'
                WHERE ordernumber = 'P200904181415190' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419021'
                WHERE ordernumber = 'P420904181524804' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419022'
                WHERE ordernumber = 'P200904181528442' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419024'
                WHERE ordernumber = 'P200904182027827' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419026'
                WHERE ordernumber = 'P420904182116323' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '260853'
                WHERE ordernumber = 'P180904182136933' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350864'
                WHERE ordernumber = 'P180904182219330' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '336420'
                WHERE ordernumber = 'P180904182400544' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419029'
                WHERE ordernumber = 'P420904182444816' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419030'
                WHERE ordernumber = 'P200904182544936' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419031'
                WHERE ordernumber = 'P420904182628907' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '417276'
                WHERE ordernumber = 'P180904182705686' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '283600'
                WHERE ordernumber = 'P180904182829159' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405596'
                WHERE ordernumber = 'P420904182847221' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '262676'
                WHERE ordernumber = 'P200904182852488' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419032'
                WHERE ordernumber = 'P420904182930650' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '151394'
                WHERE ordernumber = 'P180904183001134' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419033'
                WHERE ordernumber = 'P420904183045979' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '410540'
                WHERE ordernumber = 'P180904183120729' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '407491'
                WHERE ordernumber = 'P180904183259367' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403382'
                WHERE ordernumber = 'P180904183603747' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '241827'
                WHERE ordernumber = 'P200904183604920' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '394091'
                WHERE ordernumber = 'P420904183648116' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419038'
                WHERE ordernumber = 'P200904183729533' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '400798'
                WHERE ordernumber = 'P200904184243688' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '227175'
                WHERE ordernumber = 'P180904184312433' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419044'
                WHERE ordernumber = 'P420904184553444' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419043'
                WHERE ordernumber = 'P200904184602377' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '412772'
                WHERE ordernumber = 'P420904184832653' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '375217'
                WHERE ordernumber = 'P180904184843859' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '219522'
                WHERE ordernumber = 'P180904184953895' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '413628'
                WHERE ordernumber = 'P630904185026194' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419047'
                WHERE ordernumber = 'P420904185153838' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419048'
                WHERE ordernumber = 'P180904185158436' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419049'
                WHERE ordernumber = 'P200904185229322' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419050'
                WHERE ordernumber = 'P200904185441931' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386955'
                WHERE ordernumber = 'P200904185552152' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '244459'
                WHERE ordernumber = 'P200904185649316' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419055'
                WHERE ordernumber = 'P420904190140807' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419057'
                WHERE ordernumber = 'P200904190159612' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419051'
                WHERE ordernumber = 'P200904190317365' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '413662'
                WHERE ordernumber = 'P180904190855126' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '269642'
                WHERE ordernumber = 'P200904190937315' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '292259'
                WHERE ordernumber = 'P200904191209747' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '234780'
                WHERE ordernumber = 'P200904191251633' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '135946'
                WHERE ordernumber = 'P180904191433310' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '98115'
                WHERE ordernumber = 'P180904191945841' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '232676'
                WHERE ordernumber = 'P200904192052970' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '415478'
                WHERE ordernumber = 'P190904193205650' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '262762'
                WHERE ordernumber = 'P180904193532923' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419068'
                WHERE ordernumber = 'P180904193720835' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '412772'
                WHERE ordernumber = 'P200904193729519' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '393998'
                WHERE ordernumber = 'P200904194125274' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '17484'
                WHERE ordernumber = 'P200904194457985' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '413753'
                WHERE ordernumber = 'P180904194504364' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '419076'
                WHERE ordernumber = 'P200904194858824' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P200904195220928' 
            
2024-09-05 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P590904200902380'