2025-02-18 01:00:02 -- 將會員中心id寫入data-lake
2025-02-18 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 '2025-02-17%';
        
2025-02-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456558'
                WHERE ordernumber = 'P2502170000007' 
            
2025-02-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456559'
                WHERE ordernumber = 'P2502170000008' 
            
2025-02-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273956'
                WHERE ordernumber = 'P2502170000009' 
            
2025-02-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368589'
                WHERE ordernumber = 'P2502170000011' 
            
2025-02-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95053'
                WHERE ordernumber = 'P2502170000012' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456560'
                WHERE ordernumber = 'P2502170000014' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340480'
                WHERE ordernumber = 'P2502170000016' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164370'
                WHERE ordernumber = 'P2502170000018' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456561'
                WHERE ordernumber = 'P2502170000020' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456562'
                WHERE ordernumber = 'P2502170000024' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2502170000025' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100438'
                WHERE ordernumber = 'P2502170000030' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346551'
                WHERE ordernumber = 'P2502170000033' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422882'
                WHERE ordernumber = 'P2502170000035' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456564'
                WHERE ordernumber = 'P2502170000037' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346571'
                WHERE ordernumber = 'P2502170000040' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456565'
                WHERE ordernumber = 'P2502170000042' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456566'
                WHERE ordernumber = 'P2502170000044' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456567'
                WHERE ordernumber = 'P2502170000045' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412135'
                WHERE ordernumber = 'P2502170000046' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456568'
                WHERE ordernumber = 'P2502170000047' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456569'
                WHERE ordernumber = 'P2502170000051' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P2502170000054' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456571'
                WHERE ordernumber = 'P2502170000058' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243585'
                WHERE ordernumber = 'P2502170000059' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346334'
                WHERE ordernumber = 'P2502170000061' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420789'
                WHERE ordernumber = 'P2502170000062' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456573'
                WHERE ordernumber = 'P2502170000067' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327429'
                WHERE ordernumber = 'P2502170000068' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456574'
                WHERE ordernumber = 'P2502170000069' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291839'
                WHERE ordernumber = 'P2502170000074' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339417'
                WHERE ordernumber = 'P2502170000076' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456577'
                WHERE ordernumber = 'P2502170000080' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236042'
                WHERE ordernumber = 'P2502170000083' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387945'
                WHERE ordernumber = 'P2502170000089' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456570'
                WHERE ordernumber = 'P2502170000091' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456572'
                WHERE ordernumber = 'P2502170000098' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456580'
                WHERE ordernumber = 'P2502170000104' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456581'
                WHERE ordernumber = 'P2502170000110' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456582'
                WHERE ordernumber = 'P2502170000112' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '773'
                WHERE ordernumber = 'P2502170000113' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289356'
                WHERE ordernumber = 'P2502170000116' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456584'
                WHERE ordernumber = 'P2502170000117' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169263'
                WHERE ordernumber = 'P2502170000121' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432709'
                WHERE ordernumber = 'P2502170000123' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349716'
                WHERE ordernumber = 'P2502170000126' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '450552'
                WHERE ordernumber = 'P2502170000127' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456585'
                WHERE ordernumber = 'P2502170000129' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456587'
                WHERE ordernumber = 'P2502170000131' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456588'
                WHERE ordernumber = 'P2502170000134' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409987'
                WHERE ordernumber = 'P2502170000135' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456589'
                WHERE ordernumber = 'P2502170000137' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395964'
                WHERE ordernumber = 'P2502170000138' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93645'
                WHERE ordernumber = 'P2502170000140' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298889'
                WHERE ordernumber = 'P2502170000143' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456590'
                WHERE ordernumber = 'P2502170000147' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454882'
                WHERE ordernumber = 'P2502170000149' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456591'
                WHERE ordernumber = 'P2502170000152' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456592'
                WHERE ordernumber = 'P2502170000154' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456594'
                WHERE ordernumber = 'P2502170000155' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443331'
                WHERE ordernumber = 'P2502170000156' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456595'
                WHERE ordernumber = 'P2502170000158' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456596'
                WHERE ordernumber = 'P2502170000160' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456597'
                WHERE ordernumber = 'P2502170000161' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456599'
                WHERE ordernumber = 'P2502170000162' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P2502170000163' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232631'
                WHERE ordernumber = 'P2502170000170' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456601'
                WHERE ordernumber = 'P2502170000173' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456602'
                WHERE ordernumber = 'P2502170000177' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254125'
                WHERE ordernumber = 'P2502170000180' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210745'
                WHERE ordernumber = 'P2502170000181' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456607'
                WHERE ordernumber = 'P2502170000186' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456605'
                WHERE ordernumber = 'P2502170000188' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456608'
                WHERE ordernumber = 'P2502170000189' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225963'
                WHERE ordernumber = 'P2502170000191' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225963'
                WHERE ordernumber = 'P2502170000193' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383620'
                WHERE ordernumber = 'P2502170000194' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456609'
                WHERE ordernumber = 'P2502170000195' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456611'
                WHERE ordernumber = 'P2502170000199' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456610'
                WHERE ordernumber = 'P2502170000200' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456612'
                WHERE ordernumber = 'P2502170000202' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111171'
                WHERE ordernumber = 'P2502170000203' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456610'
                WHERE ordernumber = 'P2502170000205' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456533'
                WHERE ordernumber = 'P2502170000206' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221607'
                WHERE ordernumber = 'P2502170000214' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455446'
                WHERE ordernumber = 'P2502170000217' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97445'
                WHERE ordernumber = 'P2502170000218' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456615'
                WHERE ordernumber = 'P2502170000219' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456616'
                WHERE ordernumber = 'P2502170000223' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '454020'
                WHERE ordernumber = 'P2502170000226' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456618'
                WHERE ordernumber = 'P2502170000227' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443335'
                WHERE ordernumber = 'P2502170000234' 
            
2025-02-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456620'
                WHERE ordernumber = 'P2502170000236' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456619'
                WHERE ordernumber = 'P2502170000237' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404126'
                WHERE ordernumber = 'P2502170000239' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282424'
                WHERE ordernumber = 'P2502170000240' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131678'
                WHERE ordernumber = 'P2502170000244' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363955'
                WHERE ordernumber = 'P2502170000246' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456623'
                WHERE ordernumber = 'P2502170000248' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307431'
                WHERE ordernumber = 'P2502170000250' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456624'
                WHERE ordernumber = 'P2502170000254' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232766'
                WHERE ordernumber = 'P2502170000255' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456625'
                WHERE ordernumber = 'P2502170000258' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102557'
                WHERE ordernumber = 'P2502170000260' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456627'
                WHERE ordernumber = 'P2502170000263' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456626'
                WHERE ordernumber = 'P2502170000264' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80905'
                WHERE ordernumber = 'P2502170000267' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456629'
                WHERE ordernumber = 'P2502170000276' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453140'
                WHERE ordernumber = 'P2502170000278' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456630'
                WHERE ordernumber = 'P2502170000281' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283039'
                WHERE ordernumber = 'P2502170000282' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456631'
                WHERE ordernumber = 'P2502170000288' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456632'
                WHERE ordernumber = 'P2502170000289' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456633'
                WHERE ordernumber = 'P2502170000295' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456634'
                WHERE ordernumber = 'P2502170000298' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112005'
                WHERE ordernumber = 'P2502170000302' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283039'
                WHERE ordernumber = 'P2502170000304' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326495'
                WHERE ordernumber = 'P2502170000307' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456636'
                WHERE ordernumber = 'P2502170000308' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456637'
                WHERE ordernumber = 'P2502170000309' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121406'
                WHERE ordernumber = 'P2502170000310' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456638'
                WHERE ordernumber = 'P2502170000311' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358895'
                WHERE ordernumber = 'P2502170000315' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456641'
                WHERE ordernumber = 'P2502170000317' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456642'
                WHERE ordernumber = 'P2502170000320' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385082'
                WHERE ordernumber = 'P2502170000322' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456644'
                WHERE ordernumber = 'P2502170000327' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453799'
                WHERE ordernumber = 'P2502170000334' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456646'
                WHERE ordernumber = 'P2502170000336' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456645'
                WHERE ordernumber = 'P2502170000337' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456647'
                WHERE ordernumber = 'P2502170000341' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456649'
                WHERE ordernumber = 'P2502170000343' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104403'
                WHERE ordernumber = 'P2502170000345' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456648'
                WHERE ordernumber = 'P2502170000348' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456652'
                WHERE ordernumber = 'P2502170000353' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341146'
                WHERE ordernumber = 'P2502170000363' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456655'
                WHERE ordernumber = 'P2502170000366' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456651'
                WHERE ordernumber = 'P2502170000367' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456654'
                WHERE ordernumber = 'P2502170000370' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456656'
                WHERE ordernumber = 'P2502170000371' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219796'
                WHERE ordernumber = 'P2502170000372' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112014'
                WHERE ordernumber = 'P2502170000373' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456657'
                WHERE ordernumber = 'P2502170000375' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456658'
                WHERE ordernumber = 'P2502170000377' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264712'
                WHERE ordernumber = 'P2502170000379' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293946'
                WHERE ordernumber = 'P2502170000383' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456659'
                WHERE ordernumber = 'P2502170000384' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455296'
                WHERE ordernumber = 'P2502170000388' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305081'
                WHERE ordernumber = 'P2502170000389' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456661'
                WHERE ordernumber = 'P2502170000392' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456603'
                WHERE ordernumber = 'P2502170000393' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456660'
                WHERE ordernumber = 'P2502170000394' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456662'
                WHERE ordernumber = 'P2502170000396' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278973'
                WHERE ordernumber = 'P2502170000401' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456651'
                WHERE ordernumber = 'P2502170000402' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456664'
                WHERE ordernumber = 'P2502170000403' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387556'
                WHERE ordernumber = 'P2502170000404' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456665'
                WHERE ordernumber = 'P2502170000405' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358764'
                WHERE ordernumber = 'P2502170000406' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358764'
                WHERE ordernumber = 'P2502170000408' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456666'
                WHERE ordernumber = 'P2502170000409' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '451976'
                WHERE ordernumber = 'P2502170000410' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456667'
                WHERE ordernumber = 'P2502170000414' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456668'
                WHERE ordernumber = 'P2502170000415' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432637'
                WHERE ordernumber = 'P2502170000418' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456670'
                WHERE ordernumber = 'P2502170000419' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456669'
                WHERE ordernumber = 'P2502170000420' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418858'
                WHERE ordernumber = 'P2502170000425' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378026'
                WHERE ordernumber = 'P2502170000426' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96428'
                WHERE ordernumber = 'P2502170000427' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356393'
                WHERE ordernumber = 'P2502170000428' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456671'
                WHERE ordernumber = 'P2502170000429' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96157'
                WHERE ordernumber = 'P2502170000432' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432196'
                WHERE ordernumber = 'P2502170000438' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456673'
                WHERE ordernumber = 'P2502170000444' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456675'
                WHERE ordernumber = 'P2502170000447' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456675'
                WHERE ordernumber = 'P2502170000448' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456676'
                WHERE ordernumber = 'P2502170000450' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159563'
                WHERE ordernumber = 'P2502170000453' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456677'
                WHERE ordernumber = 'P2502170000457' 
            
2025-02-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456679'
                WHERE ordernumber = 'P2502170000458' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '91022'
                WHERE ordernumber = 'P2502170000460' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456678'
                WHERE ordernumber = 'P2502170000461' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160711'
                WHERE ordernumber = 'P2502170000467' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456680'
                WHERE ordernumber = 'P2502170000469' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389797'
                WHERE ordernumber = 'P2502170000470' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275250'
                WHERE ordernumber = 'P2502170000471' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456684'
                WHERE ordernumber = 'P2502170000472' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456683'
                WHERE ordernumber = 'P2502170000473' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456684'
                WHERE ordernumber = 'P2502170000474' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456685'
                WHERE ordernumber = 'P2502170000476' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456686'
                WHERE ordernumber = 'P2502170000477' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347040'
                WHERE ordernumber = 'P2502170000478' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219936'
                WHERE ordernumber = 'P2502170000480' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456688'
                WHERE ordernumber = 'P2502170000481' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339338'
                WHERE ordernumber = 'P2502170000484' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456689'
                WHERE ordernumber = 'P2502170000485' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426099'
                WHERE ordernumber = 'P2502170000486' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456690'
                WHERE ordernumber = 'P2502170000489' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '453386'
                WHERE ordernumber = 'P2502170000491' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456692'
                WHERE ordernumber = 'P2502170000492' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456693'
                WHERE ordernumber = 'P2502170000499' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456694'
                WHERE ordernumber = 'P2502170000501' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '428538'
                WHERE ordernumber = 'P2502170000503' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456695'
                WHERE ordernumber = 'P2502170000504' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159481'
                WHERE ordernumber = 'P2502170000508' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '159481'
                WHERE ordernumber = 'P2502170000511' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '110046'
                WHERE ordernumber = 'P2502170000513' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456697'
                WHERE ordernumber = 'P2502170000515' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455744'
                WHERE ordernumber = 'P2502170000517' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456699'
                WHERE ordernumber = 'P2502170000519' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456698'
                WHERE ordernumber = 'P2502170000520' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399550'
                WHERE ordernumber = 'P2502170000522' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98228'
                WHERE ordernumber = 'P2502170000526' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232217'
                WHERE ordernumber = 'P2502170000529' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408784'
                WHERE ordernumber = 'P2502170000530' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '308789'
                WHERE ordernumber = 'P2502170000534' 
            
2025-02-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P2502170000535'