2024-12-06 01:00:01 -- 將會員中心id寫入data-lake
2024-12-06 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-12-05%';
        
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433299'
                WHERE ordernumber = 'P2412050000313' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '84930'
                WHERE ordernumber = 'P2412050000678' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279535'
                WHERE ordernumber = 'P2412050000766' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279535'
                WHERE ordernumber = 'P2412050000835' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431580'
                WHERE ordernumber = 'P2412050000944' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433292'
                WHERE ordernumber = 'P2412050001033' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287930'
                WHERE ordernumber = 'P2412050001958' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418773'
                WHERE ordernumber = 'P2412050002180' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433300'
                WHERE ordernumber = 'P2412050002248' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404923'
                WHERE ordernumber = 'P2412050002386' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274966'
                WHERE ordernumber = 'P2412050002677' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404923'
                WHERE ordernumber = 'P2412050002768' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162606'
                WHERE ordernumber = 'P2412050002899' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366208'
                WHERE ordernumber = 'P2412050002995' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433301'
                WHERE ordernumber = 'P2412050003155' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162606'
                WHERE ordernumber = 'P2412050003299' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433302'
                WHERE ordernumber = 'P2412050003642' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138293'
                WHERE ordernumber = 'P2412050003723' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433303'
                WHERE ordernumber = 'P2412050003838' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433304'
                WHERE ordernumber = 'P2412050003995' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '125957'
                WHERE ordernumber = 'P2412050004018' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433305'
                WHERE ordernumber = 'P2412050004133' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433306'
                WHERE ordernumber = 'P2412050004278' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353814'
                WHERE ordernumber = 'P2412050004638' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367333'
                WHERE ordernumber = 'P2412050004884' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433309'
                WHERE ordernumber = 'P2412050004946' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241725'
                WHERE ordernumber = 'P2412050005067' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391449'
                WHERE ordernumber = 'P2412050005115' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162907'
                WHERE ordernumber = 'P2412050005264' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121240'
                WHERE ordernumber = 'P2412050005321' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2412050005430' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433312'
                WHERE ordernumber = 'P2412050005593' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279535'
                WHERE ordernumber = 'P2412050005636' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331472'
                WHERE ordernumber = 'P2412050005795' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331472'
                WHERE ordernumber = 'P2412050005823' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2412050005915' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433315'
                WHERE ordernumber = 'P2412050006051' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433310'
                WHERE ordernumber = 'P2412050006154' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433317'
                WHERE ordernumber = 'P2412050006228' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '89467'
                WHERE ordernumber = 'P2412050006573' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100928'
                WHERE ordernumber = 'P2412050006761' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433314'
                WHERE ordernumber = 'P2412050006964' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '202821'
                WHERE ordernumber = 'P2412050007099' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433319'
                WHERE ordernumber = 'P2412050007118' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431970'
                WHERE ordernumber = 'P2412050007211' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313009'
                WHERE ordernumber = 'P2412050007352' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '64255'
                WHERE ordernumber = 'P2412050007495' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433322'
                WHERE ordernumber = 'P2412050007598' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426351'
                WHERE ordernumber = 'P2412050007613' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P2412050007862' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363307'
                WHERE ordernumber = 'P2412050008032' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431346'
                WHERE ordernumber = 'P2412050008195' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346696'
                WHERE ordernumber = 'P2412050008296' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433323'
                WHERE ordernumber = 'P2412050008454' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433324'
                WHERE ordernumber = 'P2412050008532' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '87593'
                WHERE ordernumber = 'P2412050008891' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '87593'
                WHERE ordernumber = 'P2412050009161' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429401'
                WHERE ordernumber = 'P2412050009291' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433329'
                WHERE ordernumber = 'P2412050009488' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '165124'
                WHERE ordernumber = 'P2412050009584' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433326'
                WHERE ordernumber = 'P2412050009625' 
            
2024-12-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433330'
                WHERE ordernumber = 'P2412050009714' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73968'
                WHERE ordernumber = 'P2412050009810' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321876'
                WHERE ordernumber = 'P2412050009996' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433331'
                WHERE ordernumber = 'P2412050010279' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433333'
                WHERE ordernumber = 'P2412050010517' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432326'
                WHERE ordernumber = 'P2412050010676' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433334'
                WHERE ordernumber = 'P2412050010735' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426452'
                WHERE ordernumber = 'P2412050011015' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433337'
                WHERE ordernumber = 'P2412050011295' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291173'
                WHERE ordernumber = 'P2412050011416' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431807'
                WHERE ordernumber = 'P2412050011536' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269685'
                WHERE ordernumber = 'P2412050011641' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433341'
                WHERE ordernumber = 'P2412050011787' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433342'
                WHERE ordernumber = 'P2412050011898' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433343'
                WHERE ordernumber = 'P2412050011985' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423797'
                WHERE ordernumber = 'P2412050012018' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433340'
                WHERE ordernumber = 'P2412050012122' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433344'
                WHERE ordernumber = 'P2412050012232' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256428'
                WHERE ordernumber = 'P2412050012343' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433345'
                WHERE ordernumber = 'P2412050012481' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P2412050012534' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345751'
                WHERE ordernumber = 'P2412050012872' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367988'
                WHERE ordernumber = 'P2412050012933' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345214'
                WHERE ordernumber = 'P2412050013081' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433346'
                WHERE ordernumber = 'P2412050013161' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282420'
                WHERE ordernumber = 'P2412050013235' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419394'
                WHERE ordernumber = 'P2412050013374' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433347'
                WHERE ordernumber = 'P2412050013578' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268787'
                WHERE ordernumber = 'P2412050013610' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165594'
                WHERE ordernumber = 'P2412050013786' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433349'
                WHERE ordernumber = 'P2412050013861' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282484'
                WHERE ordernumber = 'P2412050013984' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433352'
                WHERE ordernumber = 'P2412050014094' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433351'
                WHERE ordernumber = 'P2412050014196' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433353'
                WHERE ordernumber = 'P2412050014396' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433354'
                WHERE ordernumber = 'P2412050014426' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300103'
                WHERE ordernumber = 'P2412050014596' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433354'
                WHERE ordernumber = 'P2412050014653' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433355'
                WHERE ordernumber = 'P2412050014789' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433358'
                WHERE ordernumber = 'P2412050014839' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433359'
                WHERE ordernumber = 'P2412050014988' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433357'
                WHERE ordernumber = 'P2412050015089' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209851'
                WHERE ordernumber = 'P2412050015211' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98869'
                WHERE ordernumber = 'P2412050015555' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433360'
                WHERE ordernumber = 'P2412050015655' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433361'
                WHERE ordernumber = 'P2412050015757' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433362'
                WHERE ordernumber = 'P2412050016045' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433365'
                WHERE ordernumber = 'P2412050016199' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433366'
                WHERE ordernumber = 'P2412050016419' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206353'
                WHERE ordernumber = 'P2412050016558' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372644'
                WHERE ordernumber = 'P2412050016624' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214522'
                WHERE ordernumber = 'P2412050016745' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96031'
                WHERE ordernumber = 'P2412050016812' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277866'
                WHERE ordernumber = 'P2412050016934' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277866'
                WHERE ordernumber = 'P2412050017071' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433368'
                WHERE ordernumber = 'P2412050017480' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139322'
                WHERE ordernumber = 'P2412050017571' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433371'
                WHERE ordernumber = 'P2412050017637' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433369'
                WHERE ordernumber = 'P2412050017730' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433367'
                WHERE ordernumber = 'P2412050017878' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432782'
                WHERE ordernumber = 'P2412050018010' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433374'
                WHERE ordernumber = 'P2412050018197' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433373'
                WHERE ordernumber = 'P2412050018226' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433375'
                WHERE ordernumber = 'P2412050018332' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433379'
                WHERE ordernumber = 'P2412050018765' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433378'
                WHERE ordernumber = 'P2412050018891' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432761'
                WHERE ordernumber = 'P2412050019190' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219797'
                WHERE ordernumber = 'P2412050019336' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99205'
                WHERE ordernumber = 'P2412050019457' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433380'
                WHERE ordernumber = 'P2412050019528' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431177'
                WHERE ordernumber = 'P2412050019693' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257894'
                WHERE ordernumber = 'P2412050019738' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432774'
                WHERE ordernumber = 'P2412050020039' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433385'
                WHERE ordernumber = 'P2412050020170' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301162'
                WHERE ordernumber = 'P2412050020273' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433386'
                WHERE ordernumber = 'P2412050020312' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433387'
                WHERE ordernumber = 'P2412050020459' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432350'
                WHERE ordernumber = 'P2412050020524' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433388'
                WHERE ordernumber = 'P2412050020723' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269495'
                WHERE ordernumber = 'P2412050020885' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219732'
                WHERE ordernumber = 'P2412050020968' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252548'
                WHERE ordernumber = 'P2412050021054' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433389'
                WHERE ordernumber = 'P2412050021123' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433394'
                WHERE ordernumber = 'P2412050021532' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433383'
                WHERE ordernumber = 'P2412050021694' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433396'
                WHERE ordernumber = 'P2412050021927' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433397'
                WHERE ordernumber = 'P2412050022122' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '87593'
                WHERE ordernumber = 'P2412050022257' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433392'
                WHERE ordernumber = 'P2412050022753' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433391'
                WHERE ordernumber = 'P2412050022925' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239058'
                WHERE ordernumber = 'P2412050023012' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213366'
                WHERE ordernumber = 'P2412050023315' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266373'
                WHERE ordernumber = 'P2412050023443' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213366'
                WHERE ordernumber = 'P2412050023598' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305922'
                WHERE ordernumber = 'P2412050024080' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433404'
                WHERE ordernumber = 'P2412050024135' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433402'
                WHERE ordernumber = 'P2412050024229' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433402'
                WHERE ordernumber = 'P2412050024336' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115574'
                WHERE ordernumber = 'P2412050024547' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433407'
                WHERE ordernumber = 'P2412050024780' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429864'
                WHERE ordernumber = 'P2412050025097' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433408'
                WHERE ordernumber = 'P2412050025158' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433410'
                WHERE ordernumber = 'P2412050025234' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433410'
                WHERE ordernumber = 'P2412050025370' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138142'
                WHERE ordernumber = 'P2412050025451' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '52478'
                WHERE ordernumber = 'P2412050025540' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '46166'
                WHERE ordernumber = 'P2412050025684' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433415'
                WHERE ordernumber = 'P2412050025715' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433414'
                WHERE ordernumber = 'P2412050025834' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P2412050026121' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433417'
                WHERE ordernumber = 'P2412050026267' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397016'
                WHERE ordernumber = 'P2412050026344' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206345'
                WHERE ordernumber = 'P2412050026542' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279863'
                WHERE ordernumber = 'P2412050026690' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97572'
                WHERE ordernumber = 'P2412050026849' 
            
2024-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433424'
                WHERE ordernumber = 'P2412050027257' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433425'
                WHERE ordernumber = 'P2412050027420' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433426'
                WHERE ordernumber = 'P2412050027676' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301259'
                WHERE ordernumber = 'P2412050027756' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121695'
                WHERE ordernumber = 'P2412050027873' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433430'
                WHERE ordernumber = 'P2412050028022' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398501'
                WHERE ordernumber = 'P2412050028150' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433431'
                WHERE ordernumber = 'P2412050028214' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433433'
                WHERE ordernumber = 'P2412050028378' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214967'
                WHERE ordernumber = 'P2412050028546' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399585'
                WHERE ordernumber = 'P2412050028666' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426374'
                WHERE ordernumber = 'P2412050028782' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111540'
                WHERE ordernumber = 'P2412050028879' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214633'
                WHERE ordernumber = 'P2412050029170' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433434'
                WHERE ordernumber = 'P2412050029232' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433429'
                WHERE ordernumber = 'P2412050029489' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433429'
                WHERE ordernumber = 'P2412050029591' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289929'
                WHERE ordernumber = 'P2412050029625' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433435'
                WHERE ordernumber = 'P2412050029767' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427196'
                WHERE ordernumber = 'P2412050029888' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433436'
                WHERE ordernumber = 'P2412050029999' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142452'
                WHERE ordernumber = 'P2412050030380' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258843'
                WHERE ordernumber = 'P2412050030527' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142452'
                WHERE ordernumber = 'P2412050030888' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433438'
                WHERE ordernumber = 'P2412050031028' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142452'
                WHERE ordernumber = 'P2412050031140' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276443'
                WHERE ordernumber = 'P2412050031257' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165497'
                WHERE ordernumber = 'P2412050031320' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433440'
                WHERE ordernumber = 'P2412050031497' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105701'
                WHERE ordernumber = 'P2412050031892' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432884'
                WHERE ordernumber = 'P2412050032061' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208702'
                WHERE ordernumber = 'P2412050032272' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339919'
                WHERE ordernumber = 'P2412050032388' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429317'
                WHERE ordernumber = 'P2412050032512' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433442'
                WHERE ordernumber = 'P2412050032644' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318891'
                WHERE ordernumber = 'P2412050032836' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433444'
                WHERE ordernumber = 'P2412050033062' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431821'
                WHERE ordernumber = 'P2412050033381' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244648'
                WHERE ordernumber = 'P2412050033579' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94980'
                WHERE ordernumber = 'P2412050033761' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93104'
                WHERE ordernumber = 'P2412050033827' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239321'
                WHERE ordernumber = 'P2412050033935' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384170'
                WHERE ordernumber = 'P2412050034070' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242789'
                WHERE ordernumber = 'P2412050034137' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433448'
                WHERE ordernumber = 'P2412050034217' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429856'
                WHERE ordernumber = 'P2412050034454' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433450'
                WHERE ordernumber = 'P2412050034530' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275151'
                WHERE ordernumber = 'P2412050034677' 
            
2024-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206592'
                WHERE ordernumber = 'P2412050034768'