2024-08-09 01:00:03 -- 將會員中心id寫入data-lake
2024-08-09 01:00:03 -- 
            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-08%';
        
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380161'
                WHERE ordernumber = 'P420808105934509' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292297'
                WHERE ordernumber = 'P200808110254503' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406288'
                WHERE ordernumber = 'P200808110401153' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351539'
                WHERE ordernumber = 'P190808110424728' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406289'
                WHERE ordernumber = 'P200808110501117' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '185989'
                WHERE ordernumber = 'P200808110538182' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406290'
                WHERE ordernumber = 'P180808110733212' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352001'
                WHERE ordernumber = 'P180808110859887' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406291'
                WHERE ordernumber = 'P420808110902277' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406292'
                WHERE ordernumber = 'P180808111032517' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366261'
                WHERE ordernumber = 'P420808111320673' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406014'
                WHERE ordernumber = 'P180808111712562' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200808111919922' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296540'
                WHERE ordernumber = 'P420808112036845' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380341'
                WHERE ordernumber = 'P180808112155611' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406014'
                WHERE ordernumber = 'P180808112244217' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353461'
                WHERE ordernumber = 'P420808112356910' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406296'
                WHERE ordernumber = 'P200808112443203' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406297'
                WHERE ordernumber = 'P180808112514455' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380341'
                WHERE ordernumber = 'P180808112601126' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401927'
                WHERE ordernumber = 'P180808112724575' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221265'
                WHERE ordernumber = 'P200808112745469' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406298'
                WHERE ordernumber = 'P200808113202693' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405248'
                WHERE ordernumber = 'P630808113652983' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400234'
                WHERE ordernumber = 'P420808113931177' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228918'
                WHERE ordernumber = 'P180808114533903' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209599'
                WHERE ordernumber = 'P180808114637952' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405529'
                WHERE ordernumber = 'P180808114721888' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406303'
                WHERE ordernumber = 'P180808114836379' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406305'
                WHERE ordernumber = 'P180808115346655' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114534'
                WHERE ordernumber = 'P180808115756682' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406307'
                WHERE ordernumber = 'P420808120300169' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391493'
                WHERE ordernumber = 'P180808120323897' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229115'
                WHERE ordernumber = 'P420808120732193' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378254'
                WHERE ordernumber = 'P180808120833680' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406315'
                WHERE ordernumber = 'P200808121139529' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406314'
                WHERE ordernumber = 'P420808121140965' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402108'
                WHERE ordernumber = 'P200808121810662' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382843'
                WHERE ordernumber = 'P420808122816538' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406317'
                WHERE ordernumber = 'P200808123230998' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406318'
                WHERE ordernumber = 'P180808123444970' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350014'
                WHERE ordernumber = 'P200808124016227' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406319'
                WHERE ordernumber = 'P180808124058157' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96436'
                WHERE ordernumber = 'P180808124224465' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406322'
                WHERE ordernumber = 'P200808125011299' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '155299'
                WHERE ordernumber = 'P200808125056775' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387378'
                WHERE ordernumber = 'P200808125143542' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '61970'
                WHERE ordernumber = 'P180808125556870' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406326'
                WHERE ordernumber = 'P630808125908206' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378398'
                WHERE ordernumber = 'P200808130101740' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406328'
                WHERE ordernumber = 'P180808130433553' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381315'
                WHERE ordernumber = 'P420808130525712' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329685'
                WHERE ordernumber = 'P420808130750903' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64618'
                WHERE ordernumber = 'P200808131128128' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406332'
                WHERE ordernumber = 'P420808131358514' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93405'
                WHERE ordernumber = 'P590808131857837' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381294'
                WHERE ordernumber = 'P420808132111754' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406336'
                WHERE ordernumber = 'P180808132307238' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406335'
                WHERE ordernumber = 'P420808132415282' 
            
2024-08-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285340'
                WHERE ordernumber = 'P180808132420136' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406337'
                WHERE ordernumber = 'P200808132553191' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '133492'
                WHERE ordernumber = 'P200808133041841' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406341'
                WHERE ordernumber = 'P180808133549702' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406342'
                WHERE ordernumber = 'P200808133646366' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406344'
                WHERE ordernumber = 'P200808133746819' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '118999'
                WHERE ordernumber = 'P200808133855794' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406345'
                WHERE ordernumber = 'P180808134048546' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406348'
                WHERE ordernumber = 'P180808134701387' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406349'
                WHERE ordernumber = 'P420808134829766' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406350'
                WHERE ordernumber = 'P420808135038871' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289420'
                WHERE ordernumber = 'P180808135331135' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406353'
                WHERE ordernumber = 'P180808135502799' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397894'
                WHERE ordernumber = 'P420808135605530' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406355'
                WHERE ordernumber = 'P420808135917138' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406357'
                WHERE ordernumber = 'P180808140206333' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406359'
                WHERE ordernumber = 'P420808140621592' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337262'
                WHERE ordernumber = 'P420808140919603' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225810'
                WHERE ordernumber = 'P200808140948340' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406357'
                WHERE ordernumber = 'P180808141120186' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101793'
                WHERE ordernumber = 'P200808141310684' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406360'
                WHERE ordernumber = 'P180808141412772' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406361'
                WHERE ordernumber = 'P180808141522640' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406362'
                WHERE ordernumber = 'P420808141634593' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406364'
                WHERE ordernumber = 'P200808142203474' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385853'
                WHERE ordernumber = 'P180808142221136' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406365'
                WHERE ordernumber = 'P420808142617694' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406367'
                WHERE ordernumber = 'P200808143100975' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406369'
                WHERE ordernumber = 'P180808143217656' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406370'
                WHERE ordernumber = 'P200808143229309' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406372'
                WHERE ordernumber = 'P200808143338771' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396746'
                WHERE ordernumber = 'P420808144153823' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379002'
                WHERE ordernumber = 'P180808144231855' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406375'
                WHERE ordernumber = 'P420808144340666' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406377'
                WHERE ordernumber = 'P180808144613955' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379886'
                WHERE ordernumber = 'P190808145221256' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305353'
                WHERE ordernumber = 'P180808145331850' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406383'
                WHERE ordernumber = 'P420808145655778' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228910'
                WHERE ordernumber = 'P180808145823866' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406384'
                WHERE ordernumber = 'P200808150015466' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228910'
                WHERE ordernumber = 'P180808150053394' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406385'
                WHERE ordernumber = 'P420808150210764' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349611'
                WHERE ordernumber = 'P180808150418632' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406387'
                WHERE ordernumber = 'P180808150540368' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406388'
                WHERE ordernumber = 'P200808150631941' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406390'
                WHERE ordernumber = 'P180808150936455' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406271'
                WHERE ordernumber = 'P420808151027681' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295295'
                WHERE ordernumber = 'P180808151221395' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406392'
                WHERE ordernumber = 'P200808151344347' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406394'
                WHERE ordernumber = 'P180808151422355' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406397'
                WHERE ordernumber = 'P180808152051124' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401831'
                WHERE ordernumber = 'P180808152221630' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '152506'
                WHERE ordernumber = 'P180808153831491' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394025'
                WHERE ordernumber = 'P200808154128747' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406400'
                WHERE ordernumber = 'P200808154446658' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406401'
                WHERE ordernumber = 'P200808154620725' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180808154814957' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406403'
                WHERE ordernumber = 'P420808155656554' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406405'
                WHERE ordernumber = 'P180808160221773' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400330'
                WHERE ordernumber = 'P420808161054727' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406406'
                WHERE ordernumber = 'P190808161437586' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406407'
                WHERE ordernumber = 'P200808161521691' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380097'
                WHERE ordernumber = 'P180808161538891' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406408'
                WHERE ordernumber = 'P420808161739535' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406409'
                WHERE ordernumber = 'P420808161947620' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406410'
                WHERE ordernumber = 'P190808162012387' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406413'
                WHERE ordernumber = 'P420808162222796' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406414'
                WHERE ordernumber = 'P190808162302722' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395818'
                WHERE ordernumber = 'P180808162318195' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218995'
                WHERE ordernumber = 'P420808163002950' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406416'
                WHERE ordernumber = 'P190808163112130' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406417'
                WHERE ordernumber = 'P420808163853314' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406418'
                WHERE ordernumber = 'P180808164712261' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406420'
                WHERE ordernumber = 'P420808164908206' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334955'
                WHERE ordernumber = 'P200808165037318' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402949'
                WHERE ordernumber = 'P180808165121608' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345359'
                WHERE ordernumber = 'P200808165207420' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305549'
                WHERE ordernumber = 'P420808165250226' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391561'
                WHERE ordernumber = 'P180808165305308' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404121'
                WHERE ordernumber = 'P180808165553403' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167929'
                WHERE ordernumber = 'P200808165944151' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406421'
                WHERE ordernumber = 'P200808170121334' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406422'
                WHERE ordernumber = 'P190808170153957' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '320337'
                WHERE ordernumber = 'P180808170436469' 
            
2024-08-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380483'
                WHERE ordernumber = 'P420808170450858' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406423'
                WHERE ordernumber = 'P420808170748333' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '404370'
                WHERE ordernumber = 'P180808170812256' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '217480'
                WHERE ordernumber = 'P180808170903211' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '252014'
                WHERE ordernumber = 'P420808171625801' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '1501'
                WHERE ordernumber = 'P200808172434483' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '283775'
                WHERE ordernumber = 'P200808172716570' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '303580'
                WHERE ordernumber = 'P180808172943852' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406428'
                WHERE ordernumber = 'P200808173029215' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406430'
                WHERE ordernumber = 'P200808173353489' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '307079'
                WHERE ordernumber = 'P200808173621503' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '329135'
                WHERE ordernumber = 'P180808174454769' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '287300'
                WHERE ordernumber = 'P180808174549635' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406435'
                WHERE ordernumber = 'P200808174744794' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P180808175258724' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '388525'
                WHERE ordernumber = 'P200808175939900' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '278762'
                WHERE ordernumber = 'P180808180132387' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '134291'
                WHERE ordernumber = 'P200808180218947' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P180808180237242' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406438'
                WHERE ordernumber = 'P200808180309484' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406439'
                WHERE ordernumber = 'P420808180500474' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406440'
                WHERE ordernumber = 'P180808180647125' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '191619'
                WHERE ordernumber = 'P180808180817826' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '360233'
                WHERE ordernumber = 'P200808180908367' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '251294'
                WHERE ordernumber = 'P200808180956811' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406442'
                WHERE ordernumber = 'P200808181214988' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406443'
                WHERE ordernumber = 'P420808181437422' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '123392'
                WHERE ordernumber = 'P180808181532787' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406444'
                WHERE ordernumber = 'P420808181741521' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '84832'
                WHERE ordernumber = 'P190808181838534' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '111720'
                WHERE ordernumber = 'P590808181850921' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406445'
                WHERE ordernumber = 'P200808181908719' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '405842'
                WHERE ordernumber = 'P200808182320805' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '128489'
                WHERE ordernumber = 'P180808182339473' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '295052'
                WHERE ordernumber = 'P200808182558246' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406447'
                WHERE ordernumber = 'P180808182713976' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '392859'
                WHERE ordernumber = 'P180808183812120' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406450'
                WHERE ordernumber = 'P420808183859807' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397488'
                WHERE ordernumber = 'P190808184250415' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406452'
                WHERE ordernumber = 'P200808184305559' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403141'
                WHERE ordernumber = 'P180808184334437' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '96012'
                WHERE ordernumber = 'P200808184505652' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '213859'
                WHERE ordernumber = 'P190808184645129' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '364731'
                WHERE ordernumber = 'P200808184711243' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406455'
                WHERE ordernumber = 'P200808184927160' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '364731'
                WHERE ordernumber = 'P200808185204485' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '215668'
                WHERE ordernumber = 'P190808185335388' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406457'
                WHERE ordernumber = 'P200808185357863' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406458'
                WHERE ordernumber = 'P200808185543172' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '223349'
                WHERE ordernumber = 'P200808185735356' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406389'
                WHERE ordernumber = 'P190808185748656' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '284155'
                WHERE ordernumber = 'P200808190018825' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406460'
                WHERE ordernumber = 'P200808190329268' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '378750'
                WHERE ordernumber = 'P200808190435848' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406461'
                WHERE ordernumber = 'P190808190548210' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406462'
                WHERE ordernumber = 'P200808190718600' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '404646'
                WHERE ordernumber = 'P200808190913787' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '138359'
                WHERE ordernumber = 'P200808191138221' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '384883'
                WHERE ordernumber = 'P190808191155199' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406463'
                WHERE ordernumber = 'P190808191345129' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406463'
                WHERE ordernumber = 'P190808191512389' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406464'
                WHERE ordernumber = 'P190808191728591' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '227730'
                WHERE ordernumber = 'P200808193418165' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '386128'
                WHERE ordernumber = 'P190808193821183' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406469'
                WHERE ordernumber = 'P200808193916298' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '406471'
                WHERE ordernumber = 'P200808194025281' 
            
2024-08-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '82588'
                WHERE ordernumber = 'P200808194733558'