2025-02-12 01:00:02 -- 將會員中心id寫入data-lake
2025-02-12 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-11%';
        
2025-02-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329156'
                WHERE ordernumber = 'P2502110000008' 
            
2025-02-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280382'
                WHERE ordernumber = 'P2502110000009' 
            
2025-02-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455540'
                WHERE ordernumber = 'P2502110000011' 
            
2025-02-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364034'
                WHERE ordernumber = 'P2502110000016' 
            
2025-02-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455542'
                WHERE ordernumber = 'P2502110000017' 
            
2025-02-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397252'
                WHERE ordernumber = 'P2502110000019' 
            
2025-02-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427413'
                WHERE ordernumber = 'P2502110000020' 
            
2025-02-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '135443'
                WHERE ordernumber = 'P2502110000024' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455544'
                WHERE ordernumber = 'P2502110000025' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111810'
                WHERE ordernumber = 'P2502110000026' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245281'
                WHERE ordernumber = 'P2502110000027' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455547'
                WHERE ordernumber = 'P2502110000029' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455546'
                WHERE ordernumber = 'P2502110000030' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P2502110000033' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455545'
                WHERE ordernumber = 'P2502110000036' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421874'
                WHERE ordernumber = 'P2502110000039' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222023'
                WHERE ordernumber = 'P2502110000040' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391678'
                WHERE ordernumber = 'P2502110000042' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400497'
                WHERE ordernumber = 'P2502110000043' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302688'
                WHERE ordernumber = 'P2502110000044' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281545'
                WHERE ordernumber = 'P2502110000047' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P2502110000048' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209597'
                WHERE ordernumber = 'P2502110000049' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380655'
                WHERE ordernumber = 'P2502110000059' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455551'
                WHERE ordernumber = 'P2502110000062' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455554'
                WHERE ordernumber = 'P2502110000063' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455552'
                WHERE ordernumber = 'P2502110000065' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455553'
                WHERE ordernumber = 'P2502110000067' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160964'
                WHERE ordernumber = 'P2502110000070' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118379'
                WHERE ordernumber = 'P2502110000071' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168221'
                WHERE ordernumber = 'P2502110000074' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455552'
                WHERE ordernumber = 'P2502110000075' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227420'
                WHERE ordernumber = 'P2502110000078' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432549'
                WHERE ordernumber = 'P2502110000083' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455558'
                WHERE ordernumber = 'P2502110000084' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218743'
                WHERE ordernumber = 'P2502110000086' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400879'
                WHERE ordernumber = 'P2502110000087' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455558'
                WHERE ordernumber = 'P2502110000089' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364010'
                WHERE ordernumber = 'P2502110000090' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455557'
                WHERE ordernumber = 'P2502110000091' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109641'
                WHERE ordernumber = 'P2502110000092' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399781'
                WHERE ordernumber = 'P2502110000095' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139981'
                WHERE ordernumber = 'P2502110000099' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455562'
                WHERE ordernumber = 'P2502110000100' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455561'
                WHERE ordernumber = 'P2502110000104' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359461'
                WHERE ordernumber = 'P2502110000107' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455561'
                WHERE ordernumber = 'P2502110000109' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304926'
                WHERE ordernumber = 'P2502110000116' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262135'
                WHERE ordernumber = 'P2502110000124' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455563'
                WHERE ordernumber = 'P2502110000125' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101715'
                WHERE ordernumber = 'P2502110000127' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452515'
                WHERE ordernumber = 'P2502110000128' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455393'
                WHERE ordernumber = 'P2502110000131' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455566'
                WHERE ordernumber = 'P2502110000132' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455565'
                WHERE ordernumber = 'P2502110000133' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412721'
                WHERE ordernumber = 'P2502110000135' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455568'
                WHERE ordernumber = 'P2502110000143' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455571'
                WHERE ordernumber = 'P2502110000146' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350086'
                WHERE ordernumber = 'P2502110000147' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273252'
                WHERE ordernumber = 'P2502110000150' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273252'
                WHERE ordernumber = 'P2502110000154' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432637'
                WHERE ordernumber = 'P2502110000156' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125050'
                WHERE ordernumber = 'P2502110000158' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455573'
                WHERE ordernumber = 'P2502110000159' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239388'
                WHERE ordernumber = 'P2502110000161' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160535'
                WHERE ordernumber = 'P2502110000165' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455572'
                WHERE ordernumber = 'P2502110000166' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455577'
                WHERE ordernumber = 'P2502110000169' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455575'
                WHERE ordernumber = 'P2502110000170' 
            
2025-02-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239388'
                WHERE ordernumber = 'P2502110000171' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455579'
                WHERE ordernumber = 'P2502110000173' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455580'
                WHERE ordernumber = 'P2502110000176' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455576'
                WHERE ordernumber = 'P2502110000177' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455577'
                WHERE ordernumber = 'P2502110000179' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455579'
                WHERE ordernumber = 'P2502110000181' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '452216'
                WHERE ordernumber = 'P2502110000183' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2502110000184' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455582'
                WHERE ordernumber = 'P2502110000186' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455584'
                WHERE ordernumber = 'P2502110000187' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455585'
                WHERE ordernumber = 'P2502110000190' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364056'
                WHERE ordernumber = 'P2502110000192' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412484'
                WHERE ordernumber = 'P2502110000193' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289259'
                WHERE ordernumber = 'P2502110000197' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455586'
                WHERE ordernumber = 'P2502110000199' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221611'
                WHERE ordernumber = 'P2502110000201' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305308'
                WHERE ordernumber = 'P2502110000204' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455587'
                WHERE ordernumber = 'P2502110000209' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293433'
                WHERE ordernumber = 'P2502110000210' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455588'
                WHERE ordernumber = 'P2502110000211' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294903'
                WHERE ordernumber = 'P2502110000215' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272843'
                WHERE ordernumber = 'P2502110000216' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455590'
                WHERE ordernumber = 'P2502110000219' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284291'
                WHERE ordernumber = 'P2502110000220' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455590'
                WHERE ordernumber = 'P2502110000226' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455591'
                WHERE ordernumber = 'P2502110000229' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '446831'
                WHERE ordernumber = 'P2502110000238' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455592'
                WHERE ordernumber = 'P2502110000240' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455453'
                WHERE ordernumber = 'P2502110000241' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455453'
                WHERE ordernumber = 'P2502110000245' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455592'
                WHERE ordernumber = 'P2502110000246' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423338'
                WHERE ordernumber = 'P2502110000247' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455593'
                WHERE ordernumber = 'P2502110000249' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455595'
                WHERE ordernumber = 'P2502110000250' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455596'
                WHERE ordernumber = 'P2502110000251' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275822'
                WHERE ordernumber = 'P2502110000259' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455598'
                WHERE ordernumber = 'P2502110000260' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455599'
                WHERE ordernumber = 'P2502110000268' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455600'
                WHERE ordernumber = 'P2502110000273' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455601'
                WHERE ordernumber = 'P2502110000275' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433600'
                WHERE ordernumber = 'P2502110000276' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455603'
                WHERE ordernumber = 'P2502110000279' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455602'
                WHERE ordernumber = 'P2502110000280' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401060'
                WHERE ordernumber = 'P2502110000283' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455605'
                WHERE ordernumber = 'P2502110000292' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455608'
                WHERE ordernumber = 'P2502110000294' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455609'
                WHERE ordernumber = 'P2502110000296' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455611'
                WHERE ordernumber = 'P2502110000307' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455604'
                WHERE ordernumber = 'P2502110000309' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386753'
                WHERE ordernumber = 'P2502110000310' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455612'
                WHERE ordernumber = 'P2502110000312' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306954'
                WHERE ordernumber = 'P2502110000313' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113474'
                WHERE ordernumber = 'P2502110000314' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455543'
                WHERE ordernumber = 'P2502110000315' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384021'
                WHERE ordernumber = 'P2502110000323' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455616'
                WHERE ordernumber = 'P2502110000324' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455614'
                WHERE ordernumber = 'P2502110000325' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455617'
                WHERE ordernumber = 'P2502110000329' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403848'
                WHERE ordernumber = 'P2502110000331' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286011'
                WHERE ordernumber = 'P2502110000332' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455615'
                WHERE ordernumber = 'P2502110000333' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455619'
                WHERE ordernumber = 'P2502110000336' 
            
2025-02-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89055'
                WHERE ordernumber = 'P2502110000339' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '72734'
                WHERE ordernumber = 'P2502110000343' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '7906'
                WHERE ordernumber = 'P2502110000345' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '24'
                WHERE ordernumber = 'P2502110000348' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '64919'
                WHERE ordernumber = 'P2502110000351' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296600'
                WHERE ordernumber = 'P2502110000353' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455621'
                WHERE ordernumber = 'P2502110000356' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455620'
                WHERE ordernumber = 'P2502110000357' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455622'
                WHERE ordernumber = 'P2502110000360' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '259875'
                WHERE ordernumber = 'P2502110000364' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277278'
                WHERE ordernumber = 'P2502110000366' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455623'
                WHERE ordernumber = 'P2502110000373' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455625'
                WHERE ordernumber = 'P2502110000383' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455626'
                WHERE ordernumber = 'P2502110000385' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455627'
                WHERE ordernumber = 'P2502110000388' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304163'
                WHERE ordernumber = 'P2502110000395' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P2502110000400' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455629'
                WHERE ordernumber = 'P2502110000401' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430504'
                WHERE ordernumber = 'P2502110000406' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '165876'
                WHERE ordernumber = 'P2502110000410' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '449713'
                WHERE ordernumber = 'P2502110000413' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374299'
                WHERE ordernumber = 'P2502110000414' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '447324'
                WHERE ordernumber = 'P2502110000417' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455630'
                WHERE ordernumber = 'P2502110000419' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455634'
                WHERE ordernumber = 'P2502110000425' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455635'
                WHERE ordernumber = 'P2502110000426' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378510'
                WHERE ordernumber = 'P2502110000429' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '434802'
                WHERE ordernumber = 'P2502110000435' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455638'
                WHERE ordernumber = 'P2502110000436' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221699'
                WHERE ordernumber = 'P2502110000437' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394025'
                WHERE ordernumber = 'P2502110000438' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '164298'
                WHERE ordernumber = 'P2502110000439' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351835'
                WHERE ordernumber = 'P2502110000440' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '165494'
                WHERE ordernumber = 'P2502110000441' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304163'
                WHERE ordernumber = 'P2502110000447' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304163'
                WHERE ordernumber = 'P2502110000451' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455639'
                WHERE ordernumber = 'P2502110000454' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455640'
                WHERE ordernumber = 'P2502110000455' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '373998'
                WHERE ordernumber = 'P2502110000458' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386428'
                WHERE ordernumber = 'P2502110000462' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455642'
                WHERE ordernumber = 'P2502110000467' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2502110000468' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344293'
                WHERE ordernumber = 'P2502110000469' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455646'
                WHERE ordernumber = 'P2502110000471' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455648'
                WHERE ordernumber = 'P2502110000472' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455645'
                WHERE ordernumber = 'P2502110000473' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455644'
                WHERE ordernumber = 'P2502110000474' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455649'
                WHERE ordernumber = 'P2502110000476' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '209182'
                WHERE ordernumber = 'P2502110000477' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455650'
                WHERE ordernumber = 'P2502110000479' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455647'
                WHERE ordernumber = 'P2502110000480' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455652'
                WHERE ordernumber = 'P2502110000482' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455651'
                WHERE ordernumber = 'P2502110000483' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455653'
                WHERE ordernumber = 'P2502110000485' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298460'
                WHERE ordernumber = 'P2502110000486' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455654'
                WHERE ordernumber = 'P2502110000488' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455607'
                WHERE ordernumber = 'P2502110000489' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455648'
                WHERE ordernumber = 'P2502110000490' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '428803'
                WHERE ordernumber = 'P2502110000492' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455655'
                WHERE ordernumber = 'P2502110000494' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455654'
                WHERE ordernumber = 'P2502110000495' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409729'
                WHERE ordernumber = 'P2502110000496' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455656'
                WHERE ordernumber = 'P2502110000497' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455657'
                WHERE ordernumber = 'P2502110000499' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455658'
                WHERE ordernumber = 'P2502110000501' 
            
2025-02-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '448271'
                WHERE ordernumber = 'P2502110000502' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '348877'
                WHERE ordernumber = 'P2502110000503' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455660'
                WHERE ordernumber = 'P2502110000506' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455659'
                WHERE ordernumber = 'P2502110000507' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358080'
                WHERE ordernumber = 'P2502110000509' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455661'
                WHERE ordernumber = 'P2502110000517' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455663'
                WHERE ordernumber = 'P2502110000518' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455662'
                WHERE ordernumber = 'P2502110000521' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '301887'
                WHERE ordernumber = 'P2502110000526' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '438552'
                WHERE ordernumber = 'P2502110000530' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455666'
                WHERE ordernumber = 'P2502110000532' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '421916'
                WHERE ordernumber = 'P2502110000534' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '96806'
                WHERE ordernumber = 'P2502110000535' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455668'
                WHERE ordernumber = 'P2502110000538' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455669'
                WHERE ordernumber = 'P2502110000542' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '95365'
                WHERE ordernumber = 'P2502110000544' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '452547'
                WHERE ordernumber = 'P2502110000547' 
            
2025-02-12 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455670'
                WHERE ordernumber = 'P2502110000549'