2024-07-20 01:00:03 -- 將會員中心id寫入data-lake
2024-07-20 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-07-19%';
        
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401994'
                WHERE ordernumber = 'P420719110128643' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303481'
                WHERE ordernumber = 'P180719110137606' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401994'
                WHERE ordernumber = 'P420719110156300' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401991'
                WHERE ordernumber = 'P180719110206419' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401994'
                WHERE ordernumber = 'P420719110222170' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401998'
                WHERE ordernumber = 'P420719110416425' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400524'
                WHERE ordernumber = 'P200719110453143' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331483'
                WHERE ordernumber = 'P420719110501996' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401999'
                WHERE ordernumber = 'P180719110552570' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124407'
                WHERE ordernumber = 'P180719111128738' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402001'
                WHERE ordernumber = 'P200719111215877' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402002'
                WHERE ordernumber = 'P200719111324237' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402004'
                WHERE ordernumber = 'P180719111530867' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '196393'
                WHERE ordernumber = 'P200719111611818' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137117'
                WHERE ordernumber = 'P180719111638889' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402005'
                WHERE ordernumber = 'P190719111754171' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396619'
                WHERE ordernumber = 'P180719111800676' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '897'
                WHERE ordernumber = 'P180719112352126' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402007'
                WHERE ordernumber = 'P180719112834577' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402008'
                WHERE ordernumber = 'P180719113021415' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339238'
                WHERE ordernumber = 'P180719113530971' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402009'
                WHERE ordernumber = 'P180719113727904' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282647'
                WHERE ordernumber = 'P420719113826656' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97021'
                WHERE ordernumber = 'P200719113909723' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402011'
                WHERE ordernumber = 'P190719113951231' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402012'
                WHERE ordernumber = 'P190719114334890' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402013'
                WHERE ordernumber = 'P200719114403652' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402014'
                WHERE ordernumber = 'P420719114458873' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402008'
                WHERE ordernumber = 'P180719114557374' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402016'
                WHERE ordernumber = 'P420719114614939' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398004'
                WHERE ordernumber = 'P190719114607740' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245453'
                WHERE ordernumber = 'P420719115249576' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102473'
                WHERE ordernumber = 'P180719115934842' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402020'
                WHERE ordernumber = 'P200719120008855' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301992'
                WHERE ordernumber = 'P200719120108477' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402021'
                WHERE ordernumber = 'P180719120444400' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402022'
                WHERE ordernumber = 'P190719120534153' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402024'
                WHERE ordernumber = 'P200719121009424' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402025'
                WHERE ordernumber = 'P180719121333211' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402026'
                WHERE ordernumber = 'P200719121716235' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114516'
                WHERE ordernumber = 'P180719121733182' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275912'
                WHERE ordernumber = 'P180719122040114' 
            
2024-07-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212791'
                WHERE ordernumber = 'P180719122133240' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331120'
                WHERE ordernumber = 'P200719122207733' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314754'
                WHERE ordernumber = 'P420719122251231' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378791'
                WHERE ordernumber = 'P180719122655990' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379578'
                WHERE ordernumber = 'P180719123054400' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '332212'
                WHERE ordernumber = 'P420719123346568' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402030'
                WHERE ordernumber = 'P200719123703233' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402032'
                WHERE ordernumber = 'P200719123828720' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365637'
                WHERE ordernumber = 'P180719123910368' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138130'
                WHERE ordernumber = 'P420719123939287' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308598'
                WHERE ordernumber = 'P200719124116878' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166671'
                WHERE ordernumber = 'P420719124545542' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402033'
                WHERE ordernumber = 'P200719124640356' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382462'
                WHERE ordernumber = 'P190719124929320' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277118'
                WHERE ordernumber = 'P420719125007284' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402034'
                WHERE ordernumber = 'P200719125520733' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402035'
                WHERE ordernumber = 'P200719125904684' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103558'
                WHERE ordernumber = 'P200719130113254' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227301'
                WHERE ordernumber = 'P180719130315757' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103516'
                WHERE ordernumber = 'P190719130513669' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95385'
                WHERE ordernumber = 'P180719131105542' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402037'
                WHERE ordernumber = 'P200719131202347' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131220'
                WHERE ordernumber = 'P190719131359734' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402038'
                WHERE ordernumber = 'P180719131507208' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402037'
                WHERE ordernumber = 'P200719131751936' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387130'
                WHERE ordernumber = 'P200719132752591' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344394'
                WHERE ordernumber = 'P180719133055419' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402040'
                WHERE ordernumber = 'P180719133336652' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402041'
                WHERE ordernumber = 'P420719133401690' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402042'
                WHERE ordernumber = 'P420719133604335' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402043'
                WHERE ordernumber = 'P420719133745548' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200719133746191' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238380'
                WHERE ordernumber = 'P180719133933839' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247115'
                WHERE ordernumber = 'P180719134226289' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258188'
                WHERE ordernumber = 'P180719134724230' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402043'
                WHERE ordernumber = 'P420719134809946' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402047'
                WHERE ordernumber = 'P200719134928868' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402049'
                WHERE ordernumber = 'P420719135138943' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402050'
                WHERE ordernumber = 'P420719135352381' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402051'
                WHERE ordernumber = 'P420719135735691' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374994'
                WHERE ordernumber = 'P420719135924516' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378515'
                WHERE ordernumber = 'P190719140137216' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390112'
                WHERE ordernumber = 'P190719140309906' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383862'
                WHERE ordernumber = 'P190719140534871' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402056'
                WHERE ordernumber = 'P190719140815589' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402053'
                WHERE ordernumber = 'P180719140855741' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396609'
                WHERE ordernumber = 'P180719141448267' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353718'
                WHERE ordernumber = 'P200719142605369' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402058'
                WHERE ordernumber = 'P180719142636739' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323621'
                WHERE ordernumber = 'P200719142902969' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344290'
                WHERE ordernumber = 'P180719143217942' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295539'
                WHERE ordernumber = 'P180719143407412' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323621'
                WHERE ordernumber = 'P200719143518592' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402061'
                WHERE ordernumber = 'P200719144201904' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319423'
                WHERE ordernumber = 'P200719144311200' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395814'
                WHERE ordernumber = 'P630719144432397' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '77602'
                WHERE ordernumber = 'P200719144909234' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233006'
                WHERE ordernumber = 'P420719145312748' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402064'
                WHERE ordernumber = 'P180719145340937' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317709'
                WHERE ordernumber = 'P180719145512383' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402065'
                WHERE ordernumber = 'P420719145524470' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132549'
                WHERE ordernumber = 'P180719145953332' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219239'
                WHERE ordernumber = 'P180719150254142' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239481'
                WHERE ordernumber = 'P180719150658947' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402069'
                WHERE ordernumber = 'P200719150712357' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367890'
                WHERE ordernumber = 'P180719150951699' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294010'
                WHERE ordernumber = 'P200719151115332' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278569'
                WHERE ordernumber = 'P420719151143666' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120218'
                WHERE ordernumber = 'P200719151218818' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402074'
                WHERE ordernumber = 'P420719151436634' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402075'
                WHERE ordernumber = 'P180719152000835' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402074'
                WHERE ordernumber = 'P420719152049794' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356813'
                WHERE ordernumber = 'P420719152202391' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101054'
                WHERE ordernumber = 'P180719153705826' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97110'
                WHERE ordernumber = 'P630719153814385' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287769'
                WHERE ordernumber = 'P200719153932338' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P190719154129831' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402078'
                WHERE ordernumber = 'P180719154137230' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282597'
                WHERE ordernumber = 'P200719154312678' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402079'
                WHERE ordernumber = 'P420719154315286' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402080'
                WHERE ordernumber = 'P420719154810953' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402081'
                WHERE ordernumber = 'P200719154850874' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302190'
                WHERE ordernumber = 'P200719155736725' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274721'
                WHERE ordernumber = 'P180719155855463' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402082'
                WHERE ordernumber = 'P200719160339268' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317842'
                WHERE ordernumber = 'P200719160559747' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400575'
                WHERE ordernumber = 'P420719161132877' 
            
2024-07-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164948'
                WHERE ordernumber = 'P200719161246843' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292228'
                WHERE ordernumber = 'P420719162121761' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278158'
                WHERE ordernumber = 'P200719162523556' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101144'
                WHERE ordernumber = 'P200719162609859' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400868'
                WHERE ordernumber = 'P200719162751885' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400167'
                WHERE ordernumber = 'P180719163008475' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305563'
                WHERE ordernumber = 'P200719163212629' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402086'
                WHERE ordernumber = 'P180719163531923' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402087'
                WHERE ordernumber = 'P200719163654317' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399666'
                WHERE ordernumber = 'P180719163917201' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400618'
                WHERE ordernumber = 'P190719164112463' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402088'
                WHERE ordernumber = 'P180719164352521' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402090'
                WHERE ordernumber = 'P420719164634308' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '163210'
                WHERE ordernumber = 'P200719164921840' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '308242'
                WHERE ordernumber = 'P180719164943690' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '331714'
                WHERE ordernumber = 'P420719165146834' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '126705'
                WHERE ordernumber = 'P180719170221646' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402093'
                WHERE ordernumber = 'P420719170303702' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '126705'
                WHERE ordernumber = 'P180719170343278' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102664'
                WHERE ordernumber = 'P180719170715121' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402094'
                WHERE ordernumber = 'P420719170933155' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219494'
                WHERE ordernumber = 'P180719171157154' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286609'
                WHERE ordernumber = 'P200719171548856' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402096'
                WHERE ordernumber = 'P420719171842683' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402097'
                WHERE ordernumber = 'P180719172313487' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '372783'
                WHERE ordernumber = 'P420719172411646' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396967'
                WHERE ordernumber = 'P190719172432955' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364139'
                WHERE ordernumber = 'P200719172538432' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402100'
                WHERE ordernumber = 'P200719172751585' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128801'
                WHERE ordernumber = 'P420719172844248' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '202620'
                WHERE ordernumber = 'P420719173027266' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390274'
                WHERE ordernumber = 'P180719173156236' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402101'
                WHERE ordernumber = 'P420719173412383' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402103'
                WHERE ordernumber = 'P180719173822407' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343835'
                WHERE ordernumber = 'P420719174050868' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379914'
                WHERE ordernumber = 'P200719174551708' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379914'
                WHERE ordernumber = 'P200719174713454' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346725'
                WHERE ordernumber = 'P180719174817651' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367489'
                WHERE ordernumber = 'P180719175253642' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159063'
                WHERE ordernumber = 'P180719175512447' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402105'
                WHERE ordernumber = 'P200719175703194' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '206878'
                WHERE ordernumber = 'P190719180149501' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402106'
                WHERE ordernumber = 'P420719180234617' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402107'
                WHERE ordernumber = 'P420719180838887' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402109'
                WHERE ordernumber = 'P420719181027256' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402110'
                WHERE ordernumber = 'P180719181109796' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402111'
                WHERE ordernumber = 'P200719181255849' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '206960'
                WHERE ordernumber = 'P180719181526378' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240185'
                WHERE ordernumber = 'P180719181629974' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311443'
                WHERE ordernumber = 'P190719181928229' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '112650'
                WHERE ordernumber = 'P180719182120391' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227681'
                WHERE ordernumber = 'P420719182307778' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402112'
                WHERE ordernumber = 'P200719182400645' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400267'
                WHERE ordernumber = 'P190719182407393' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301616'
                WHERE ordernumber = 'P180719182800995' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402113'
                WHERE ordernumber = 'P180719183100708' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236805'
                WHERE ordernumber = 'P200719183143269' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '157035'
                WHERE ordernumber = 'P200719183500582' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311550'
                WHERE ordernumber = 'P180719183522410' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402115'
                WHERE ordernumber = 'P200719184326336' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254938'
                WHERE ordernumber = 'P630719184401236' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277242'
                WHERE ordernumber = 'P180719184637115' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208927'
                WHERE ordernumber = 'P200719184955848' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '140970'
                WHERE ordernumber = 'P200719185418491' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388063'
                WHERE ordernumber = 'P190719185952890' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217614'
                WHERE ordernumber = 'P190719190242324' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277541'
                WHERE ordernumber = 'P200719190857390' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167388'
                WHERE ordernumber = 'P200719191225351' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159425'
                WHERE ordernumber = 'P200719192024510' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402122'
                WHERE ordernumber = 'P200719192759210' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354085'
                WHERE ordernumber = 'P200719192848537' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102081'
                WHERE ordernumber = 'P190719192909457' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '323791'
                WHERE ordernumber = 'P190719193034960' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280077'
                WHERE ordernumber = 'P190719193755924' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220430'
                WHERE ordernumber = 'P190719194124161' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393125'
                WHERE ordernumber = 'P200719194453753' 
            
2024-07-20 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161876'
                WHERE ordernumber = 'P200719194533291' 
            
2024-07-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '161876'
                WHERE ordernumber = 'P200719194634596' 
            
2024-07-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '199719'
                WHERE ordernumber = 'P190719195441408' 
            
2024-07-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402123'
                WHERE ordernumber = 'P200719195744305' 
            
2024-07-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '289916'
                WHERE ordernumber = 'P630719202226111' 
            
2024-07-20 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P590719215749232'