2024-11-18 01:00:03 -- 將會員中心id寫入data-lake
2024-11-18 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-11-17%';
        
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430590'
                WHERE ordernumber = 'P2411170001049' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430591'
                WHERE ordernumber = 'P2411170001441' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430592'
                WHERE ordernumber = 'P2411170001671' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430593'
                WHERE ordernumber = 'P2411170001723' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430596'
                WHERE ordernumber = 'P2411170001964' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430597'
                WHERE ordernumber = 'P2411170002396' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430594'
                WHERE ordernumber = 'P2411170002479' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430598'
                WHERE ordernumber = 'P2411170002552' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114895'
                WHERE ordernumber = 'P2411170002737' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405973'
                WHERE ordernumber = 'P2411170002889' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430599'
                WHERE ordernumber = 'P2411170003150' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429761'
                WHERE ordernumber = 'P2411170003225' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254880'
                WHERE ordernumber = 'P2411170003666' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430602'
                WHERE ordernumber = 'P2411170003829' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430601'
                WHERE ordernumber = 'P2411170003985' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '9016'
                WHERE ordernumber = 'P2411170004068' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400722'
                WHERE ordernumber = 'P2411170004144' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430604'
                WHERE ordernumber = 'P2411170004277' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430603'
                WHERE ordernumber = 'P2411170004316' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428898'
                WHERE ordernumber = 'P2411170004740' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430605'
                WHERE ordernumber = 'P2411170005053' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430607'
                WHERE ordernumber = 'P2411170005197' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430606'
                WHERE ordernumber = 'P2411170005262' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430609'
                WHERE ordernumber = 'P2411170005383' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430608'
                WHERE ordernumber = 'P2411170005425' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296398'
                WHERE ordernumber = 'P2411170005560' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406775'
                WHERE ordernumber = 'P2411170005611' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305059'
                WHERE ordernumber = 'P2411170005713' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430611'
                WHERE ordernumber = 'P2411170005879' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430612'
                WHERE ordernumber = 'P2411170005994' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267896'
                WHERE ordernumber = 'P2411170006014' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230473'
                WHERE ordernumber = 'P2411170006258' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430613'
                WHERE ordernumber = 'P2411170006390' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256179'
                WHERE ordernumber = 'P2411170006566' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430614'
                WHERE ordernumber = 'P2411170006654' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284779'
                WHERE ordernumber = 'P2411170006874' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429341'
                WHERE ordernumber = 'P2411170007169' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311642'
                WHERE ordernumber = 'P2411170007285' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385517'
                WHERE ordernumber = 'P2411170007368' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430616'
                WHERE ordernumber = 'P2411170007413' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410686'
                WHERE ordernumber = 'P2411170007732' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316216'
                WHERE ordernumber = 'P2411170007865' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430618'
                WHERE ordernumber = 'P2411170007986' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430620'
                WHERE ordernumber = 'P2411170008039' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430621'
                WHERE ordernumber = 'P2411170008243' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430619'
                WHERE ordernumber = 'P2411170008336' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429966'
                WHERE ordernumber = 'P2411170008748' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426806'
                WHERE ordernumber = 'P2411170008885' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417345'
                WHERE ordernumber = 'P2411170008925' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '49528'
                WHERE ordernumber = 'P2411170009233' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430622'
                WHERE ordernumber = 'P2411170009559' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '176537'
                WHERE ordernumber = 'P2411170009972' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41514'
                WHERE ordernumber = 'P2411170010070' 
            
2024-11-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430623'
                WHERE ordernumber = 'P2411170010273' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430624'
                WHERE ordernumber = 'P2411170010593' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384432'
                WHERE ordernumber = 'P2411170010676' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430626'
                WHERE ordernumber = 'P2411170011076' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379849'
                WHERE ordernumber = 'P2411170011145' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365728'
                WHERE ordernumber = 'P2411170011373' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P2411170011478' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430625'
                WHERE ordernumber = 'P2411170011585' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360338'
                WHERE ordernumber = 'P2411170012061' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430628'
                WHERE ordernumber = 'P2411170012183' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376504'
                WHERE ordernumber = 'P2411170012312' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389128'
                WHERE ordernumber = 'P2411170012536' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302895'
                WHERE ordernumber = 'P2411170012617' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103663'
                WHERE ordernumber = 'P2411170012722' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242234'
                WHERE ordernumber = 'P2411170012843' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310104'
                WHERE ordernumber = 'P2411170012987' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100182'
                WHERE ordernumber = 'P2411170013043' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430629'
                WHERE ordernumber = 'P2411170013431' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430631'
                WHERE ordernumber = 'P2411170013530' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430629'
                WHERE ordernumber = 'P2411170013677' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430630'
                WHERE ordernumber = 'P2411170013783' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396460'
                WHERE ordernumber = 'P2411170014084' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430632'
                WHERE ordernumber = 'P2411170014523' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430634'
                WHERE ordernumber = 'P2411170014998' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298476'
                WHERE ordernumber = 'P2411170015155' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430636'
                WHERE ordernumber = 'P2411170015237' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '195242'
                WHERE ordernumber = 'P2411170015437' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292465'
                WHERE ordernumber = 'P2411170015558' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378238'
                WHERE ordernumber = 'P2411170015672' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393044'
                WHERE ordernumber = 'P2411170015733' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390854'
                WHERE ordernumber = 'P2411170015865' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430637'
                WHERE ordernumber = 'P2411170015922' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430587'
                WHERE ordernumber = 'P2411170016089' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234754'
                WHERE ordernumber = 'P2411170016192' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219323'
                WHERE ordernumber = 'P2411170016282' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '56458'
                WHERE ordernumber = 'P2411170016616' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240424'
                WHERE ordernumber = 'P2411170016853' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252373'
                WHERE ordernumber = 'P2411170016912' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94028'
                WHERE ordernumber = 'P2411170017153' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269796'
                WHERE ordernumber = 'P2411170017436' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389205'
                WHERE ordernumber = 'P2411170017548' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269796'
                WHERE ordernumber = 'P2411170017633' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430641'
                WHERE ordernumber = 'P2411170017759' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315886'
                WHERE ordernumber = 'P2411170017865' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137888'
                WHERE ordernumber = 'P2411170017975' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430642'
                WHERE ordernumber = 'P2411170018023' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P2411170018165' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430643'
                WHERE ordernumber = 'P2411170018214' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430644'
                WHERE ordernumber = 'P2411170018323' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384882'
                WHERE ordernumber = 'P2411170018557' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246245'
                WHERE ordernumber = 'P2411170018622' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430645'
                WHERE ordernumber = 'P2411170018754' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430646'
                WHERE ordernumber = 'P2411170018929' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320950'
                WHERE ordernumber = 'P2411170019089' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430648'
                WHERE ordernumber = 'P2411170019584' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430649'
                WHERE ordernumber = 'P2411170019830' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97591'
                WHERE ordernumber = 'P2411170020022' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388234'
                WHERE ordernumber = 'P2411170020177' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403004'
                WHERE ordernumber = 'P2411170020373' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430652'
                WHERE ordernumber = 'P2411170020459' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430653'
                WHERE ordernumber = 'P2411170020612' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430651'
                WHERE ordernumber = 'P2411170020736' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280100'
                WHERE ordernumber = 'P2411170020910' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '84253'
                WHERE ordernumber = 'P2411170021085' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430183'
                WHERE ordernumber = 'P2411170021267' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319273'
                WHERE ordernumber = 'P2411170021362' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430654'
                WHERE ordernumber = 'P2411170021415' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430655'
                WHERE ordernumber = 'P2411170021546' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430531'
                WHERE ordernumber = 'P2411170021781' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157525'
                WHERE ordernumber = 'P2411170021837' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292263'
                WHERE ordernumber = 'P2411170021918' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393548'
                WHERE ordernumber = 'P2411170022018' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429704'
                WHERE ordernumber = 'P2411170022122' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430657'
                WHERE ordernumber = 'P2411170022290' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430656'
                WHERE ordernumber = 'P2411170022418' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430658'
                WHERE ordernumber = 'P2411170022670' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430660'
                WHERE ordernumber = 'P2411170022827' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324722'
                WHERE ordernumber = 'P2411170022918' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276994'
                WHERE ordernumber = 'P2411170023225' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430663'
                WHERE ordernumber = 'P2411170023347' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430661'
                WHERE ordernumber = 'P2411170023516' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430662'
                WHERE ordernumber = 'P2411170023843' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429723'
                WHERE ordernumber = 'P2411170024169' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430665'
                WHERE ordernumber = 'P2411170024216' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430666'
                WHERE ordernumber = 'P2411170024343' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343014'
                WHERE ordernumber = 'P2411170024444' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430669'
                WHERE ordernumber = 'P2411170024661' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430664'
                WHERE ordernumber = 'P2411170024744' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430668'
                WHERE ordernumber = 'P2411170024998' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430667'
                WHERE ordernumber = 'P2411170025167' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337735'
                WHERE ordernumber = 'P2411170025382' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430671'
                WHERE ordernumber = 'P2411170025697' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430670'
                WHERE ordernumber = 'P2411170025753' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386334'
                WHERE ordernumber = 'P2411170025874' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430672'
                WHERE ordernumber = 'P2411170026063' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430674'
                WHERE ordernumber = 'P2411170026189' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430675'
                WHERE ordernumber = 'P2411170026284' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219550'
                WHERE ordernumber = 'P2411170026354' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262484'
                WHERE ordernumber = 'P2411170026588' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286896'
                WHERE ordernumber = 'P2411170026643' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425173'
                WHERE ordernumber = 'P2411170027048' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240548'
                WHERE ordernumber = 'P2411170027184' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105150'
                WHERE ordernumber = 'P2411170027280' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430676'
                WHERE ordernumber = 'P2411170027340' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430679'
                WHERE ordernumber = 'P2411170027471' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430680'
                WHERE ordernumber = 'P2411170027585' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P2411170027898' 
            
2024-11-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393292'
                WHERE ordernumber = 'P2411170028070' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319552'
                WHERE ordernumber = 'P2411170028180' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387323'
                WHERE ordernumber = 'P2411170028227' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '259709'
                WHERE ordernumber = 'P2411170028616' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '429855'
                WHERE ordernumber = 'P2411170028779' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '209133'
                WHERE ordernumber = 'P2411170028860' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430684'
                WHERE ordernumber = 'P2411170029071' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430685'
                WHERE ordernumber = 'P2411170029318' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299626'
                WHERE ordernumber = 'P2411170029550' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300544'
                WHERE ordernumber = 'P2411170029732' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94067'
                WHERE ordernumber = 'P2411170030210' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430687'
                WHERE ordernumber = 'P2411170030499' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '328218'
                WHERE ordernumber = 'P2411170030614' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '119626'
                WHERE ordernumber = 'P2411170030865' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '119626'
                WHERE ordernumber = 'P2411170031140' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396308'
                WHERE ordernumber = 'P2411170031285' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '200347'
                WHERE ordernumber = 'P2411170031581' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '200347'
                WHERE ordernumber = 'P2411170031723' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430199'
                WHERE ordernumber = 'P2411170031859' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430688'
                WHERE ordernumber = 'P2411170032047' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '428917'
                WHERE ordernumber = 'P2411170032583' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430689'
                WHERE ordernumber = 'P2411170032666' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430690'
                WHERE ordernumber = 'P2411170033065' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430691'
                WHERE ordernumber = 'P2411170033215' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P2411170033618' 
            
2024-11-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430182'
                WHERE ordernumber = 'P2411170033913'