2024-05-22 01:00:01 -- 將會員中心id寫入data-lake
2024-05-22 01:00:01 -- 
            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-05-21%';
        
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '384207'
                WHERE ordernumber = 'P630521105038727' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '270921'
                WHERE ordernumber = 'P200521110043219' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '391082'
                WHERE ordernumber = 'P200521110311446' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '279047'
                WHERE ordernumber = 'P190521110423825' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '126295'
                WHERE ordernumber = 'P190521110745770' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '349708'
                WHERE ordernumber = 'P200521111103598' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '279047'
                WHERE ordernumber = 'P180521111835115' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '315580'
                WHERE ordernumber = 'P180521112245977' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '389268'
                WHERE ordernumber = 'P190521112246975' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '391087'
                WHERE ordernumber = 'P190521112523342' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '391088'
                WHERE ordernumber = 'P630521112718752' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '386982'
                WHERE ordernumber = 'P420521112832816' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '391090'
                WHERE ordernumber = 'P180521113120685' 
            
2024-05-22 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '391091'
                WHERE ordernumber = 'P200521113442586' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278310'
                WHERE ordernumber = 'P200521114417497' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390324'
                WHERE ordernumber = 'P180521114746900' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390324'
                WHERE ordernumber = 'P180521114829164' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390324'
                WHERE ordernumber = 'P180521114921545' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390324'
                WHERE ordernumber = 'P180521115142314' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P190521115414306' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391092'
                WHERE ordernumber = 'P710521120006618' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391094'
                WHERE ordernumber = 'P180521120124310' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391096'
                WHERE ordernumber = 'P180521120521723' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180521121245240' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329060'
                WHERE ordernumber = 'P180521121648596' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391100'
                WHERE ordernumber = 'P790521123539411' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304427'
                WHERE ordernumber = 'P710521123636174' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391102'
                WHERE ordernumber = 'P200521123705452' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391105'
                WHERE ordernumber = 'P180521123831783' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391107'
                WHERE ordernumber = 'P180521124006679' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '227957'
                WHERE ordernumber = 'P180521124102997' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391061'
                WHERE ordernumber = 'P180521124235837' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391109'
                WHERE ordernumber = 'P420521124331652' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391110'
                WHERE ordernumber = 'P180521124332667' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391108'
                WHERE ordernumber = 'P790521124457197' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391111'
                WHERE ordernumber = 'P180521124523698' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391112'
                WHERE ordernumber = 'P200521124623911' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391113'
                WHERE ordernumber = 'P420521124640453' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389260'
                WHERE ordernumber = 'P200521125013878' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391117'
                WHERE ordernumber = 'P180521125908547' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391118'
                WHERE ordernumber = 'P180521130154799' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391120'
                WHERE ordernumber = 'P790521130644602' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391122'
                WHERE ordernumber = 'P180521130933900' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391121'
                WHERE ordernumber = 'P790521130944337' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '108272'
                WHERE ordernumber = 'P180521131223523' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391123'
                WHERE ordernumber = 'P420521131258972' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391124'
                WHERE ordernumber = 'P790521131536709' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214777'
                WHERE ordernumber = 'P200521131706752' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214777'
                WHERE ordernumber = 'P200521131715964' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391126'
                WHERE ordernumber = 'P180521131728304' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391127'
                WHERE ordernumber = 'P420521131734124' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391128'
                WHERE ordernumber = 'P180521131910496' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391125'
                WHERE ordernumber = 'P710521132205896' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391129'
                WHERE ordernumber = 'P180521132327245' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390655'
                WHERE ordernumber = 'P200521132543352' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278056'
                WHERE ordernumber = 'P180521133345729' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391132'
                WHERE ordernumber = 'P200521133614142' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391133'
                WHERE ordernumber = 'P180521133852600' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391136'
                WHERE ordernumber = 'P200521134043906' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391135'
                WHERE ordernumber = 'P790521134146675' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344213'
                WHERE ordernumber = 'P200521134407119' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391137'
                WHERE ordernumber = 'P790521134702404' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391139'
                WHERE ordernumber = 'P180521135354216' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391140'
                WHERE ordernumber = 'P200521135412863' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390983'
                WHERE ordernumber = 'P200521135515896' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391141'
                WHERE ordernumber = 'P180521135831197' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253344'
                WHERE ordernumber = 'P200521140743132' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305713'
                WHERE ordernumber = 'P200521141232210' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391142'
                WHERE ordernumber = 'P180521141537278' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391143'
                WHERE ordernumber = 'P420521141541217' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180521141854435' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276337'
                WHERE ordernumber = 'P200521142335652' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391144'
                WHERE ordernumber = 'P790521142411769' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377987'
                WHERE ordernumber = 'P420521142814428' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99468'
                WHERE ordernumber = 'P200521142820261' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391145'
                WHERE ordernumber = 'P200521142938357' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391146'
                WHERE ordernumber = 'P180521142948192' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391147'
                WHERE ordernumber = 'P420521143006194' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391146'
                WHERE ordernumber = 'P180521143035456' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391150'
                WHERE ordernumber = 'P200521143248685' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391149'
                WHERE ordernumber = 'P420521143256176' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390438'
                WHERE ordernumber = 'P180521143308307' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391152'
                WHERE ordernumber = 'P200521143417134' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387117'
                WHERE ordernumber = 'P180521144203193' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391156'
                WHERE ordernumber = 'P200521144353786' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391157'
                WHERE ordernumber = 'P420521144422401' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379300'
                WHERE ordernumber = 'P420521145821411' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99850'
                WHERE ordernumber = 'P180521145831204' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329277'
                WHERE ordernumber = 'P200521145957541' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391159'
                WHERE ordernumber = 'P180521151230311' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391161'
                WHERE ordernumber = 'P180521151821534' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374079'
                WHERE ordernumber = 'P180521152422659' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389875'
                WHERE ordernumber = 'P630521152847747' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95192'
                WHERE ordernumber = 'P180521153156758' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378756'
                WHERE ordernumber = 'P200521153350609' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219516'
                WHERE ordernumber = 'P180521153600128' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219516'
                WHERE ordernumber = 'P180521153648362' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391163'
                WHERE ordernumber = 'P190521153711542' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391164'
                WHERE ordernumber = 'P180521153925380' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219516'
                WHERE ordernumber = 'P180521154034556' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238188'
                WHERE ordernumber = 'P200521154419504' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133989'
                WHERE ordernumber = 'P790521154539920' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '215938'
                WHERE ordernumber = 'P180521154613786' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391166'
                WHERE ordernumber = 'P420521154932178' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391167'
                WHERE ordernumber = 'P180521155119764' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391168'
                WHERE ordernumber = 'P180521155420586' 
            
2024-05-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391170'
                WHERE ordernumber = 'P180521155702364' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391171'
                WHERE ordernumber = 'P790521160428143' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390980'
                WHERE ordernumber = 'P420521160901643' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391173'
                WHERE ordernumber = 'P180521161332290' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391174'
                WHERE ordernumber = 'P180521161553992' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391175'
                WHERE ordernumber = 'P180521161915646' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391176'
                WHERE ordernumber = 'P200521161944151' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391177'
                WHERE ordernumber = 'P790521162427766' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391178'
                WHERE ordernumber = 'P420521162534117' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391179'
                WHERE ordernumber = 'P180521162840816' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '203578'
                WHERE ordernumber = 'P180521163222370' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94051'
                WHERE ordernumber = 'P710521163412538' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391180'
                WHERE ordernumber = 'P710521163644246' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391181'
                WHERE ordernumber = 'P630521163654373' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302546'
                WHERE ordernumber = 'P180521163817953' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391182'
                WHERE ordernumber = 'P190521163944609' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297160'
                WHERE ordernumber = 'P420521165130236' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242404'
                WHERE ordernumber = 'P180521165218982' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365269'
                WHERE ordernumber = 'P420521165256399' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161171'
                WHERE ordernumber = 'P180521165459413' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389183'
                WHERE ordernumber = 'P200521165843208' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389183'
                WHERE ordernumber = 'P200521165924660' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335815'
                WHERE ordernumber = 'P630521165951833' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P790521170640964' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391185'
                WHERE ordernumber = 'P180521170935116' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340663'
                WHERE ordernumber = 'P200521171822190' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385825'
                WHERE ordernumber = 'P180521171845229' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81018'
                WHERE ordernumber = 'P180521171934325' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387043'
                WHERE ordernumber = 'P630521172035634' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391187'
                WHERE ordernumber = 'P790521172145679' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391190'
                WHERE ordernumber = 'P790521172931891' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391054'
                WHERE ordernumber = 'P180521173257889' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275780'
                WHERE ordernumber = 'P180521173531940' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391193'
                WHERE ordernumber = 'P200521173532252' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391194'
                WHERE ordernumber = 'P180521173733595' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141694'
                WHERE ordernumber = 'P180521173824589' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386969'
                WHERE ordernumber = 'P190521174718719' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386969'
                WHERE ordernumber = 'P190521174832538' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391192'
                WHERE ordernumber = 'P180521174904614' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391192'
                WHERE ordernumber = 'P180521174926311' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391192'
                WHERE ordernumber = 'P180521175005675' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110525'
                WHERE ordernumber = 'P180521175148834' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386969'
                WHERE ordernumber = 'P190521175724378' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391198'
                WHERE ordernumber = 'P790521175829455' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273020'
                WHERE ordernumber = 'P180521175901504' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388470'
                WHERE ordernumber = 'P200521180051835' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301294'
                WHERE ordernumber = 'P180521180329135' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391200'
                WHERE ordernumber = 'P790521180607416' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391201'
                WHERE ordernumber = 'P790521180700150' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391199'
                WHERE ordernumber = 'P790521180746986' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391202'
                WHERE ordernumber = 'P790521180834818' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81972'
                WHERE ordernumber = 'P200521180838798' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279244'
                WHERE ordernumber = 'P180521181042765' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391204'
                WHERE ordernumber = 'P790521181043740' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P180521181516747' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P420521181842857' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384749'
                WHERE ordernumber = 'P180521182141932' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391206'
                WHERE ordernumber = 'P710521182836769' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391207'
                WHERE ordernumber = 'P200521183018967' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391208'
                WHERE ordernumber = 'P420521183453628' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278468'
                WHERE ordernumber = 'P180521183501514' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391210'
                WHERE ordernumber = 'P710521184208201' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114174'
                WHERE ordernumber = 'P180521184233347' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391212'
                WHERE ordernumber = 'P710521184501291' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317600'
                WHERE ordernumber = 'P190521184716404' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294985'
                WHERE ordernumber = 'P190521184917313' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391214'
                WHERE ordernumber = 'P190521185045891' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391215'
                WHERE ordernumber = 'P190521185300708' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389273'
                WHERE ordernumber = 'P190521190718813' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242137'
                WHERE ordernumber = 'P200521190720961' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281945'
                WHERE ordernumber = 'P200521191303484' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391040'
                WHERE ordernumber = 'P190521192439866' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380263'
                WHERE ordernumber = 'P420521192912139' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391218'
                WHERE ordernumber = 'P190521193159144' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384329'
                WHERE ordernumber = 'P190521193445363' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391219'
                WHERE ordernumber = 'P420521193448930' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391222'
                WHERE ordernumber = 'P790521195753888' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391226'
                WHERE ordernumber = 'P790521202455878' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391231'
                WHERE ordernumber = 'P710521210030695' 
            
2024-05-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172521'
                WHERE ordernumber = 'P710521213914688'