2024-11-26 01:00:01 -- 將會員中心id寫入data-lake
2024-11-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-11-25%';
        
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371641'
                WHERE ordernumber = 'P2411250000162' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407903'
                WHERE ordernumber = 'P2411250000247' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371641'
                WHERE ordernumber = 'P2411250000350' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101878'
                WHERE ordernumber = 'P2411250000412' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346508'
                WHERE ordernumber = 'P2411250000548' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431714'
                WHERE ordernumber = 'P2411250000699' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101878'
                WHERE ordernumber = 'P2411250000716' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241001'
                WHERE ordernumber = 'P2411250001265' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107391'
                WHERE ordernumber = 'P2411250001341' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353814'
                WHERE ordernumber = 'P2411250001432' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431719'
                WHERE ordernumber = 'P2411250001972' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431716'
                WHERE ordernumber = 'P2411250002712' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431716'
                WHERE ordernumber = 'P2411250002847' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431720'
                WHERE ordernumber = 'P2411250002926' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431722'
                WHERE ordernumber = 'P2411250003017' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273479'
                WHERE ordernumber = 'P2411250003125' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431724'
                WHERE ordernumber = 'P2411250003395' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431725'
                WHERE ordernumber = 'P2411250003420' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431728'
                WHERE ordernumber = 'P2411250003654' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431727'
                WHERE ordernumber = 'P2411250003843' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431729'
                WHERE ordernumber = 'P2411250004022' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431729'
                WHERE ordernumber = 'P2411250004239' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239484'
                WHERE ordernumber = 'P2411250004387' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281578'
                WHERE ordernumber = 'P2411250004778' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431731'
                WHERE ordernumber = 'P2411250004921' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97571'
                WHERE ordernumber = 'P2411250005163' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385549'
                WHERE ordernumber = 'P2411250005461' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431730'
                WHERE ordernumber = 'P2411250005759' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341084'
                WHERE ordernumber = 'P2411250005871' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431717'
                WHERE ordernumber = 'P2411250005978' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420112'
                WHERE ordernumber = 'P2411250006027' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431735'
                WHERE ordernumber = 'P2411250006116' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '361271'
                WHERE ordernumber = 'P2411250006343' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431736'
                WHERE ordernumber = 'P2411250006540' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430724'
                WHERE ordernumber = 'P2411250006689' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431737'
                WHERE ordernumber = 'P2411250006740' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339632'
                WHERE ordernumber = 'P2411250006819' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431737'
                WHERE ordernumber = 'P2411250006962' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431738'
                WHERE ordernumber = 'P2411250007048' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232257'
                WHERE ordernumber = 'P2411250007156' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431737'
                WHERE ordernumber = 'P2411250007358' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431742'
                WHERE ordernumber = 'P2411250007541' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431741'
                WHERE ordernumber = 'P2411250007646' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431739'
                WHERE ordernumber = 'P2411250007711' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431740'
                WHERE ordernumber = 'P2411250007861' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401780'
                WHERE ordernumber = 'P2411250008011' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431745'
                WHERE ordernumber = 'P2411250008229' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431747'
                WHERE ordernumber = 'P2411250008352' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431748'
                WHERE ordernumber = 'P2411250008430' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428572'
                WHERE ordernumber = 'P2411250008992' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282403'
                WHERE ordernumber = 'P2411250009047' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P2411250009120' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422297'
                WHERE ordernumber = 'P2411250009262' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294795'
                WHERE ordernumber = 'P2411250009531' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384870'
                WHERE ordernumber = 'P2411250009977' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431753'
                WHERE ordernumber = 'P2411250010142' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431756'
                WHERE ordernumber = 'P2411250010268' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431753'
                WHERE ordernumber = 'P2411250010396' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431757'
                WHERE ordernumber = 'P2411250010737' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429727'
                WHERE ordernumber = 'P2411250010843' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431754'
                WHERE ordernumber = 'P2411250010984' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269225'
                WHERE ordernumber = 'P2411250011029' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337262'
                WHERE ordernumber = 'P2411250011157' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113700'
                WHERE ordernumber = 'P2411250011457' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431759'
                WHERE ordernumber = 'P2411250011586' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431760'
                WHERE ordernumber = 'P2411250011682' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303916'
                WHERE ordernumber = 'P2411250011741' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303916'
                WHERE ordernumber = 'P2411250011968' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81645'
                WHERE ordernumber = 'P2411250012067' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431763'
                WHERE ordernumber = 'P2411250012264' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431761'
                WHERE ordernumber = 'P2411250012330' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431764'
                WHERE ordernumber = 'P2411250012550' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426259'
                WHERE ordernumber = 'P2411250012682' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431771'
                WHERE ordernumber = 'P2411250012832' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246109'
                WHERE ordernumber = 'P2411250012975' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431772'
                WHERE ordernumber = 'P2411250013226' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230102'
                WHERE ordernumber = 'P2411250013480' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431776'
                WHERE ordernumber = 'P2411250013633' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389962'
                WHERE ordernumber = 'P2411250013769' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '226401'
                WHERE ordernumber = 'P2411250013889' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414235'
                WHERE ordernumber = 'P2411250013910' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P2411250014029' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414235'
                WHERE ordernumber = 'P2411250014165' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397894'
                WHERE ordernumber = 'P2411250014454' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431779'
                WHERE ordernumber = 'P2411250014590' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391919'
                WHERE ordernumber = 'P2411250014768' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431780'
                WHERE ordernumber = 'P2411250014822' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '226971'
                WHERE ordernumber = 'P2411250015020' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431709'
                WHERE ordernumber = 'P2411250015544' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240424'
                WHERE ordernumber = 'P2411250015615' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431709'
                WHERE ordernumber = 'P2411250015740' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431780'
                WHERE ordernumber = 'P2411250015817' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286003'
                WHERE ordernumber = 'P2411250015945' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351167'
                WHERE ordernumber = 'P2411250016098' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289789'
                WHERE ordernumber = 'P2411250016152' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431781'
                WHERE ordernumber = 'P2411250016325' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431784'
                WHERE ordernumber = 'P2411250016577' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283084'
                WHERE ordernumber = 'P2411250016674' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111127'
                WHERE ordernumber = 'P2411250016830' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431786'
                WHERE ordernumber = 'P2411250017041' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288143'
                WHERE ordernumber = 'P2411250017125' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431787'
                WHERE ordernumber = 'P2411250017218' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431788'
                WHERE ordernumber = 'P2411250017384' 
            
2024-11-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430854'
                WHERE ordernumber = 'P2411250017447' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431789'
                WHERE ordernumber = 'P2411250017548' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286173'
                WHERE ordernumber = 'P2411250017652' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431791'
                WHERE ordernumber = 'P2411250017725' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431790'
                WHERE ordernumber = 'P2411250017875' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222859'
                WHERE ordernumber = 'P2411250017963' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431796'
                WHERE ordernumber = 'P2411250018121' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258752'
                WHERE ordernumber = 'P2411250018379' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220138'
                WHERE ordernumber = 'P2411250018484' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431795'
                WHERE ordernumber = 'P2411250018687' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389324'
                WHERE ordernumber = 'P2411250018878' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430539'
                WHERE ordernumber = 'P2411250018972' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430539'
                WHERE ordernumber = 'P2411250019039' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431798'
                WHERE ordernumber = 'P2411250019445' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431798'
                WHERE ordernumber = 'P2411250019598' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380672'
                WHERE ordernumber = 'P2411250019663' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125430'
                WHERE ordernumber = 'P2411250019784' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431799'
                WHERE ordernumber = 'P2411250019816' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400643'
                WHERE ordernumber = 'P2411250019910' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352390'
                WHERE ordernumber = 'P2411250020049' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431800'
                WHERE ordernumber = 'P2411250020163' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426125'
                WHERE ordernumber = 'P2411250020212' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431801'
                WHERE ordernumber = 'P2411250020356' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431802'
                WHERE ordernumber = 'P2411250020465' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431803'
                WHERE ordernumber = 'P2411250020586' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431491'
                WHERE ordernumber = 'P2411250021027' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206252'
                WHERE ordernumber = 'P2411250021181' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431805'
                WHERE ordernumber = 'P2411250021234' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430922'
                WHERE ordernumber = 'P2411250021312' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211379'
                WHERE ordernumber = 'P2411250021423' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430231'
                WHERE ordernumber = 'P2411250021599' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420965'
                WHERE ordernumber = 'P2411250021740' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431806'
                WHERE ordernumber = 'P2411250021953' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431807'
                WHERE ordernumber = 'P2411250022095' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81933'
                WHERE ordernumber = 'P2411250022121' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431809'
                WHERE ordernumber = 'P2411250022463' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277054'
                WHERE ordernumber = 'P2411250022536' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P2411250023038' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431812'
                WHERE ordernumber = 'P2411250023161' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431813'
                WHERE ordernumber = 'P2411250023271' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431814'
                WHERE ordernumber = 'P2411250023767' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427562'
                WHERE ordernumber = 'P2411250023913' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408875'
                WHERE ordernumber = 'P2411250024249' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408875'
                WHERE ordernumber = 'P2411250024318' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164530'
                WHERE ordernumber = 'P2411250024675' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431818'
                WHERE ordernumber = 'P2411250024743' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431819'
                WHERE ordernumber = 'P2411250024823' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430987'
                WHERE ordernumber = 'P2411250025241' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118897'
                WHERE ordernumber = 'P2411250025422' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101114'
                WHERE ordernumber = 'P2411250025715' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276353'
                WHERE ordernumber = 'P2411250025950' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269919'
                WHERE ordernumber = 'P2411250026228' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268452'
                WHERE ordernumber = 'P2411250026488' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426863'
                WHERE ordernumber = 'P2411250026587' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103913'
                WHERE ordernumber = 'P2411250027231' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327536'
                WHERE ordernumber = 'P2411250027496' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113423'
                WHERE ordernumber = 'P2411250027662' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276826'
                WHERE ordernumber = 'P2411250027714' 
            
2024-11-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322010'
                WHERE ordernumber = 'P2411250028117'