2024-12-05 01:00:02 -- 將會員中心id寫入data-lake
2024-12-05 01:00:02 -- 
            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-12-04%';
        
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2412040000374' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382409'
                WHERE ordernumber = 'P2412040000419' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349239'
                WHERE ordernumber = 'P2412040000574' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433127'
                WHERE ordernumber = 'P2412040000617' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '145910'
                WHERE ordernumber = 'P2412040000785' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433128'
                WHERE ordernumber = 'P2412040000827' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P2412040001032' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433115'
                WHERE ordernumber = 'P2412040001214' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433129'
                WHERE ordernumber = 'P2412040001537' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277313'
                WHERE ordernumber = 'P2412040001655' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277313'
                WHERE ordernumber = 'P2412040001727' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94496'
                WHERE ordernumber = 'P2412040001824' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433132'
                WHERE ordernumber = 'P2412040001988' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433131'
                WHERE ordernumber = 'P2412040002112' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277359'
                WHERE ordernumber = 'P2412040002541' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P2412040002651' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2412040003237' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431871'
                WHERE ordernumber = 'P2412040003434' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433136'
                WHERE ordernumber = 'P2412040003582' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433137'
                WHERE ordernumber = 'P2412040003640' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433138'
                WHERE ordernumber = 'P2412040003872' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433141'
                WHERE ordernumber = 'P2412040003928' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433142'
                WHERE ordernumber = 'P2412040004068' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100490'
                WHERE ordernumber = 'P2412040004178' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99620'
                WHERE ordernumber = 'P2412040004284' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248386'
                WHERE ordernumber = 'P2412040004599' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431678'
                WHERE ordernumber = 'P2412040004752' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433140'
                WHERE ordernumber = 'P2412040004880' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433146'
                WHERE ordernumber = 'P2412040004917' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113741'
                WHERE ordernumber = 'P2412040005021' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433145'
                WHERE ordernumber = 'P2412040005117' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433147'
                WHERE ordernumber = 'P2412040005358' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114917'
                WHERE ordernumber = 'P2412040005638' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425278'
                WHERE ordernumber = 'P2412040005750' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276194'
                WHERE ordernumber = 'P2412040005818' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401277'
                WHERE ordernumber = 'P2412040005940' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303674'
                WHERE ordernumber = 'P2412040006089' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288868'
                WHERE ordernumber = 'P2412040006381' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377610'
                WHERE ordernumber = 'P2412040006757' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389260'
                WHERE ordernumber = 'P2412040007135' 
            
2024-12-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433153'
                WHERE ordernumber = 'P2412040007332' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80949'
                WHERE ordernumber = 'P2412040007699' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391919'
                WHERE ordernumber = 'P2412040007782' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431023'
                WHERE ordernumber = 'P2412040007825' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424731'
                WHERE ordernumber = 'P2412040007935' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226571'
                WHERE ordernumber = 'P2412040008029' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412254'
                WHERE ordernumber = 'P2412040008178' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111574'
                WHERE ordernumber = 'P2412040008369' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304163'
                WHERE ordernumber = 'P2412040008957' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433157'
                WHERE ordernumber = 'P2412040009045' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279818'
                WHERE ordernumber = 'P2412040009397' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433158'
                WHERE ordernumber = 'P2412040009480' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425606'
                WHERE ordernumber = 'P2412040009653' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430757'
                WHERE ordernumber = 'P2412040009996' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433163'
                WHERE ordernumber = 'P2412040010295' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431754'
                WHERE ordernumber = 'P2412040010412' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433164'
                WHERE ordernumber = 'P2412040010774' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129579'
                WHERE ordernumber = 'P2412040010882' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392136'
                WHERE ordernumber = 'P2412040011291' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428928'
                WHERE ordernumber = 'P2412040011816' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433168'
                WHERE ordernumber = 'P2412040011916' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273470'
                WHERE ordernumber = 'P2412040012111' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242439'
                WHERE ordernumber = 'P2412040012299' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242439'
                WHERE ordernumber = 'P2412040012350' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433169'
                WHERE ordernumber = 'P2412040012445' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402453'
                WHERE ordernumber = 'P2412040012955' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '42971'
                WHERE ordernumber = 'P2412040013143' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433173'
                WHERE ordernumber = 'P2412040013389' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290965'
                WHERE ordernumber = 'P2412040013569' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430208'
                WHERE ordernumber = 'P2412040013819' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433176'
                WHERE ordernumber = 'P2412040014273' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410211'
                WHERE ordernumber = 'P2412040014340' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433178'
                WHERE ordernumber = 'P2412040014460' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433181'
                WHERE ordernumber = 'P2412040014992' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433182'
                WHERE ordernumber = 'P2412040015070' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428314'
                WHERE ordernumber = 'P2412040015127' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433184'
                WHERE ordernumber = 'P2412040015263' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433185'
                WHERE ordernumber = 'P2412040015460' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433183'
                WHERE ordernumber = 'P2412040015539' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433187'
                WHERE ordernumber = 'P2412040015675' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107098'
                WHERE ordernumber = 'P2412040016032' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433012'
                WHERE ordernumber = 'P2412040016145' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104898'
                WHERE ordernumber = 'P2412040017040' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '24'
                WHERE ordernumber = 'P2412040017120' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392843'
                WHERE ordernumber = 'P2412040017280' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374114'
                WHERE ordernumber = 'P2412040017575' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337510'
                WHERE ordernumber = 'P2412040017626' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433190'
                WHERE ordernumber = 'P2412040017817' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433192'
                WHERE ordernumber = 'P2412040018139' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274934'
                WHERE ordernumber = 'P2412040018255' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413447'
                WHERE ordernumber = 'P2412040018356' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279374'
                WHERE ordernumber = 'P2412040018635' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433196'
                WHERE ordernumber = 'P2412040018737' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433197'
                WHERE ordernumber = 'P2412040018895' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390169'
                WHERE ordernumber = 'P2412040019015' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433200'
                WHERE ordernumber = 'P2412040019172' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433194'
                WHERE ordernumber = 'P2412040019251' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433195'
                WHERE ordernumber = 'P2412040019434' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433201'
                WHERE ordernumber = 'P2412040019515' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275250'
                WHERE ordernumber = 'P2412040020078' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305175'
                WHERE ordernumber = 'P2412040020439' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354648'
                WHERE ordernumber = 'P2412040020684' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433204'
                WHERE ordernumber = 'P2412040020786' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433205'
                WHERE ordernumber = 'P2412040021035' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433206'
                WHERE ordernumber = 'P2412040021379' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316216'
                WHERE ordernumber = 'P2412040021499' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433208'
                WHERE ordernumber = 'P2412040021777' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433214'
                WHERE ordernumber = 'P2412040022059' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256865'
                WHERE ordernumber = 'P2412040022185' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433215'
                WHERE ordernumber = 'P2412040022243' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433216'
                WHERE ordernumber = 'P2412040022467' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433209'
                WHERE ordernumber = 'P2412040022539' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423105'
                WHERE ordernumber = 'P2412040022812' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234843'
                WHERE ordernumber = 'P2412040023135' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433220'
                WHERE ordernumber = 'P2412040023282' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387413'
                WHERE ordernumber = 'P2412040023993' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303531'
                WHERE ordernumber = 'P2412040024069' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394589'
                WHERE ordernumber = 'P2412040024236' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433221'
                WHERE ordernumber = 'P2412040024478' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433223'
                WHERE ordernumber = 'P2412040024754' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427693'
                WHERE ordernumber = 'P2412040024894' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433225'
                WHERE ordernumber = 'P2412040024954' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393292'
                WHERE ordernumber = 'P2412040025237' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433226'
                WHERE ordernumber = 'P2412040025424' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432840'
                WHERE ordernumber = 'P2412040025964' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102863'
                WHERE ordernumber = 'P2412040026022' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433228'
                WHERE ordernumber = 'P2412040026189' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379204'
                WHERE ordernumber = 'P2412040026238' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P2412040026584' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417748'
                WHERE ordernumber = 'P2412040026619' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96578'
                WHERE ordernumber = 'P2412040026762' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432910'
                WHERE ordernumber = 'P2412040026865' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353527'
                WHERE ordernumber = 'P2412040027136' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433233'
                WHERE ordernumber = 'P2412040027214' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433234'
                WHERE ordernumber = 'P2412040027461' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '30556'
                WHERE ordernumber = 'P2412040027845' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433235'
                WHERE ordernumber = 'P2412040027935' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433236'
                WHERE ordernumber = 'P2412040028167' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433233'
                WHERE ordernumber = 'P2412040028375' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433235'
                WHERE ordernumber = 'P2412040028450' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433237'
                WHERE ordernumber = 'P2412040028552' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433238'
                WHERE ordernumber = 'P2412040028644' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433238'
                WHERE ordernumber = 'P2412040028920' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412049'
                WHERE ordernumber = 'P2412040029044' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399585'
                WHERE ordernumber = 'P2412040029171' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433093'
                WHERE ordernumber = 'P2412040029661' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138142'
                WHERE ordernumber = 'P2412040029895' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431883'
                WHERE ordernumber = 'P2412040030085' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430274'
                WHERE ordernumber = 'P2412040030140' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433241'
                WHERE ordernumber = 'P2412040030268' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346957'
                WHERE ordernumber = 'P2412040030376' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433241'
                WHERE ordernumber = 'P2412040030570' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267099'
                WHERE ordernumber = 'P2412040030895' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125233'
                WHERE ordernumber = 'P2412040031030' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125233'
                WHERE ordernumber = 'P2412040031143' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433243'
                WHERE ordernumber = 'P2412040031231' 
            
2024-12-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382014'
                WHERE ordernumber = 'P2412040031381'