2024-03-14 01:00:02 -- 將會員中心id寫入data-lake
2024-03-14 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-03-13%';
        
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381277'
                WHERE ordernumber = 'P590313105851957' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380305'
                WHERE ordernumber = 'P180313110116576' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381278'
                WHERE ordernumber = 'P200313110249613' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200313110619538' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '158535'
                WHERE ordernumber = 'P200313110710817' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200313111541354' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381280'
                WHERE ordernumber = 'P420313112356179' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381281'
                WHERE ordernumber = 'P200313112931904' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381282'
                WHERE ordernumber = 'P420313112943243' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314983'
                WHERE ordernumber = 'P180313113211294' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381284'
                WHERE ordernumber = 'P420313114456569' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '51830'
                WHERE ordernumber = 'P200313114633661' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381285'
                WHERE ordernumber = 'P180313115132725' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281945'
                WHERE ordernumber = 'P200313115529821' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381286'
                WHERE ordernumber = 'P420313115538834' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381287'
                WHERE ordernumber = 'P180313120015760' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381288'
                WHERE ordernumber = 'P590313120137152' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381290'
                WHERE ordernumber = 'P180313120153306' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381267'
                WHERE ordernumber = 'P420313120346540' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381291'
                WHERE ordernumber = 'P590313120459764' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237223'
                WHERE ordernumber = 'P180313120941346' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381292'
                WHERE ordernumber = 'P180313121306741' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '140626'
                WHERE ordernumber = 'P420313121556532' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296561'
                WHERE ordernumber = 'P590313121634760' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381293'
                WHERE ordernumber = 'P180313121635861' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355925'
                WHERE ordernumber = 'P420313122015841' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381294'
                WHERE ordernumber = 'P420313122050210' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381295'
                WHERE ordernumber = 'P200313122248288' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381296'
                WHERE ordernumber = 'P180313122523502' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381297'
                WHERE ordernumber = 'P200313122714937' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381298'
                WHERE ordernumber = 'P420313122728538' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381299'
                WHERE ordernumber = 'P180313123000380' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336385'
                WHERE ordernumber = 'P420313123220762' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381300'
                WHERE ordernumber = 'P200313123346488' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381301'
                WHERE ordernumber = 'P420313123457116' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339659'
                WHERE ordernumber = 'P200313123619455' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358974'
                WHERE ordernumber = 'P180313125151579' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381303'
                WHERE ordernumber = 'P420313125312291' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381304'
                WHERE ordernumber = 'P180313125330764' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180313125416528' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381305'
                WHERE ordernumber = 'P420313125447309' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248504'
                WHERE ordernumber = 'P180313125557337' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378959'
                WHERE ordernumber = 'P180313125705358' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381302'
                WHERE ordernumber = 'P590313125807718' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301943'
                WHERE ordernumber = 'P200313125913212' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381308'
                WHERE ordernumber = 'P180313130858446' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381308'
                WHERE ordernumber = 'P180313130940117' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301441'
                WHERE ordernumber = 'P420313131149748' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381311'
                WHERE ordernumber = 'P190313131149896' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381309'
                WHERE ordernumber = 'P590313131410970' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381313'
                WHERE ordernumber = 'P420313131429810' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180313134235499' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381315'
                WHERE ordernumber = 'P420313134551690' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P180313134752390' 
            
2024-03-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381316'
                WHERE ordernumber = 'P180313135628657' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336197'
                WHERE ordernumber = 'P180313135805952' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381317'
                WHERE ordernumber = 'P200313135859382' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381318'
                WHERE ordernumber = 'P180313140018191' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259784'
                WHERE ordernumber = 'P200313140508469' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381319'
                WHERE ordernumber = 'P180313140711221' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381320'
                WHERE ordernumber = 'P200313140711618' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92069'
                WHERE ordernumber = 'P180313140850714' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211573'
                WHERE ordernumber = 'P190313141035814' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381322'
                WHERE ordernumber = 'P420313141300219' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92069'
                WHERE ordernumber = 'P180313141350220' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214492'
                WHERE ordernumber = 'P190313141445685' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381323'
                WHERE ordernumber = 'P420313141445150' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P190313141514916' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315036'
                WHERE ordernumber = 'P180313141901834' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315036'
                WHERE ordernumber = 'P180313142010774' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381324'
                WHERE ordernumber = 'P420313142010432' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286467'
                WHERE ordernumber = 'P200313142119262' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365768'
                WHERE ordernumber = 'P420313142237458' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381326'
                WHERE ordernumber = 'P420313142406497' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299463'
                WHERE ordernumber = 'P420313142726971' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164144'
                WHERE ordernumber = 'P180313143126189' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159563'
                WHERE ordernumber = 'P180313143246708' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381328'
                WHERE ordernumber = 'P420313143354344' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250375'
                WHERE ordernumber = 'P180313143702716' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '192556'
                WHERE ordernumber = 'P190313143818666' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285580'
                WHERE ordernumber = 'P180313143847943' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381329'
                WHERE ordernumber = 'P420313144744677' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381330'
                WHERE ordernumber = 'P190313145202645' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94987'
                WHERE ordernumber = 'P180313145244830' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81908'
                WHERE ordernumber = 'P180313145445642' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381331'
                WHERE ordernumber = 'P180313145720406' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381332'
                WHERE ordernumber = 'P190313145728396' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381333'
                WHERE ordernumber = 'P420313150006733' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268147'
                WHERE ordernumber = 'P200313150157804' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374267'
                WHERE ordernumber = 'P420313150258387' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381334'
                WHERE ordernumber = 'P590313150354967' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381335'
                WHERE ordernumber = 'P180313150711744' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350166'
                WHERE ordernumber = 'P420313151146996' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347884'
                WHERE ordernumber = 'P590313151405450' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365102'
                WHERE ordernumber = 'P200313151418522' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380939'
                WHERE ordernumber = 'P180313151431550' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159612'
                WHERE ordernumber = 'P180313151620167' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381336'
                WHERE ordernumber = 'P180313152113113' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316905'
                WHERE ordernumber = 'P180313152357318' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381337'
                WHERE ordernumber = 'P590313152540469' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200313152737433' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381343'
                WHERE ordernumber = 'P200313153249278' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381344'
                WHERE ordernumber = 'P180313153253728' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381340'
                WHERE ordernumber = 'P420313153319755' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381345'
                WHERE ordernumber = 'P180313153424239' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381346'
                WHERE ordernumber = 'P190313153544915' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381347'
                WHERE ordernumber = 'P180313153652627' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381348'
                WHERE ordernumber = 'P420313153843841' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381337'
                WHERE ordernumber = 'P590313153924306' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314987'
                WHERE ordernumber = 'P180313154015271' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372849'
                WHERE ordernumber = 'P590313154031740' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381350'
                WHERE ordernumber = 'P190313154138846' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381351'
                WHERE ordernumber = 'P200313154148995' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381352'
                WHERE ordernumber = 'P180313154242683' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314988'
                WHERE ordernumber = 'P190313154506593' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381353'
                WHERE ordernumber = 'P190313155025177' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102257'
                WHERE ordernumber = 'P180313155139913' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381354'
                WHERE ordernumber = 'P200313155233120' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105829'
                WHERE ordernumber = 'P180313155509712' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368655'
                WHERE ordernumber = 'P180313160004679' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284320'
                WHERE ordernumber = 'P200313160414848' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381356'
                WHERE ordernumber = 'P200313160541248' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381358'
                WHERE ordernumber = 'P200313160749745' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381360'
                WHERE ordernumber = 'P180313161843647' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381361'
                WHERE ordernumber = 'P180313162144435' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136062'
                WHERE ordernumber = 'P180313163303557' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381365'
                WHERE ordernumber = 'P200313163658404' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379943'
                WHERE ordernumber = 'P180313163916674' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330671'
                WHERE ordernumber = 'P420313164147593' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226626'
                WHERE ordernumber = 'P180313164346341' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381367'
                WHERE ordernumber = 'P180313165310837' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379396'
                WHERE ordernumber = 'P180313165429991' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374789'
                WHERE ordernumber = 'P180313165555447' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381369'
                WHERE ordernumber = 'P180313165923287' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381370'
                WHERE ordernumber = 'P180313170348550' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381371'
                WHERE ordernumber = 'P420313170407806' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250213'
                WHERE ordernumber = 'P180313170925444' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67370'
                WHERE ordernumber = 'P420313171012429' 
            
2024-03-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381372'
                WHERE ordernumber = 'P190313171028290' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381373'
                WHERE ordernumber = 'P180313171036808' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381374'
                WHERE ordernumber = 'P200313171145845' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296582'
                WHERE ordernumber = 'P200313171249508' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '85494'
                WHERE ordernumber = 'P200313171957555' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319052'
                WHERE ordernumber = 'P200313172622798' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379185'
                WHERE ordernumber = 'P180313172816833' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381376'
                WHERE ordernumber = 'P420313173029112' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381378'
                WHERE ordernumber = 'P200313173421289' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96868'
                WHERE ordernumber = 'P200313173507924' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119193'
                WHERE ordernumber = 'P590313173935646' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P180313174411132' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311267'
                WHERE ordernumber = 'P200313174602206' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381380'
                WHERE ordernumber = 'P590313174841433' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381381'
                WHERE ordernumber = 'P590313175053619' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381382'
                WHERE ordernumber = 'P180313175215263' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345372'
                WHERE ordernumber = 'P200313175247467' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381384'
                WHERE ordernumber = 'P180313180005275' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381385'
                WHERE ordernumber = 'P180313180112374' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242535'
                WHERE ordernumber = 'P180313180256139' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101826'
                WHERE ordernumber = 'P200313180501599' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297582'
                WHERE ordernumber = 'P420313180806501' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381386'
                WHERE ordernumber = 'P420313180834662' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381387'
                WHERE ordernumber = 'P180313180956812' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136062'
                WHERE ordernumber = 'P180313181431128' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136062'
                WHERE ordernumber = 'P180313181454543' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381388'
                WHERE ordernumber = 'P200313181524606' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381389'
                WHERE ordernumber = 'P420313181706715' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311545'
                WHERE ordernumber = 'P180313181743808' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180313182613216' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114408'
                WHERE ordernumber = 'P180313182718310' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381390'
                WHERE ordernumber = 'P180313182957651' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121795'
                WHERE ordernumber = 'P200313183024233' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180313183142475' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381391'
                WHERE ordernumber = 'P180313183813656' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381392'
                WHERE ordernumber = 'P180313183959730' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250394'
                WHERE ordernumber = 'P190313184519557' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64697'
                WHERE ordernumber = 'P190313184639660' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381393'
                WHERE ordernumber = 'P420313185337974' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381394'
                WHERE ordernumber = 'P190313185930422' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381338'
                WHERE ordernumber = 'P190313190341310' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381395'
                WHERE ordernumber = 'P200313190418442' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296732'
                WHERE ordernumber = 'P590313190920784' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276579'
                WHERE ordernumber = 'P190313190929895' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381396'
                WHERE ordernumber = 'P200313191202315' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381397'
                WHERE ordernumber = 'P190313191358767' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345316'
                WHERE ordernumber = 'P190313191659137' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317070'
                WHERE ordernumber = 'P190313192347832' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381398'
                WHERE ordernumber = 'P190313192612530' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381399'
                WHERE ordernumber = 'P190313192942132' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141605'
                WHERE ordernumber = 'P200313193455317' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381401'
                WHERE ordernumber = 'P590313193848266' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381400'
                WHERE ordernumber = 'P590313194049317' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381402'
                WHERE ordernumber = 'P190313194127426' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381403'
                WHERE ordernumber = 'P190313194433374' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305444'
                WHERE ordernumber = 'P420313194603312' 
            
2024-03-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233276'
                WHERE ordernumber = 'P200313194950500'