2024-10-14 01:00:01 -- 將會員中心id寫入data-lake
2024-10-14 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-10-13%';
        
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '425657'
                WHERE ordernumber = 'P631013104138137' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P421013110216557' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '386405'
                WHERE ordernumber = 'P191013110221851' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '403614'
                WHERE ordernumber = 'P191013110311137' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '377605'
                WHERE ordernumber = 'P421013110326273' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '327485'
                WHERE ordernumber = 'P201013110331581' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '289302'
                WHERE ordernumber = 'P201013110537116' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '276877'
                WHERE ordernumber = 'P201013110923867' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '425661'
                WHERE ordernumber = 'P201013111232638' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '425660'
                WHERE ordernumber = 'P191013111315513' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '377806'
                WHERE ordernumber = 'P421013111425264' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '94067'
                WHERE ordernumber = 'P191013111751551' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '425440'
                WHERE ordernumber = 'P421013111949690' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '425665'
                WHERE ordernumber = 'P191013112029685' 
            
2024-10-14 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '425664'
                WHERE ordernumber = 'P421013112117417' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425666'
                WHERE ordernumber = 'P191013112237790' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425668'
                WHERE ordernumber = 'P191013112403769' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425667'
                WHERE ordernumber = 'P711013112556608' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425670'
                WHERE ordernumber = 'P191013112603653' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377605'
                WHERE ordernumber = 'P421013112738420' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425669'
                WHERE ordernumber = 'P731013112824263' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425671'
                WHERE ordernumber = 'P191013112824673' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425672'
                WHERE ordernumber = 'P191013112940206' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94624'
                WHERE ordernumber = 'P201013113410133' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222335'
                WHERE ordernumber = 'P201013114341228' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425674'
                WHERE ordernumber = 'P711013114355451' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425675'
                WHERE ordernumber = 'P201013114925469' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425677'
                WHERE ordernumber = 'P191013115206125' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425681'
                WHERE ordernumber = 'P201013115402870' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425679'
                WHERE ordernumber = 'P421013115432982' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425680'
                WHERE ordernumber = 'P191013115836333' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '256362'
                WHERE ordernumber = 'P191013120005490' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425681'
                WHERE ordernumber = 'P201013120104175' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398014'
                WHERE ordernumber = 'P421013120126290' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425682'
                WHERE ordernumber = 'P191013120301184' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99445'
                WHERE ordernumber = 'P201013120333739' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '262052'
                WHERE ordernumber = 'P201013120634332' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425684'
                WHERE ordernumber = 'P421013121055209' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425685'
                WHERE ordernumber = 'P421013121758164' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425686'
                WHERE ordernumber = 'P421013122151385' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425688'
                WHERE ordernumber = 'P191013122519914' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '165672'
                WHERE ordernumber = 'P201013122945197' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425689'
                WHERE ordernumber = 'P421013123042287' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337863'
                WHERE ordernumber = 'P421013123555728' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425691'
                WHERE ordernumber = 'P201013124536297' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425692'
                WHERE ordernumber = 'P421013124927635' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276826'
                WHERE ordernumber = 'P191013130213815' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425120'
                WHERE ordernumber = 'P181013130317208' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302881'
                WHERE ordernumber = 'P421013130543510' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375649'
                WHERE ordernumber = 'P421013130931854' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425697'
                WHERE ordernumber = 'P201013131009983' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425696'
                WHERE ordernumber = 'P421013131156378' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423707'
                WHERE ordernumber = 'P201013131714395' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384454'
                WHERE ordernumber = 'P631013132010763' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425702'
                WHERE ordernumber = 'P181013132032843' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285740'
                WHERE ordernumber = 'P181013132157875' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425700'
                WHERE ordernumber = 'P181013132224922' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425705'
                WHERE ordernumber = 'P201013132236767' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425698'
                WHERE ordernumber = 'P181013132342550' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425704'
                WHERE ordernumber = 'P421013132407259' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423001'
                WHERE ordernumber = 'P711013132415141' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425703'
                WHERE ordernumber = 'P421013132427955' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425706'
                WHERE ordernumber = 'P421013132643373' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425708'
                WHERE ordernumber = 'P201013132658515' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425707'
                WHERE ordernumber = 'P731013132658523' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425710'
                WHERE ordernumber = 'P711013133235836' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303548'
                WHERE ordernumber = 'P201013133253581' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425711'
                WHERE ordernumber = 'P421013133337800' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425418'
                WHERE ordernumber = 'P181013133714570' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425712'
                WHERE ordernumber = 'P711013133913171' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425714'
                WHERE ordernumber = 'P201013134324659' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425709'
                WHERE ordernumber = 'P421013134337694' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425715'
                WHERE ordernumber = 'P421013134548365' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425716'
                WHERE ordernumber = 'P181013134712539' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423906'
                WHERE ordernumber = 'P421013135036976' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423906'
                WHERE ordernumber = 'P421013135058514' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425717'
                WHERE ordernumber = 'P181013135626919' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425718'
                WHERE ordernumber = 'P181013135731681' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425713'
                WHERE ordernumber = 'P181013135910988' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425719'
                WHERE ordernumber = 'P421013135955640' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425721'
                WHERE ordernumber = 'P181013140041439' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '174607'
                WHERE ordernumber = 'P191013140129908' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425720'
                WHERE ordernumber = 'P191013140559757' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425723'
                WHERE ordernumber = 'P201013140621859' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420012'
                WHERE ordernumber = 'P421013141047516' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94519'
                WHERE ordernumber = 'P181013141301433' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421257'
                WHERE ordernumber = 'P421013141554217' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425731'
                WHERE ordernumber = 'P181013142313373' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425730'
                WHERE ordernumber = 'P711013142339509' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425732'
                WHERE ordernumber = 'P201013142404489' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425735'
                WHERE ordernumber = 'P711013143155869' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425736'
                WHERE ordernumber = 'P201013143314516' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425728'
                WHERE ordernumber = 'P191013143819829' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425726'
                WHERE ordernumber = 'P191013143826670' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425727'
                WHERE ordernumber = 'P191013143833507' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425725'
                WHERE ordernumber = 'P191013143839356' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425722'
                WHERE ordernumber = 'P191013143846183' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425737'
                WHERE ordernumber = 'P201013144056440' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425738'
                WHERE ordernumber = 'P181013144245167' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100514'
                WHERE ordernumber = 'P181013144411771' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269118'
                WHERE ordernumber = 'P201013144428242' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425739'
                WHERE ordernumber = 'P731013144511352' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338829'
                WHERE ordernumber = 'P201013144609197' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425740'
                WHERE ordernumber = 'P181013144700650' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245623'
                WHERE ordernumber = 'P181013144801551' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425741'
                WHERE ordernumber = 'P711013144919229' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425742'
                WHERE ordernumber = 'P201013144935215' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '132808'
                WHERE ordernumber = 'P731013144945953' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425742'
                WHERE ordernumber = 'P201013145004707' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423575'
                WHERE ordernumber = 'P711013145142243' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425743'
                WHERE ordernumber = 'P421013145217449' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425734'
                WHERE ordernumber = 'P191013145332514' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425734'
                WHERE ordernumber = 'P191013145601526' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425745'
                WHERE ordernumber = 'P421013150135291' 
            
2024-10-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425746'
                WHERE ordernumber = 'P711013150235407' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425747'
                WHERE ordernumber = 'P711013150632129' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319255'
                WHERE ordernumber = 'P421013150706329' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425748'
                WHERE ordernumber = 'P421013150758980' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425749'
                WHERE ordernumber = 'P731013151038406' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425750'
                WHERE ordernumber = 'P731013151251904' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425751'
                WHERE ordernumber = 'P201013151327595' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425752'
                WHERE ordernumber = 'P421013151738306' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425753'
                WHERE ordernumber = 'P711013152318436' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173682'
                WHERE ordernumber = 'P201013152331910' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425754'
                WHERE ordernumber = 'P191013152632314' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88154'
                WHERE ordernumber = 'P191013152842399' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425755'
                WHERE ordernumber = 'P711013152850129' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102005'
                WHERE ordernumber = 'P421013152913448' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425757'
                WHERE ordernumber = 'P191013153157678' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425757'
                WHERE ordernumber = 'P191013153243463' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425757'
                WHERE ordernumber = 'P191013153333432' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291564'
                WHERE ordernumber = 'P421013153354173' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341882'
                WHERE ordernumber = 'P421013153705419' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425760'
                WHERE ordernumber = 'P181013153729977' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425759'
                WHERE ordernumber = 'P201013154016918' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425761'
                WHERE ordernumber = 'P421013154039401' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282773'
                WHERE ordernumber = 'P201013154422844' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62978'
                WHERE ordernumber = 'P181013154723813' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234151'
                WHERE ordernumber = 'P201013155108194' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425764'
                WHERE ordernumber = 'P201013155259220' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226122'
                WHERE ordernumber = 'P181013155358952' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425765'
                WHERE ordernumber = 'P201013155755731' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425765'
                WHERE ordernumber = 'P201013155913460' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425766'
                WHERE ordernumber = 'P421013160804970' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224698'
                WHERE ordernumber = 'P421013161343575' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267420'
                WHERE ordernumber = 'P201013161431249' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349033'
                WHERE ordernumber = 'P181013161839527' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425768'
                WHERE ordernumber = 'P421013162320477' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425769'
                WHERE ordernumber = 'P421013162433311' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425770'
                WHERE ordernumber = 'P201013162707451' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425773'
                WHERE ordernumber = 'P181013162831570' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425772'
                WHERE ordernumber = 'P181013162951546' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425775'
                WHERE ordernumber = 'P421013163204700' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100813'
                WHERE ordernumber = 'P201013163546863' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425777'
                WHERE ordernumber = 'P421013163633701' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425778'
                WHERE ordernumber = 'P181013163802779' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425781'
                WHERE ordernumber = 'P181013164239569' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425782'
                WHERE ordernumber = 'P421013164524937' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157525'
                WHERE ordernumber = 'P201013164528698' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160165'
                WHERE ordernumber = 'P181013164708245' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425779'
                WHERE ordernumber = 'P181013164939399' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425004'
                WHERE ordernumber = 'P181013165252882' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425785'
                WHERE ordernumber = 'P421013165436297' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229415'
                WHERE ordernumber = 'P181013165451390' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416959'
                WHERE ordernumber = 'P731013165624250' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253667'
                WHERE ordernumber = 'P421013170017209' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162963'
                WHERE ordernumber = 'P201013170218698' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162963'
                WHERE ordernumber = 'P201013170446471' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255362'
                WHERE ordernumber = 'P181013170509973' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425786'
                WHERE ordernumber = 'P421013170740154' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277303'
                WHERE ordernumber = 'P181013170900848' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404116'
                WHERE ordernumber = 'P421013170902180' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425788'
                WHERE ordernumber = 'P711013170929551' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379526'
                WHERE ordernumber = 'P421013171008799' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379538'
                WHERE ordernumber = 'P181013171040715' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425789'
                WHERE ordernumber = 'P421013171112513' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347220'
                WHERE ordernumber = 'P201013171446972' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425790'
                WHERE ordernumber = 'P421013171704735' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206284'
                WHERE ordernumber = 'P421013171809694' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425791'
                WHERE ordernumber = 'P201013172111190' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306637'
                WHERE ordernumber = 'P201013172237496' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425794'
                WHERE ordernumber = 'P201013172522905' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425795'
                WHERE ordernumber = 'P731013172907221' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425796'
                WHERE ordernumber = 'P731013173018557' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397198'
                WHERE ordernumber = 'P201013173100407' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425798'
                WHERE ordernumber = 'P421013173244945' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425797'
                WHERE ordernumber = 'P591013173514546' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425800'
                WHERE ordernumber = 'P421013174513523' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406831'
                WHERE ordernumber = 'P181013175057203' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351726'
                WHERE ordernumber = 'P201013175131779' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425801'
                WHERE ordernumber = 'P421013175310490' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425802'
                WHERE ordernumber = 'P421013175508493' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396308'
                WHERE ordernumber = 'P181013180229316' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215172'
                WHERE ordernumber = 'P421013180336448' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425771'
                WHERE ordernumber = 'P421013180450309' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425774'
                WHERE ordernumber = 'P421013180702981' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425804'
                WHERE ordernumber = 'P421013182039824' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425805'
                WHERE ordernumber = 'P421013182638176' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422345'
                WHERE ordernumber = 'P731013182829616' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425806'
                WHERE ordernumber = 'P731013183415227' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425807'
                WHERE ordernumber = 'P201013183437510' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305804'
                WHERE ordernumber = 'P201013184031966' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142377'
                WHERE ordernumber = 'P731013184223500' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425808'
                WHERE ordernumber = 'P731013184426370' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425811'
                WHERE ordernumber = 'P731013184704812' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425812'
                WHERE ordernumber = 'P731013184945117' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425810'
                WHERE ordernumber = 'P191013185052318' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364595'
                WHERE ordernumber = 'P421013185133662' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255362'
                WHERE ordernumber = 'P191013190802773' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425815'
                WHERE ordernumber = 'P191013192424601' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425817'
                WHERE ordernumber = 'P191013193218934' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425819'
                WHERE ordernumber = 'P191013194337521' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425818'
                WHERE ordernumber = 'P191013194631819' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381970'
                WHERE ordernumber = 'P191013194854351' 
            
2024-10-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405884'
                WHERE ordernumber = 'P191013195017613' 
            
2024-10-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425822'
                WHERE ordernumber = 'P731013204941753' 
            
2024-10-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425827'
                WHERE ordernumber = 'P711013212601803' 
            
2024-10-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421190'
                WHERE ordernumber = 'P711013212734903'