2024-08-11 01:00:02 -- 將會員中心id寫入data-lake
2024-08-11 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-08-10%';
        
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238440'
                WHERE ordernumber = 'P180810110206199' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129423'
                WHERE ordernumber = 'P180810110426985' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406869'
                WHERE ordernumber = 'P190810110619953' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406868'
                WHERE ordernumber = 'P200810110637328' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406871'
                WHERE ordernumber = 'P180810110903424' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406872'
                WHERE ordernumber = 'P180810111014125' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406873'
                WHERE ordernumber = 'P180810111137806' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340520'
                WHERE ordernumber = 'P180810111254154' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406875'
                WHERE ordernumber = 'P200810111712191' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245711'
                WHERE ordernumber = 'P200810111834297' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406876'
                WHERE ordernumber = 'P200810112142430' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406877'
                WHERE ordernumber = 'P180810112209165' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406878'
                WHERE ordernumber = 'P420810112245926' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374085'
                WHERE ordernumber = 'P190810112350974' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406880'
                WHERE ordernumber = 'P180810112654808' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304079'
                WHERE ordernumber = 'P190810112748361' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400019'
                WHERE ordernumber = 'P420810112904920' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '361334'
                WHERE ordernumber = 'P190810112938116' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406881'
                WHERE ordernumber = 'P180810112959675' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397894'
                WHERE ordernumber = 'P420810113057571' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406802'
                WHERE ordernumber = 'P180810113851584' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406883'
                WHERE ordernumber = 'P200810114034678' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237785'
                WHERE ordernumber = 'P200810114223136' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406884'
                WHERE ordernumber = 'P190810114300385' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406888'
                WHERE ordernumber = 'P180810115101779' 
            
2024-08-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403535'
                WHERE ordernumber = 'P630810115114435' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406885'
                WHERE ordernumber = 'P180810115138293' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113468'
                WHERE ordernumber = 'P190810115151541' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271927'
                WHERE ordernumber = 'P420810115245862' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406889'
                WHERE ordernumber = 'P180810115304483' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271927'
                WHERE ordernumber = 'P420810115411141' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382216'
                WHERE ordernumber = 'P180810115450716' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406892'
                WHERE ordernumber = 'P180810115816886' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406893'
                WHERE ordernumber = 'P200810115859137' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '91125'
                WHERE ordernumber = 'P190810120211227' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406896'
                WHERE ordernumber = 'P180810120235955' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401045'
                WHERE ordernumber = 'P200810120313407' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406897'
                WHERE ordernumber = 'P180810120607799' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99639'
                WHERE ordernumber = 'P180810121053877' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P420810121414518' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406900'
                WHERE ordernumber = 'P200810121443864' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278989'
                WHERE ordernumber = 'P180810121557610' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406901'
                WHERE ordernumber = 'P420810121610256' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406902'
                WHERE ordernumber = 'P180810121726137' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406903'
                WHERE ordernumber = 'P420810121834918' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281355'
                WHERE ordernumber = 'P190810121841929' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406904'
                WHERE ordernumber = 'P200810122007338' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390288'
                WHERE ordernumber = 'P180810122041974' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406906'
                WHERE ordernumber = 'P180810122158847' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406905'
                WHERE ordernumber = 'P420810122200189' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124768'
                WHERE ordernumber = 'P630810122300241' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281355'
                WHERE ordernumber = 'P190810122322964' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406907'
                WHERE ordernumber = 'P180810122403298' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406908'
                WHERE ordernumber = 'P420810122428596' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266791'
                WHERE ordernumber = 'P420810122504673' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406911'
                WHERE ordernumber = 'P180810122635143' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406912'
                WHERE ordernumber = 'P420810122700367' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380797'
                WHERE ordernumber = 'P200810122726402' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406909'
                WHERE ordernumber = 'P180810122807184' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316889'
                WHERE ordernumber = 'P420810122834472' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278680'
                WHERE ordernumber = 'P420810122919176' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287586'
                WHERE ordernumber = 'P180810123013230' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406913'
                WHERE ordernumber = 'P180810123203971' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406914'
                WHERE ordernumber = 'P200810123323867' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63785'
                WHERE ordernumber = 'P180810123414416' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241220'
                WHERE ordernumber = 'P190810123524748' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406915'
                WHERE ordernumber = 'P180810123733136' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406916'
                WHERE ordernumber = 'P420810123815470' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251046'
                WHERE ordernumber = 'P190810123816787' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64068'
                WHERE ordernumber = 'P180810123909818' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251046'
                WHERE ordernumber = 'P190810123910746' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406919'
                WHERE ordernumber = 'P420810124115986' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406920'
                WHERE ordernumber = 'P180810124350839' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249564'
                WHERE ordernumber = 'P180810124930251' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406923'
                WHERE ordernumber = 'P420810125000714' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406924'
                WHERE ordernumber = 'P180810125253827' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406926'
                WHERE ordernumber = 'P200810125424956' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406927'
                WHERE ordernumber = 'P180810125504429' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310111'
                WHERE ordernumber = 'P200810130334366' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406930'
                WHERE ordernumber = 'P180810130738356' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406931'
                WHERE ordernumber = 'P200810130809876' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406932'
                WHERE ordernumber = 'P200810131134620' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355737'
                WHERE ordernumber = 'P190810131704742' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292240'
                WHERE ordernumber = 'P420810132006154' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406936'
                WHERE ordernumber = 'P200810132130289' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395565'
                WHERE ordernumber = 'P180810132235480' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406939'
                WHERE ordernumber = 'P420810132940871' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318041'
                WHERE ordernumber = 'P190810133003702' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406940'
                WHERE ordernumber = 'P200810133003336' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386309'
                WHERE ordernumber = 'P420810133110260' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322960'
                WHERE ordernumber = 'P200810133151659' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406941'
                WHERE ordernumber = 'P420810133224530' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406938'
                WHERE ordernumber = 'P180810133306874' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406942'
                WHERE ordernumber = 'P190810133307402' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406943'
                WHERE ordernumber = 'P190810133430473' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406944'
                WHERE ordernumber = 'P180810133649311' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406945'
                WHERE ordernumber = 'P420810133656864' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406946'
                WHERE ordernumber = 'P420810133758609' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406947'
                WHERE ordernumber = 'P420810133922807' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390684'
                WHERE ordernumber = 'P200810134030112' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406949'
                WHERE ordernumber = 'P420810134322254' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406953'
                WHERE ordernumber = 'P420810135238322' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406952'
                WHERE ordernumber = 'P590810135322325' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406954'
                WHERE ordernumber = 'P200810135820950' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339903'
                WHERE ordernumber = 'P420810135849825' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287343'
                WHERE ordernumber = 'P180810140035332' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276251'
                WHERE ordernumber = 'P200810140040876' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406955'
                WHERE ordernumber = 'P180810140420406' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406956'
                WHERE ordernumber = 'P420810140435570' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406957'
                WHERE ordernumber = 'P420810140552194' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270139'
                WHERE ordernumber = 'P200810140834299' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406961'
                WHERE ordernumber = 'P420810141018535' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406960'
                WHERE ordernumber = 'P180810141026988' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406952'
                WHERE ordernumber = 'P590810141342922' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403761'
                WHERE ordernumber = 'P190810141347930' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406962'
                WHERE ordernumber = 'P190810141612400' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146945'
                WHERE ordernumber = 'P190810141713201' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406963'
                WHERE ordernumber = 'P420810141714326' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405577'
                WHERE ordernumber = 'P180810142006556' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406964'
                WHERE ordernumber = 'P190810142100954' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320896'
                WHERE ordernumber = 'P180810142100888' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163819'
                WHERE ordernumber = 'P200810142318844' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395168'
                WHERE ordernumber = 'P200810142511380' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406960'
                WHERE ordernumber = 'P180810142715268' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '36887'
                WHERE ordernumber = 'P190810142759183' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406967'
                WHERE ordernumber = 'P420810142932585' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311185'
                WHERE ordernumber = 'P180810142934264' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138626'
                WHERE ordernumber = 'P200810143018681' 
            
2024-08-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378780'
                WHERE ordernumber = 'P420810143131496' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406968'
                WHERE ordernumber = 'P190810143132369' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406969'
                WHERE ordernumber = 'P180810143227182' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406973'
                WHERE ordernumber = 'P180810144126951' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406975'
                WHERE ordernumber = 'P180810144531820' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406195'
                WHERE ordernumber = 'P190810144606150' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401946'
                WHERE ordernumber = 'P200810144651583' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406977'
                WHERE ordernumber = 'P190810144830587' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406978'
                WHERE ordernumber = 'P180810145001269' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406979'
                WHERE ordernumber = 'P420810145219502' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406980'
                WHERE ordernumber = 'P420810145808935' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379717'
                WHERE ordernumber = 'P200810145852998' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406981'
                WHERE ordernumber = 'P200810150141751' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322827'
                WHERE ordernumber = 'P200810150246355' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406984'
                WHERE ordernumber = 'P180810151011906' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406985'
                WHERE ordernumber = 'P420810151200538' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406986'
                WHERE ordernumber = 'P180810151255906' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406987'
                WHERE ordernumber = 'P420810151627908' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364963'
                WHERE ordernumber = 'P180810151709625' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406990'
                WHERE ordernumber = 'P200810152135377' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369731'
                WHERE ordernumber = 'P180810152259996' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406989'
                WHERE ordernumber = 'P180810152429850' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406993'
                WHERE ordernumber = 'P200810152928558' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406995'
                WHERE ordernumber = 'P180810154004907' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115196'
                WHERE ordernumber = 'P190810154035373' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406996'
                WHERE ordernumber = 'P200810154041470' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406998'
                WHERE ordernumber = 'P420810154432578' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407000'
                WHERE ordernumber = 'P420810154554451' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305771'
                WHERE ordernumber = 'P200810154556713' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407002'
                WHERE ordernumber = 'P420810154716792' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405899'
                WHERE ordernumber = 'P180810154743791' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407003'
                WHERE ordernumber = 'P420810154825805' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407001'
                WHERE ordernumber = 'P630810154833592' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407006'
                WHERE ordernumber = 'P180810154854449' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407004'
                WHERE ordernumber = 'P190810154900820' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328236'
                WHERE ordernumber = 'P420810155248118' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407007'
                WHERE ordernumber = 'P420810155458807' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169204'
                WHERE ordernumber = 'P180810155557257' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314147'
                WHERE ordernumber = 'P180810155905672' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329441'
                WHERE ordernumber = 'P420810155909219' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407010'
                WHERE ordernumber = 'P200810160005847' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397461'
                WHERE ordernumber = 'P180810160049422' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407011'
                WHERE ordernumber = 'P420810160502328' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317026'
                WHERE ordernumber = 'P200810160550273' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407012'
                WHERE ordernumber = 'P180810160736130' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405527'
                WHERE ordernumber = 'P190810160823125' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407013'
                WHERE ordernumber = 'P180810160927575' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407014'
                WHERE ordernumber = 'P420810161411280' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407015'
                WHERE ordernumber = 'P420810161508803' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405944'
                WHERE ordernumber = 'P200810161550196' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407016'
                WHERE ordernumber = 'P420810161629617' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407017'
                WHERE ordernumber = 'P420810161719791' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407019'
                WHERE ordernumber = 'P420810161825686' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407020'
                WHERE ordernumber = 'P180810162106307' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407021'
                WHERE ordernumber = 'P420810162135230' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407023'
                WHERE ordernumber = 'P420810162233134' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407024'
                WHERE ordernumber = 'P190810162445593' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346039'
                WHERE ordernumber = 'P190810163032834' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407026'
                WHERE ordernumber = 'P180810163036745' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325282'
                WHERE ordernumber = 'P590810163857305' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407029'
                WHERE ordernumber = 'P200810163957161' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407031'
                WHERE ordernumber = 'P180810164023329' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398349'
                WHERE ordernumber = 'P180810164207678' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395568'
                WHERE ordernumber = 'P420810164226827' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400497'
                WHERE ordernumber = 'P420810164330555' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398349'
                WHERE ordernumber = 'P180810164409113' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398349'
                WHERE ordernumber = 'P180810164651507' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407034'
                WHERE ordernumber = 'P200810164918784' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P200810164947771' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P200810165140846' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98818'
                WHERE ordernumber = 'P180810165150575' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407036'
                WHERE ordernumber = 'P180810165254430' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407037'
                WHERE ordernumber = 'P420810165329123' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407038'
                WHERE ordernumber = 'P420810165447287' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407040'
                WHERE ordernumber = 'P630810165733590' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407041'
                WHERE ordernumber = 'P200810165755643' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276658'
                WHERE ordernumber = 'P420810165755853' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407042'
                WHERE ordernumber = 'P180810170414558' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319694'
                WHERE ordernumber = 'P200810170425784' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395039'
                WHERE ordernumber = 'P180810170756740' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407043'
                WHERE ordernumber = 'P180810171041254' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407044'
                WHERE ordernumber = 'P200810171101570' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113100'
                WHERE ordernumber = 'P180810171400596' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344430'
                WHERE ordernumber = 'P180810171557304' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319694'
                WHERE ordernumber = 'P200810171923735' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407046'
                WHERE ordernumber = 'P180810172044363' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101375'
                WHERE ordernumber = 'P180810172157421' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226512'
                WHERE ordernumber = 'P200810172158356' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407047'
                WHERE ordernumber = 'P420810172402372' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322882'
                WHERE ordernumber = 'P420810172515501' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407048'
                WHERE ordernumber = 'P180810172535734' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407049'
                WHERE ordernumber = 'P420810172717422' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407050'
                WHERE ordernumber = 'P420810172822612' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406958'
                WHERE ordernumber = 'P180810172839173' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407052'
                WHERE ordernumber = 'P200810173137878' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407053'
                WHERE ordernumber = 'P200810173305402' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405565'
                WHERE ordernumber = 'P190810173547260' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407056'
                WHERE ordernumber = 'P420810173606968' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115433'
                WHERE ordernumber = 'P420810173652544' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P200810173849516' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341314'
                WHERE ordernumber = 'P180810174017887' 
            
2024-08-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '183034'
                WHERE ordernumber = 'P200810174109799' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '183034'
                WHERE ordernumber = 'P200810174111994' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393928'
                WHERE ordernumber = 'P420810174233921' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '330529'
                WHERE ordernumber = 'P420810174343657' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407059'
                WHERE ordernumber = 'P420810174958222' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '153748'
                WHERE ordernumber = 'P420810175103802' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348953'
                WHERE ordernumber = 'P200810175111752' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407060'
                WHERE ordernumber = 'P190810175136891' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289478'
                WHERE ordernumber = 'P200810175212983' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '321130'
                WHERE ordernumber = 'P190810175410288' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '246301'
                WHERE ordernumber = 'P180810175806375' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405298'
                WHERE ordernumber = 'P420810175919199' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389320'
                WHERE ordernumber = 'P180810175919559' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '77799'
                WHERE ordernumber = 'P180810180117816' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348429'
                WHERE ordernumber = 'P200810180852722' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407062'
                WHERE ordernumber = 'P190810181207640' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407064'
                WHERE ordernumber = 'P420810181234919' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221498'
                WHERE ordernumber = 'P200810181330254' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407065'
                WHERE ordernumber = 'P200810181629611' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407066'
                WHERE ordernumber = 'P200810181901571' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407068'
                WHERE ordernumber = 'P420810182236358' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104230'
                WHERE ordernumber = 'P180810182323312' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407069'
                WHERE ordernumber = 'P200810182429611' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406813'
                WHERE ordernumber = 'P180810182523701' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407071'
                WHERE ordernumber = 'P180810182725353' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407073'
                WHERE ordernumber = 'P180810183024353' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167092'
                WHERE ordernumber = 'P420810183204586' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386588'
                WHERE ordernumber = 'P180810183527942' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407074'
                WHERE ordernumber = 'P180810183710608' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407075'
                WHERE ordernumber = 'P180810183810419' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407076'
                WHERE ordernumber = 'P420810184253360' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407077'
                WHERE ordernumber = 'P420810184537741' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '244544'
                WHERE ordernumber = 'P200810184616520' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254145'
                WHERE ordernumber = 'P180810184636870' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407080'
                WHERE ordernumber = 'P200810184752327' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407079'
                WHERE ordernumber = 'P420810184805735' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407083'
                WHERE ordernumber = 'P420810184919693' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '63006'
                WHERE ordernumber = 'P190810185200409' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407085'
                WHERE ordernumber = 'P420810185229444' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329154'
                WHERE ordernumber = 'P200810185327318' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407086'
                WHERE ordernumber = 'P190810185438761' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380828'
                WHERE ordernumber = 'P200810185554166' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400781'
                WHERE ordernumber = 'P190810185900328' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407087'
                WHERE ordernumber = 'P190810185942218' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407088'
                WHERE ordernumber = 'P200810185946586' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407089'
                WHERE ordernumber = 'P200810190144436' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312338'
                WHERE ordernumber = 'P630810190353577' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407090'
                WHERE ordernumber = 'P190810190851736' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346997'
                WHERE ordernumber = 'P190810192200145' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '325272'
                WHERE ordernumber = 'P190810192313137' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '172877'
                WHERE ordernumber = 'P190810192443440' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407091'
                WHERE ordernumber = 'P190810192553888' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407092'
                WHERE ordernumber = 'P200810192757441' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105116'
                WHERE ordernumber = 'P200810193130504' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407093'
                WHERE ordernumber = 'P190810193206861' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393578'
                WHERE ordernumber = 'P200810193224991' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '190753'
                WHERE ordernumber = 'P200810193423444' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '117866'
                WHERE ordernumber = 'P190810193502197' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407094'
                WHERE ordernumber = 'P200810193628861' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406445'
                WHERE ordernumber = 'P200810193944663' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393370'
                WHERE ordernumber = 'P200810194751208' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407097'
                WHERE ordernumber = 'P190810194811251' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407098'
                WHERE ordernumber = 'P200810195100922' 
            
2024-08-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391324'
                WHERE ordernumber = 'P630810195809781'