2024-09-26 01:00:01 -- 將會員中心id寫入data-lake
2024-09-26 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-09-25%';
        
2024-09-26 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '368480'
                WHERE ordernumber = 'P420925110336409' 
            
2024-09-26 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '422770'
                WHERE ordernumber = 'P420925110625244' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200925110652517' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421232'
                WHERE ordernumber = 'P420925110745137' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422144'
                WHERE ordernumber = 'P420925111025455' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422771'
                WHERE ordernumber = 'P180925111204308' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422772'
                WHERE ordernumber = 'P200925111309959' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422773'
                WHERE ordernumber = 'P420925111844910' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412135'
                WHERE ordernumber = 'P180925112544248' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238709'
                WHERE ordernumber = 'P200925112932940' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123629'
                WHERE ordernumber = 'P200925113018370' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422776'
                WHERE ordernumber = 'P190925113516355' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367533'
                WHERE ordernumber = 'P190925113624220' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80968'
                WHERE ordernumber = 'P190925113657943' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422775'
                WHERE ordernumber = 'P190925113758990' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422775'
                WHERE ordernumber = 'P190925113815248' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219133'
                WHERE ordernumber = 'P200925114046843' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99780'
                WHERE ordernumber = 'P190925114125597' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352047'
                WHERE ordernumber = 'P190925114158724' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422777'
                WHERE ordernumber = 'P420925114312902' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355358'
                WHERE ordernumber = 'P420925114831730' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401238'
                WHERE ordernumber = 'P190925114940994' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406401'
                WHERE ordernumber = 'P200925115046632' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422778'
                WHERE ordernumber = 'P420925115920632' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422779'
                WHERE ordernumber = 'P190925120025746' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95730'
                WHERE ordernumber = 'P200925120511705' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382414'
                WHERE ordernumber = 'P180925120759645' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366121'
                WHERE ordernumber = 'P180925120845456' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313067'
                WHERE ordernumber = 'P200925121008647' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422780'
                WHERE ordernumber = 'P710925121014535' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '170687'
                WHERE ordernumber = 'P180925121101424' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269531'
                WHERE ordernumber = 'P200925121156253' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104000'
                WHERE ordernumber = 'P200925121249884' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422781'
                WHERE ordernumber = 'P200925121341553' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422782'
                WHERE ordernumber = 'P200925121423161' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422783'
                WHERE ordernumber = 'P180925121655766' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422784'
                WHERE ordernumber = 'P190925121658984' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P420925121850159' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216890'
                WHERE ordernumber = 'P190925122458225' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216890'
                WHERE ordernumber = 'P190925122657196' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422786'
                WHERE ordernumber = 'P180925122704291' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348065'
                WHERE ordernumber = 'P420925123650717' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348065'
                WHERE ordernumber = 'P420925123729523' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422787'
                WHERE ordernumber = 'P200925123801445' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '132129'
                WHERE ordernumber = 'P180925124037123' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422788'
                WHERE ordernumber = 'P200925124403929' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100490'
                WHERE ordernumber = 'P200925124703326' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401513'
                WHERE ordernumber = 'P420925124800746' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422789'
                WHERE ordernumber = 'P180925125432747' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422010'
                WHERE ordernumber = 'P180925125647485' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357163'
                WHERE ordernumber = 'P420925125740518' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257521'
                WHERE ordernumber = 'P180925125820727' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422790'
                WHERE ordernumber = 'P420925125836726' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422144'
                WHERE ordernumber = 'P420925130131346' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422144'
                WHERE ordernumber = 'P420925130327226' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422791'
                WHERE ordernumber = 'P180925130520294' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422792'
                WHERE ordernumber = 'P420925130545933' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '7373'
                WHERE ordernumber = 'P180925130750758' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422793'
                WHERE ordernumber = 'P420925131130680' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422794'
                WHERE ordernumber = 'P180925131249912' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254395'
                WHERE ordernumber = 'P180925131453810' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422795'
                WHERE ordernumber = 'P420925131508905' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310842'
                WHERE ordernumber = 'P180925131628155' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114534'
                WHERE ordernumber = 'P180925131711602' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336984'
                WHERE ordernumber = 'P180925131753348' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343928'
                WHERE ordernumber = 'P200925132155509' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422798'
                WHERE ordernumber = 'P730925132250254' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422800'
                WHERE ordernumber = 'P200925132439917' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422743'
                WHERE ordernumber = 'P200925132548638' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422802'
                WHERE ordernumber = 'P180925133302871' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422803'
                WHERE ordernumber = 'P180925133421358' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422804'
                WHERE ordernumber = 'P730925133725231' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130945'
                WHERE ordernumber = 'P180925133732614' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422806'
                WHERE ordernumber = 'P420925133942395' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394447'
                WHERE ordernumber = 'P180925134226965' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '23370'
                WHERE ordernumber = 'P730925134351510' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422807'
                WHERE ordernumber = 'P180925134804875' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335337'
                WHERE ordernumber = 'P180925134905262' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422808'
                WHERE ordernumber = 'P420925135122634' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P180925135749884' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422810'
                WHERE ordernumber = 'P730925135840263' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218349'
                WHERE ordernumber = 'P180925135854794' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326788'
                WHERE ordernumber = 'P200925140124506' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422811'
                WHERE ordernumber = 'P420925140646972' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422812'
                WHERE ordernumber = 'P180925140828895' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339203'
                WHERE ordernumber = 'P420925141238965' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P630925141406199' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421186'
                WHERE ordernumber = 'P420925141556749' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310745'
                WHERE ordernumber = 'P420925141705354' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422813'
                WHERE ordernumber = 'P180925141732446' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422814'
                WHERE ordernumber = 'P200925141750895' 
            
2024-09-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389962'
                WHERE ordernumber = 'P420925142030775' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213710'
                WHERE ordernumber = 'P730925142033431' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422815'
                WHERE ordernumber = 'P200925142046877' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155902'
                WHERE ordernumber = 'P200925142308306' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401761'
                WHERE ordernumber = 'P200925142544375' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416382'
                WHERE ordernumber = 'P420925142628820' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422813'
                WHERE ordernumber = 'P180925142739728' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403322'
                WHERE ordernumber = 'P420925143156678' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422816'
                WHERE ordernumber = 'P200925143225303' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422816'
                WHERE ordernumber = 'P200925143312855' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315536'
                WHERE ordernumber = 'P200925143557419' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422817'
                WHERE ordernumber = 'P200925143724836' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422818'
                WHERE ordernumber = 'P200925143830792' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346820'
                WHERE ordernumber = 'P180925143832659' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416431'
                WHERE ordernumber = 'P420925143906446' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296804'
                WHERE ordernumber = 'P200925145551699' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247699'
                WHERE ordernumber = 'P200925145708124' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422817'
                WHERE ordernumber = 'P200925145737821' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337747'
                WHERE ordernumber = 'P420925145932590' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422821'
                WHERE ordernumber = 'P180925150112867' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P180925150219315' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379815'
                WHERE ordernumber = 'P420925150324558' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422822'
                WHERE ordernumber = 'P180925150420204' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422823'
                WHERE ordernumber = 'P180925150616789' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422824'
                WHERE ordernumber = 'P180925150728783' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384637'
                WHERE ordernumber = 'P180925150841904' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '4'
                WHERE ordernumber = 'P180925151240703' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412640'
                WHERE ordernumber = 'P180925151326557' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422828'
                WHERE ordernumber = 'P180925151750591' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421881'
                WHERE ordernumber = 'P180925151839327' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100823'
                WHERE ordernumber = 'P200925151910771' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276451'
                WHERE ordernumber = 'P420925152056552' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422826'
                WHERE ordernumber = 'P200925152311970' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422830'
                WHERE ordernumber = 'P180925152324254' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422831'
                WHERE ordernumber = 'P420925152358420' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422833'
                WHERE ordernumber = 'P180925153111588' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93434'
                WHERE ordernumber = 'P710925153427390' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383764'
                WHERE ordernumber = 'P420925153443576' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422826'
                WHERE ordernumber = 'P200925153554766' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422826'
                WHERE ordernumber = 'P200925153610698' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350922'
                WHERE ordernumber = 'P180925153651401' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422835'
                WHERE ordernumber = 'P200925153956937' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422837'
                WHERE ordernumber = 'P200925154149706' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422838'
                WHERE ordernumber = 'P710925154303507' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422839'
                WHERE ordernumber = 'P710925154447168' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225462'
                WHERE ordernumber = 'P180925154824939' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421654'
                WHERE ordernumber = 'P710925154853988' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422834'
                WHERE ordernumber = 'P180925155152458' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422504'
                WHERE ordernumber = 'P200925155216468' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422836'
                WHERE ordernumber = 'P730925155323150' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127878'
                WHERE ordernumber = 'P200925155403207' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422836'
                WHERE ordernumber = 'P730925155443667' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282261'
                WHERE ordernumber = 'P200925155706717' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422841'
                WHERE ordernumber = 'P420925155714219' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289923'
                WHERE ordernumber = 'P180925155737389' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350209'
                WHERE ordernumber = 'P200925155758722' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422842'
                WHERE ordernumber = 'P200925155916652' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422843'
                WHERE ordernumber = 'P200925160022303' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421658'
                WHERE ordernumber = 'P180925160224307' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354161'
                WHERE ordernumber = 'P420925160307120' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411853'
                WHERE ordernumber = 'P710925160345281' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422844'
                WHERE ordernumber = 'P180925160506740' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354161'
                WHERE ordernumber = 'P420925160647855' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411486'
                WHERE ordernumber = 'P200925160814249' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420846'
                WHERE ordernumber = 'P420925161504988' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82120'
                WHERE ordernumber = 'P180925161608132' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422846'
                WHERE ordernumber = 'P180925161802126' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422797'
                WHERE ordernumber = 'P180925162348811' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422797'
                WHERE ordernumber = 'P180925162419218' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172291'
                WHERE ordernumber = 'P180925162654776' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422848'
                WHERE ordernumber = 'P200925162739818' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375470'
                WHERE ordernumber = 'P420925162841238' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422849'
                WHERE ordernumber = 'P200925163315789' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422850'
                WHERE ordernumber = 'P420925163707651' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422851'
                WHERE ordernumber = 'P200925163952728' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422852'
                WHERE ordernumber = 'P420925164323631' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422854'
                WHERE ordernumber = 'P180925165006862' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422853'
                WHERE ordernumber = 'P710925165337619' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422857'
                WHERE ordernumber = 'P420925165632933' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284673'
                WHERE ordernumber = 'P420925165730754' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P420925170038938' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422809'
                WHERE ordernumber = 'P200925170201569' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336956'
                WHERE ordernumber = 'P420925170343722' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400048'
                WHERE ordernumber = 'P200925170411299' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422860'
                WHERE ordernumber = 'P200925170600207' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269812'
                WHERE ordernumber = 'P180925170708981' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422858'
                WHERE ordernumber = 'P710925170917350' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381661'
                WHERE ordernumber = 'P180925170917724' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422861'
                WHERE ordernumber = 'P200925171055836' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422862'
                WHERE ordernumber = 'P200925171536632' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119612'
                WHERE ordernumber = 'P180925171641327' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367443'
                WHERE ordernumber = 'P200925171743767' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422226'
                WHERE ordernumber = 'P420925172117647' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '24700'
                WHERE ordernumber = 'P200925172132263' 
            
2024-09-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422226'
                WHERE ordernumber = 'P420925172204401' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342213'
                WHERE ordernumber = 'P180925172226556' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422226'
                WHERE ordernumber = 'P420925172249688' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422226'
                WHERE ordernumber = 'P420925172336623' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422226'
                WHERE ordernumber = 'P420925172409254' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339296'
                WHERE ordernumber = 'P200925172417912' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387070'
                WHERE ordernumber = 'P200925173100734' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422863'
                WHERE ordernumber = 'P420925173301961' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422864'
                WHERE ordernumber = 'P180925173313868' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343061'
                WHERE ordernumber = 'P180925173357183' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422865'
                WHERE ordernumber = 'P420925173411718' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422866'
                WHERE ordernumber = 'P420925173507746' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422867'
                WHERE ordernumber = 'P420925173601187' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422868'
                WHERE ordernumber = 'P200925173946934' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114042'
                WHERE ordernumber = 'P180925174140513' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322480'
                WHERE ordernumber = 'P180925174215439' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118258'
                WHERE ordernumber = 'P180925174428574' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322480'
                WHERE ordernumber = 'P180925174540392' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422873'
                WHERE ordernumber = 'P420925174952514' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312397'
                WHERE ordernumber = 'P180925175028642' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422874'
                WHERE ordernumber = 'P730925175241191' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422875'
                WHERE ordernumber = 'P180925175411974' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422870'
                WHERE ordernumber = 'P180925175457662' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398151'
                WHERE ordernumber = 'P420925180133288' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422877'
                WHERE ordernumber = 'P180925180902791' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325096'
                WHERE ordernumber = 'P420925181321252' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98005'
                WHERE ordernumber = 'P180925181324805' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422878'
                WHERE ordernumber = 'P420925181422258' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422879'
                WHERE ordernumber = 'P180925181441279' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340592'
                WHERE ordernumber = 'P710925181442538' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238422'
                WHERE ordernumber = 'P180925181701890' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422880'
                WHERE ordernumber = 'P200925181829261' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422881'
                WHERE ordernumber = 'P420925181840192' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339605'
                WHERE ordernumber = 'P420925181930326' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154277'
                WHERE ordernumber = 'P180925182550150' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '52846'
                WHERE ordernumber = 'P180925182907714' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412800'
                WHERE ordernumber = 'P180925182944856' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248386'
                WHERE ordernumber = 'P200925183005342' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422885'
                WHERE ordernumber = 'P180925183136176' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422886'
                WHERE ordernumber = 'P180925183229802' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370273'
                WHERE ordernumber = 'P200925183239555' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422887'
                WHERE ordernumber = 'P710925183526360' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346380'
                WHERE ordernumber = 'P180925183847705' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422888'
                WHERE ordernumber = 'P420925183915880' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133134'
                WHERE ordernumber = 'P180925184021688' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422889'
                WHERE ordernumber = 'P200925184257373' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422890'
                WHERE ordernumber = 'P180925184647619' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422893'
                WHERE ordernumber = 'P180925185025139' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422894'
                WHERE ordernumber = 'P180925185311691' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278845'
                WHERE ordernumber = 'P180925185558193' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422895'
                WHERE ordernumber = 'P180925185734180' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422896'
                WHERE ordernumber = 'P190925185839755' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422573'
                WHERE ordernumber = 'P180925185859396' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415741'
                WHERE ordernumber = 'P200925185913914' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294668'
                WHERE ordernumber = 'P190925185945170' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262360'
                WHERE ordernumber = 'P190925190403190' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422897'
                WHERE ordernumber = 'P200925190528268' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422898'
                WHERE ordernumber = 'P190925190658859' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287203'
                WHERE ordernumber = 'P200925191004616' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422902'
                WHERE ordernumber = 'P190925191314276' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422901'
                WHERE ordernumber = 'P730925191341891' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160301'
                WHERE ordernumber = 'P190925191524486' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110046'
                WHERE ordernumber = 'P200925191527925' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422902'
                WHERE ordernumber = 'P190925191609857' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422901'
                WHERE ordernumber = 'P730925191621940' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422903'
                WHERE ordernumber = 'P200925191750459' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371948'
                WHERE ordernumber = 'P190925191803585' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118853'
                WHERE ordernumber = 'P190925192215519' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422906'
                WHERE ordernumber = 'P190925192329789' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422904'
                WHERE ordernumber = 'P710925192442605' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422910'
                WHERE ordernumber = 'P190925193005774' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422908'
                WHERE ordernumber = 'P730925193044248' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422907'
                WHERE ordernumber = 'P710925193049307' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422911'
                WHERE ordernumber = 'P190925193209309' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329369'
                WHERE ordernumber = 'P200925193352503' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422912'
                WHERE ordernumber = 'P710925193906356' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251465'
                WHERE ordernumber = 'P190925194513702' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422913'
                WHERE ordernumber = 'P710925194634597' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '155767'
                WHERE ordernumber = 'P190925194743362' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386128'
                WHERE ordernumber = 'P190925194935331' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422914'
                WHERE ordernumber = 'P190925195415927' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422915'
                WHERE ordernumber = 'P710925195836215' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142377'
                WHERE ordernumber = 'P730925200614905' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422918'
                WHERE ordernumber = 'P730925203648589' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422920'
                WHERE ordernumber = 'P710925204123514' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422925'
                WHERE ordernumber = 'P710925204728666' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422922'
                WHERE ordernumber = 'P730925204801610' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422923'
                WHERE ordernumber = 'P710925204920344' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422924'
                WHERE ordernumber = 'P710925205044481' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422926'
                WHERE ordernumber = 'P710925205437200' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422927'
                WHERE ordernumber = 'P710925210503725' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422928'
                WHERE ordernumber = 'P710925211449724' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422929'
                WHERE ordernumber = 'P710925211723249' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402920'
                WHERE ordernumber = 'P710925214623253' 
            
2024-09-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422932'
                WHERE ordernumber = 'P710925215511855'