2024-11-14 01:00:02 -- 將會員中心id寫入data-lake
2024-11-14 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-11-13%';
        
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401994'
                WHERE ordernumber = 'P2411130000155' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97525'
                WHERE ordernumber = 'P2411130000356' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P2411130000492' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410706'
                WHERE ordernumber = 'P2411130000514' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97525'
                WHERE ordernumber = 'P2411130000642' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P2411130000762' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430019'
                WHERE ordernumber = 'P2411130000838' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430020'
                WHERE ordernumber = 'P2411130000980' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100490'
                WHERE ordernumber = 'P2411130001048' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376095'
                WHERE ordernumber = 'P2411130001637' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277892'
                WHERE ordernumber = 'P2411130001878' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239481'
                WHERE ordernumber = 'P2411130001990' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100750'
                WHERE ordernumber = 'P2411130002110' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '125819'
                WHERE ordernumber = 'P2411130002215' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395551'
                WHERE ordernumber = 'P2411130002396' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430023'
                WHERE ordernumber = 'P2411130002734' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121245'
                WHERE ordernumber = 'P2411130003112' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430025'
                WHERE ordernumber = 'P2411130003289' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430026'
                WHERE ordernumber = 'P2411130003387' 
            
2024-11-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430024'
                WHERE ordernumber = 'P2411130003418' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430011'
                WHERE ordernumber = 'P2411130003535' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250663'
                WHERE ordernumber = 'P2411130004059' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81433'
                WHERE ordernumber = 'P2411130004137' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275229'
                WHERE ordernumber = 'P2411130004293' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318092'
                WHERE ordernumber = 'P2411130004388' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275229'
                WHERE ordernumber = 'P2411130004621' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234701'
                WHERE ordernumber = 'P2411130004892' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427084'
                WHERE ordernumber = 'P2411130004933' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430030'
                WHERE ordernumber = 'P2411130005051' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430031'
                WHERE ordernumber = 'P2411130005184' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420577'
                WHERE ordernumber = 'P2411130005953' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402523'
                WHERE ordernumber = 'P2411130006178' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214522'
                WHERE ordernumber = 'P2411130006266' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430034'
                WHERE ordernumber = 'P2411130006492' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P2411130006547' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430035'
                WHERE ordernumber = 'P2411130006680' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430037'
                WHERE ordernumber = 'P2411130006746' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417871'
                WHERE ordernumber = 'P2411130006893' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430039'
                WHERE ordernumber = 'P2411130006964' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369330'
                WHERE ordernumber = 'P2411130007011' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245523'
                WHERE ordernumber = 'P2411130007188' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416707'
                WHERE ordernumber = 'P2411130007215' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430042'
                WHERE ordernumber = 'P2411130007323' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430043'
                WHERE ordernumber = 'P2411130007477' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385806'
                WHERE ordernumber = 'P2411130007537' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407903'
                WHERE ordernumber = 'P2411130007821' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430047'
                WHERE ordernumber = 'P2411130007930' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '177494'
                WHERE ordernumber = 'P2411130008067' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430048'
                WHERE ordernumber = 'P2411130008237' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232299'
                WHERE ordernumber = 'P2411130008411' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168905'
                WHERE ordernumber = 'P2411130008531' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430054'
                WHERE ordernumber = 'P2411130008688' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430056'
                WHERE ordernumber = 'P2411130008727' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125430'
                WHERE ordernumber = 'P2411130008850' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430016'
                WHERE ordernumber = 'P2411130008968' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430058'
                WHERE ordernumber = 'P2411130009053' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430057'
                WHERE ordernumber = 'P2411130009263' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98210'
                WHERE ordernumber = 'P2411130009670' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430061'
                WHERE ordernumber = 'P2411130009750' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299439'
                WHERE ordernumber = 'P2411130009868' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P2411130009939' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430061'
                WHERE ordernumber = 'P2411130010059' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390082'
                WHERE ordernumber = 'P2411130010198' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429502'
                WHERE ordernumber = 'P2411130010299' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230309'
                WHERE ordernumber = 'P2411130010410' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74778'
                WHERE ordernumber = 'P2411130010580' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430062'
                WHERE ordernumber = 'P2411130010779' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430063'
                WHERE ordernumber = 'P2411130010898' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430064'
                WHERE ordernumber = 'P2411130011056' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430067'
                WHERE ordernumber = 'P2411130011720' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429913'
                WHERE ordernumber = 'P2411130011894' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422698'
                WHERE ordernumber = 'P2411130011987' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416337'
                WHERE ordernumber = 'P2411130012185' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430071'
                WHERE ordernumber = 'P2411130012277' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430065'
                WHERE ordernumber = 'P2411130012468' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216595'
                WHERE ordernumber = 'P2411130012527' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430072'
                WHERE ordernumber = 'P2411130012880' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316939'
                WHERE ordernumber = 'P2411130013115' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P2411130013390' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409254'
                WHERE ordernumber = 'P2411130013519' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430075'
                WHERE ordernumber = 'P2411130013784' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430076'
                WHERE ordernumber = 'P2411130013828' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102958'
                WHERE ordernumber = 'P2411130014019' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395285'
                WHERE ordernumber = 'P2411130014145' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162606'
                WHERE ordernumber = 'P2411130014251' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430078'
                WHERE ordernumber = 'P2411130014392' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P2411130014437' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95943'
                WHERE ordernumber = 'P2411130014596' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430079'
                WHERE ordernumber = 'P2411130014874' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430081'
                WHERE ordernumber = 'P2411130014973' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430083'
                WHERE ordernumber = 'P2411130015044' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153663'
                WHERE ordernumber = 'P2411130015126' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153663'
                WHERE ordernumber = 'P2411130015275' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222478'
                WHERE ordernumber = 'P2411130015394' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430084'
                WHERE ordernumber = 'P2411130015485' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430085'
                WHERE ordernumber = 'P2411130015555' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430082'
                WHERE ordernumber = 'P2411130015616' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227760'
                WHERE ordernumber = 'P2411130015777' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417993'
                WHERE ordernumber = 'P2411130015930' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430087'
                WHERE ordernumber = 'P2411130016098' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257852'
                WHERE ordernumber = 'P2411130016410' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430089'
                WHERE ordernumber = 'P2411130016588' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430090'
                WHERE ordernumber = 'P2411130016688' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430091'
                WHERE ordernumber = 'P2411130016817' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317572'
                WHERE ordernumber = 'P2411130016981' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275250'
                WHERE ordernumber = 'P2411130017275' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219994'
                WHERE ordernumber = 'P2411130017580' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430092'
                WHERE ordernumber = 'P2411130017610' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401023'
                WHERE ordernumber = 'P2411130018047' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422606'
                WHERE ordernumber = 'P2411130018120' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421885'
                WHERE ordernumber = 'P2411130018237' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371641'
                WHERE ordernumber = 'P2411130018437' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430093'
                WHERE ordernumber = 'P2411130018539' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429959'
                WHERE ordernumber = 'P2411130018775' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221016'
                WHERE ordernumber = 'P2411130018981' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430095'
                WHERE ordernumber = 'P2411130019085' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430096'
                WHERE ordernumber = 'P2411130019167' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430099'
                WHERE ordernumber = 'P2411130019278' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430098'
                WHERE ordernumber = 'P2411130019522' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430101'
                WHERE ordernumber = 'P2411130019719' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341339'
                WHERE ordernumber = 'P2411130020372' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277012'
                WHERE ordernumber = 'P2411130020793' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108803'
                WHERE ordernumber = 'P2411130021267' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430102'
                WHERE ordernumber = 'P2411130021545' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430103'
                WHERE ordernumber = 'P2411130021618' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430105'
                WHERE ordernumber = 'P2411130021935' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430107'
                WHERE ordernumber = 'P2411130022020' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313951'
                WHERE ordernumber = 'P2411130022174' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242008'
                WHERE ordernumber = 'P2411130022317' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278062'
                WHERE ordernumber = 'P2411130022414' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165538'
                WHERE ordernumber = 'P2411130022598' 
            
2024-11-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430109'
                WHERE ordernumber = 'P2411130022664' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419323'
                WHERE ordernumber = 'P2411130023055' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430114'
                WHERE ordernumber = 'P2411130023175' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430116'
                WHERE ordernumber = 'P2411130023332' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407026'
                WHERE ordernumber = 'P2411130023415' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107571'
                WHERE ordernumber = 'P2411130023640' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430118'
                WHERE ordernumber = 'P2411130023893' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430117'
                WHERE ordernumber = 'P2411130023981' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239648'
                WHERE ordernumber = 'P2411130024060' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107571'
                WHERE ordernumber = 'P2411130024146' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430119'
                WHERE ordernumber = 'P2411130024225' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430112'
                WHERE ordernumber = 'P2411130024392' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264502'
                WHERE ordernumber = 'P2411130024468' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430121'
                WHERE ordernumber = 'P2411130024559' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381666'
                WHERE ordernumber = 'P2411130024647' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242028'
                WHERE ordernumber = 'P2411130024762' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426436'
                WHERE ordernumber = 'P2411130024965' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379762'
                WHERE ordernumber = 'P2411130025082' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413656'
                WHERE ordernumber = 'P2411130025590' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355737'
                WHERE ordernumber = 'P2411130025765' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245281'
                WHERE ordernumber = 'P2411130025988' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427846'
                WHERE ordernumber = 'P2411130026116' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430124'
                WHERE ordernumber = 'P2411130026374' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430125'
                WHERE ordernumber = 'P2411130026486' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430124'
                WHERE ordernumber = 'P2411130026525' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351879'
                WHERE ordernumber = 'P2411130026624' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430127'
                WHERE ordernumber = 'P2411130026786' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430126'
                WHERE ordernumber = 'P2411130026956' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430128'
                WHERE ordernumber = 'P2411130027154' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430130'
                WHERE ordernumber = 'P2411130027335' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225907'
                WHERE ordernumber = 'P2411130027428' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315203'
                WHERE ordernumber = 'P2411130027598' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287776'
                WHERE ordernumber = 'P2411130028315' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277516'
                WHERE ordernumber = 'P2411130028559' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430132'
                WHERE ordernumber = 'P2411130028911' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374455'
                WHERE ordernumber = 'P2411130029056' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238938'
                WHERE ordernumber = 'P2411130029127' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319357'
                WHERE ordernumber = 'P2411130029310' 
            
2024-11-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344159'
                WHERE ordernumber = 'P2411130029547'