2025-02-17 01:00:02 -- 將會員中心id寫入data-lake
2025-02-17 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-16%';
        
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377605'
                WHERE ordernumber = 'P2502160000012' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377605'
                WHERE ordernumber = 'P2502160000013' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456303'
                WHERE ordernumber = 'P2502160000017' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456301'
                WHERE ordernumber = 'P2502160000018' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456302'
                WHERE ordernumber = 'P2502160000019' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328588'
                WHERE ordernumber = 'P2502160000020' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105401'
                WHERE ordernumber = 'P2502160000022' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456304'
                WHERE ordernumber = 'P2502160000023' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456305'
                WHERE ordernumber = 'P2502160000024' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456306'
                WHERE ordernumber = 'P2502160000028' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456307'
                WHERE ordernumber = 'P2502160000030' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456308'
                WHERE ordernumber = 'P2502160000032' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405071'
                WHERE ordernumber = 'P2502160000034' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456309'
                WHERE ordernumber = 'P2502160000035' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456310'
                WHERE ordernumber = 'P2502160000036' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456311'
                WHERE ordernumber = 'P2502160000037' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456313'
                WHERE ordernumber = 'P2502160000040' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374877'
                WHERE ordernumber = 'P2502160000042' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456314'
                WHERE ordernumber = 'P2502160000045' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456312'
                WHERE ordernumber = 'P2502160000046' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399262'
                WHERE ordernumber = 'P2502160000048' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330914'
                WHERE ordernumber = 'P2502160000049' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456315'
                WHERE ordernumber = 'P2502160000050' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456316'
                WHERE ordernumber = 'P2502160000051' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456318'
                WHERE ordernumber = 'P2502160000052' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456319'
                WHERE ordernumber = 'P2502160000053' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '442149'
                WHERE ordernumber = 'P2502160000057' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '446913'
                WHERE ordernumber = 'P2502160000058' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456321'
                WHERE ordernumber = 'P2502160000059' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161924'
                WHERE ordernumber = 'P2502160000060' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223873'
                WHERE ordernumber = 'P2502160000061' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389128'
                WHERE ordernumber = 'P2502160000063' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456320'
                WHERE ordernumber = 'P2502160000065' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128720'
                WHERE ordernumber = 'P2502160000066' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456323'
                WHERE ordernumber = 'P2502160000070' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456322'
                WHERE ordernumber = 'P2502160000071' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314292'
                WHERE ordernumber = 'P2502160000072' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456318'
                WHERE ordernumber = 'P2502160000073' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456325'
                WHERE ordernumber = 'P2502160000082' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259036'
                WHERE ordernumber = 'P2502160000083' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275640'
                WHERE ordernumber = 'P2502160000084' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456327'
                WHERE ordernumber = 'P2502160000085' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456332'
                WHERE ordernumber = 'P2502160000091' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456333'
                WHERE ordernumber = 'P2502160000092' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214953'
                WHERE ordernumber = 'P2502160000093' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456330'
                WHERE ordernumber = 'P2502160000094' 
            
2025-02-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456329'
                WHERE ordernumber = 'P2502160000096' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456334'
                WHERE ordernumber = 'P2502160000098' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456335'
                WHERE ordernumber = 'P2502160000099' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '28213'
                WHERE ordernumber = 'P2502160000100' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433842'
                WHERE ordernumber = 'P2502160000101' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456328'
                WHERE ordernumber = 'P2502160000102' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456331'
                WHERE ordernumber = 'P2502160000107' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313331'
                WHERE ordernumber = 'P2502160000108' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456336'
                WHERE ordernumber = 'P2502160000110' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456338'
                WHERE ordernumber = 'P2502160000114' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343265'
                WHERE ordernumber = 'P2502160000118' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456340'
                WHERE ordernumber = 'P2502160000119' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232133'
                WHERE ordernumber = 'P2502160000120' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456342'
                WHERE ordernumber = 'P2502160000123' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456341'
                WHERE ordernumber = 'P2502160000126' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2502160000127' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456337'
                WHERE ordernumber = 'P2502160000128' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456343'
                WHERE ordernumber = 'P2502160000129' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276673'
                WHERE ordernumber = 'P2502160000131' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '65902'
                WHERE ordernumber = 'P2502160000132' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165045'
                WHERE ordernumber = 'P2502160000134' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456344'
                WHERE ordernumber = 'P2502160000137' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302810'
                WHERE ordernumber = 'P2502160000138' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '15675'
                WHERE ordernumber = 'P2502160000139' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456345'
                WHERE ordernumber = 'P2502160000141' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385031'
                WHERE ordernumber = 'P2502160000145' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422293'
                WHERE ordernumber = 'P2502160000153' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456348'
                WHERE ordernumber = 'P2502160000156' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385787'
                WHERE ordernumber = 'P2502160000158' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456347'
                WHERE ordernumber = 'P2502160000160' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456349'
                WHERE ordernumber = 'P2502160000161' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128783'
                WHERE ordernumber = 'P2502160000163' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456351'
                WHERE ordernumber = 'P2502160000166' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456352'
                WHERE ordernumber = 'P2502160000168' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456353'
                WHERE ordernumber = 'P2502160000170' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278811'
                WHERE ordernumber = 'P2502160000172' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456350'
                WHERE ordernumber = 'P2502160000173' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456354'
                WHERE ordernumber = 'P2502160000174' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456356'
                WHERE ordernumber = 'P2502160000175' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456354'
                WHERE ordernumber = 'P2502160000177' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456355'
                WHERE ordernumber = 'P2502160000179' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456359'
                WHERE ordernumber = 'P2502160000180' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456353'
                WHERE ordernumber = 'P2502160000185' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456357'
                WHERE ordernumber = 'P2502160000186' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456363'
                WHERE ordernumber = 'P2502160000190' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456364'
                WHERE ordernumber = 'P2502160000193' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456365'
                WHERE ordernumber = 'P2502160000197' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456360'
                WHERE ordernumber = 'P2502160000200' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456366'
                WHERE ordernumber = 'P2502160000202' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443273'
                WHERE ordernumber = 'P2502160000205' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456367'
                WHERE ordernumber = 'P2502160000206' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456369'
                WHERE ordernumber = 'P2502160000208' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456368'
                WHERE ordernumber = 'P2502160000210' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341741'
                WHERE ordernumber = 'P2502160000211' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422323'
                WHERE ordernumber = 'P2502160000213' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118090'
                WHERE ordernumber = 'P2502160000214' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456371'
                WHERE ordernumber = 'P2502160000216' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295584'
                WHERE ordernumber = 'P2502160000219' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406351'
                WHERE ordernumber = 'P2502160000221' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456370'
                WHERE ordernumber = 'P2502160000222' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372766'
                WHERE ordernumber = 'P2502160000224' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237954'
                WHERE ordernumber = 'P2502160000225' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456372'
                WHERE ordernumber = 'P2502160000226' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280487'
                WHERE ordernumber = 'P2502160000229' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456374'
                WHERE ordernumber = 'P2502160000230' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '443837'
                WHERE ordernumber = 'P2502160000232' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456375'
                WHERE ordernumber = 'P2502160000235' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456376'
                WHERE ordernumber = 'P2502160000238' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456378'
                WHERE ordernumber = 'P2502160000239' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456379'
                WHERE ordernumber = 'P2502160000240' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455015'
                WHERE ordernumber = 'P2502160000241' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95398'
                WHERE ordernumber = 'P2502160000243' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456381'
                WHERE ordernumber = 'P2502160000246' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456380'
                WHERE ordernumber = 'P2502160000250' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456384'
                WHERE ordernumber = 'P2502160000251' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96535'
                WHERE ordernumber = 'P2502160000252' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343703'
                WHERE ordernumber = 'P2502160000253' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456385'
                WHERE ordernumber = 'P2502160000254' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280548'
                WHERE ordernumber = 'P2502160000256' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456377'
                WHERE ordernumber = 'P2502160000258' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160321'
                WHERE ordernumber = 'P2502160000261' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456384'
                WHERE ordernumber = 'P2502160000262' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123911'
                WHERE ordernumber = 'P2502160000263' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388071'
                WHERE ordernumber = 'P2502160000267' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456387'
                WHERE ordernumber = 'P2502160000268' 
            
2025-02-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456386'
                WHERE ordernumber = 'P2502160000270' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456388'
                WHERE ordernumber = 'P2502160000272' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456389'
                WHERE ordernumber = 'P2502160000274' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307192'
                WHERE ordernumber = 'P2502160000276' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '315506'
                WHERE ordernumber = 'P2502160000280' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '36420'
                WHERE ordernumber = 'P2502160000281' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456390'
                WHERE ordernumber = 'P2502160000282' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456391'
                WHERE ordernumber = 'P2502160000285' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456393'
                WHERE ordernumber = 'P2502160000292' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456392'
                WHERE ordernumber = 'P2502160000294' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424444'
                WHERE ordernumber = 'P2502160000301' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '129818'
                WHERE ordernumber = 'P2502160000302' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456395'
                WHERE ordernumber = 'P2502160000304' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456396'
                WHERE ordernumber = 'P2502160000309' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '420842'
                WHERE ordernumber = 'P2502160000310' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390736'
                WHERE ordernumber = 'P2502160000317' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456398'
                WHERE ordernumber = 'P2502160000322' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366156'
                WHERE ordernumber = 'P2502160000324' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424298'
                WHERE ordernumber = 'P2502160000325' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456400'
                WHERE ordernumber = 'P2502160000327' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456399'
                WHERE ordernumber = 'P2502160000329' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455725'
                WHERE ordernumber = 'P2502160000338' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456401'
                WHERE ordernumber = 'P2502160000339' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297835'
                WHERE ordernumber = 'P2502160000340' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425370'
                WHERE ordernumber = 'P2502160000343' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456403'
                WHERE ordernumber = 'P2502160000351' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '413102'
                WHERE ordernumber = 'P2502160000353' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392021'
                WHERE ordernumber = 'P2502160000356' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456404'
                WHERE ordernumber = 'P2502160000357' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '428249'
                WHERE ordernumber = 'P2502160000362' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456407'
                WHERE ordernumber = 'P2502160000365' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456408'
                WHERE ordernumber = 'P2502160000368' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456409'
                WHERE ordernumber = 'P2502160000370' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '250698'
                WHERE ordernumber = 'P2502160000372' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456410'
                WHERE ordernumber = 'P2502160000375' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304749'
                WHERE ordernumber = 'P2502160000376' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278743'
                WHERE ordernumber = 'P2502160000381' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456411'
                WHERE ordernumber = 'P2502160000386' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456415'
                WHERE ordernumber = 'P2502160000387' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456414'
                WHERE ordernumber = 'P2502160000388' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '327879'
                WHERE ordernumber = 'P2502160000389' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456412'
                WHERE ordernumber = 'P2502160000391' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421647'
                WHERE ordernumber = 'P2502160000393' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310383'
                WHERE ordernumber = 'P2502160000394' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456417'
                WHERE ordernumber = 'P2502160000396' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456419'
                WHERE ordernumber = 'P2502160000398' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456418'
                WHERE ordernumber = 'P2502160000399' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456416'
                WHERE ordernumber = 'P2502160000402' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346084'
                WHERE ordernumber = 'P2502160000404' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416899'
                WHERE ordernumber = 'P2502160000405' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456420'
                WHERE ordernumber = 'P2502160000407' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456421'
                WHERE ordernumber = 'P2502160000410' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456422'
                WHERE ordernumber = 'P2502160000412' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456424'
                WHERE ordernumber = 'P2502160000413' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456423'
                WHERE ordernumber = 'P2502160000414' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346084'
                WHERE ordernumber = 'P2502160000416' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '451395'
                WHERE ordernumber = 'P2502160000418' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456426'
                WHERE ordernumber = 'P2502160000419' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '451395'
                WHERE ordernumber = 'P2502160000420' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456425'
                WHERE ordernumber = 'P2502160000421' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '443585'
                WHERE ordernumber = 'P2502160000423' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301855'
                WHERE ordernumber = 'P2502160000425' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456427'
                WHERE ordernumber = 'P2502160000426' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389797'
                WHERE ordernumber = 'P2502160000427' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '428582'
                WHERE ordernumber = 'P2502160000429' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456423'
                WHERE ordernumber = 'P2502160000430' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456428'
                WHERE ordernumber = 'P2502160000431' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '443585'
                WHERE ordernumber = 'P2502160000434' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456430'
                WHERE ordernumber = 'P2502160000436' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456429'
                WHERE ordernumber = 'P2502160000439' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456431'
                WHERE ordernumber = 'P2502160000443' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456432'
                WHERE ordernumber = 'P2502160000444' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456432'
                WHERE ordernumber = 'P2502160000446' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456434'
                WHERE ordernumber = 'P2502160000447' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456347'
                WHERE ordernumber = 'P2502160000449' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456436'
                WHERE ordernumber = 'P2502160000450' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456439'
                WHERE ordernumber = 'P2502160000453' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456437'
                WHERE ordernumber = 'P2502160000454' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456442'
                WHERE ordernumber = 'P2502160000455' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456441'
                WHERE ordernumber = 'P2502160000456' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456438'
                WHERE ordernumber = 'P2502160000457' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440681'
                WHERE ordernumber = 'P2502160000461' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248504'
                WHERE ordernumber = 'P2502160000463' 
            
2025-02-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '441054'
                WHERE ordernumber = 'P2502160000464' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456440'
                WHERE ordernumber = 'P2502160000466' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456444'
                WHERE ordernumber = 'P2502160000467' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456445'
                WHERE ordernumber = 'P2502160000472' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456446'
                WHERE ordernumber = 'P2502160000473' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456447'
                WHERE ordernumber = 'P2502160000474' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456448'
                WHERE ordernumber = 'P2502160000477' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456449'
                WHERE ordernumber = 'P2502160000478' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '381052'
                WHERE ordernumber = 'P2502160000481' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '170040'
                WHERE ordernumber = 'P2502160000483' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '100823'
                WHERE ordernumber = 'P2502160000487' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456453'
                WHERE ordernumber = 'P2502160000489' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456454'
                WHERE ordernumber = 'P2502160000490' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456455'
                WHERE ordernumber = 'P2502160000492' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '434841'
                WHERE ordernumber = 'P2502160000493' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456456'
                WHERE ordernumber = 'P2502160000495' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '277054'
                WHERE ordernumber = 'P2502160000496' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456456'
                WHERE ordernumber = 'P2502160000498' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456457'
                WHERE ordernumber = 'P2502160000499' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456459'
                WHERE ordernumber = 'P2502160000504' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456458'
                WHERE ordernumber = 'P2502160000506' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456461'
                WHERE ordernumber = 'P2502160000508' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456460'
                WHERE ordernumber = 'P2502160000509' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456462'
                WHERE ordernumber = 'P2502160000510' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456451'
                WHERE ordernumber = 'P2502160000516' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456465'
                WHERE ordernumber = 'P2502160000520' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456458'
                WHERE ordernumber = 'P2502160000523' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456467'
                WHERE ordernumber = 'P2502160000526' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '132502'
                WHERE ordernumber = 'P2502160000530' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '251347'
                WHERE ordernumber = 'P2502160000532' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456464'
                WHERE ordernumber = 'P2502160000533' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '426171'
                WHERE ordernumber = 'P2502160000536' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456468'
                WHERE ordernumber = 'P2502160000541' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '139071'
                WHERE ordernumber = 'P2502160000546' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456470'
                WHERE ordernumber = 'P2502160000547' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456230'
                WHERE ordernumber = 'P2502160000548' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '397220'
                WHERE ordernumber = 'P2502160000557' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456473'
                WHERE ordernumber = 'P2502160000560' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456475'
                WHERE ordernumber = 'P2502160000563' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351688'
                WHERE ordernumber = 'P2502160000565' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350776'
                WHERE ordernumber = 'P2502160000567' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456477'
                WHERE ordernumber = 'P2502160000568' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456478'
                WHERE ordernumber = 'P2502160000570' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456480'
                WHERE ordernumber = 'P2502160000578' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358919'
                WHERE ordernumber = 'P2502160000581' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456481'
                WHERE ordernumber = 'P2502160000583' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456482'
                WHERE ordernumber = 'P2502160000588' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '378019'
                WHERE ordernumber = 'P2502160000592' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456484'
                WHERE ordernumber = 'P2502160000594' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456483'
                WHERE ordernumber = 'P2502160000596' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455957'
                WHERE ordernumber = 'P2502160000599' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455957'
                WHERE ordernumber = 'P2502160000600' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456486'
                WHERE ordernumber = 'P2502160000603' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '433867'
                WHERE ordernumber = 'P2502160000604' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456487'
                WHERE ordernumber = 'P2502160000605' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456488'
                WHERE ordernumber = 'P2502160000608' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '427769'
                WHERE ordernumber = 'P2502160000617' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456491'
                WHERE ordernumber = 'P2502160000623' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456495'
                WHERE ordernumber = 'P2502160000632' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456496'
                WHERE ordernumber = 'P2502160000635' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456498'
                WHERE ordernumber = 'P2502160000638' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456499'
                WHERE ordernumber = 'P2502160000637' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '190488'
                WHERE ordernumber = 'P2502160000639' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '289497'
                WHERE ordernumber = 'P2502160000640' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '109429'
                WHERE ordernumber = 'P2502160000642' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '455029'
                WHERE ordernumber = 'P2502160000644' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350355'
                WHERE ordernumber = 'P2502160000646' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456501'
                WHERE ordernumber = 'P2502160000651' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350196'
                WHERE ordernumber = 'P2502160000655' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456503'
                WHERE ordernumber = 'P2502160000658' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456506'
                WHERE ordernumber = 'P2502160000659' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456507'
                WHERE ordernumber = 'P2502160000662' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '111127'
                WHERE ordernumber = 'P2502160000665' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456508'
                WHERE ordernumber = 'P2502160000666' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '432887'
                WHERE ordernumber = 'P2502160000667' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456509'
                WHERE ordernumber = 'P2502160000669' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '389371'
                WHERE ordernumber = 'P2502160000671' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456510'
                WHERE ordernumber = 'P2502160000672' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456511'
                WHERE ordernumber = 'P2502160000673' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456512'
                WHERE ordernumber = 'P2502160000674' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456513'
                WHERE ordernumber = 'P2502160000676' 
            
2025-02-17 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '436379'
                WHERE ordernumber = 'P2502160000678' 
            
2025-02-17 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '316930'
                WHERE ordernumber = 'P2502160000681' 
            
2025-02-17 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '456515'
                WHERE ordernumber = 'P2502160000682' 
            
2025-02-17 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '399286'
                WHERE ordernumber = 'P2502160000689' 
            
2025-02-17 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '189910'
                WHERE ordernumber = 'P2502160000692' 
            
2025-02-17 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '456518'
                WHERE ordernumber = 'P2502160000693'