2025-02-22 01:00:02 -- 將會員中心id寫入data-lake
2025-02-22 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-21%';
        
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440123'
                WHERE ordernumber = 'P2502210000011' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238781'
                WHERE ordernumber = 'P2502210000013' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457263'
                WHERE ordernumber = 'P2502210000014' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301862'
                WHERE ordernumber = 'P2502210000015' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457267'
                WHERE ordernumber = 'P2502210000017' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456301'
                WHERE ordernumber = 'P2502210000018' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313542'
                WHERE ordernumber = 'P2502210000019' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238781'
                WHERE ordernumber = 'P2502210000020' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238781'
                WHERE ordernumber = 'P2502210000022' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '453442'
                WHERE ordernumber = 'P2502210000023' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431276'
                WHERE ordernumber = 'P2502210000028' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457271'
                WHERE ordernumber = 'P2502210000031' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457268'
                WHERE ordernumber = 'P2502210000033' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369290'
                WHERE ordernumber = 'P2502210000036' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457273'
                WHERE ordernumber = 'P2502210000037' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457272'
                WHERE ordernumber = 'P2502210000039' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237172'
                WHERE ordernumber = 'P2502210000040' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99126'
                WHERE ordernumber = 'P2502210000042' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457274'
                WHERE ordernumber = 'P2502210000044' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457270'
                WHERE ordernumber = 'P2502210000048' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276286'
                WHERE ordernumber = 'P2502210000050' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276286'
                WHERE ordernumber = 'P2502210000051' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398705'
                WHERE ordernumber = 'P2502210000052' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258488'
                WHERE ordernumber = 'P2502210000054' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457276'
                WHERE ordernumber = 'P2502210000055' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455858'
                WHERE ordernumber = 'P2502210000056' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457275'
                WHERE ordernumber = 'P2502210000057' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420952'
                WHERE ordernumber = 'P2502210000059' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457272'
                WHERE ordernumber = 'P2502210000060' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457277'
                WHERE ordernumber = 'P2502210000061' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457278'
                WHERE ordernumber = 'P2502210000063' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269457'
                WHERE ordernumber = 'P2502210000064' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457279'
                WHERE ordernumber = 'P2502210000065' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457280'
                WHERE ordernumber = 'P2502210000066' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457281'
                WHERE ordernumber = 'P2502210000067' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457281'
                WHERE ordernumber = 'P2502210000068' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457282'
                WHERE ordernumber = 'P2502210000069' 
            
2025-02-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245656'
                WHERE ordernumber = 'P2502210000070' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457284'
                WHERE ordernumber = 'P2502210000071' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457283'
                WHERE ordernumber = 'P2502210000072' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299220'
                WHERE ordernumber = 'P2502210000074' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65115'
                WHERE ordernumber = 'P2502210000075' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113461'
                WHERE ordernumber = 'P2502210000076' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457286'
                WHERE ordernumber = 'P2502210000078' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457287'
                WHERE ordernumber = 'P2502210000086' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457288'
                WHERE ordernumber = 'P2502210000088' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402022'
                WHERE ordernumber = 'P2502210000090' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456776'
                WHERE ordernumber = 'P2502210000091' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457290'
                WHERE ordernumber = 'P2502210000094' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '447927'
                WHERE ordernumber = 'P2502210000095' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457292'
                WHERE ordernumber = 'P2502210000098' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457291'
                WHERE ordernumber = 'P2502210000099' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457117'
                WHERE ordernumber = 'P2502210000102' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457293'
                WHERE ordernumber = 'P2502210000104' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412177'
                WHERE ordernumber = 'P2502210000105' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239481'
                WHERE ordernumber = 'P2502210000107' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412177'
                WHERE ordernumber = 'P2502210000108' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457294'
                WHERE ordernumber = 'P2502210000110' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457295'
                WHERE ordernumber = 'P2502210000111' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457296'
                WHERE ordernumber = 'P2502210000113' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457297'
                WHERE ordernumber = 'P2502210000118' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P2502210000120' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455936'
                WHERE ordernumber = 'P2502210000126' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251321'
                WHERE ordernumber = 'P2502210000128' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457300'
                WHERE ordernumber = 'P2502210000129' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457299'
                WHERE ordernumber = 'P2502210000130' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420577'
                WHERE ordernumber = 'P2502210000131' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281676'
                WHERE ordernumber = 'P2502210000133' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457300'
                WHERE ordernumber = 'P2502210000136' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101375'
                WHERE ordernumber = 'P2502210000137' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430898'
                WHERE ordernumber = 'P2502210000139' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440035'
                WHERE ordernumber = 'P2502210000159' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457302'
                WHERE ordernumber = 'P2502210000160' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456775'
                WHERE ordernumber = 'P2502210000162' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385033'
                WHERE ordernumber = 'P2502210000164' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93699'
                WHERE ordernumber = 'P2502210000169' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457303'
                WHERE ordernumber = 'P2502210000170' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457302'
                WHERE ordernumber = 'P2502210000171' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431322'
                WHERE ordernumber = 'P2502210000173' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434922'
                WHERE ordernumber = 'P2502210000177' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457305'
                WHERE ordernumber = 'P2502210000179' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457306'
                WHERE ordernumber = 'P2502210000180' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429406'
                WHERE ordernumber = 'P2502210000181' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457307'
                WHERE ordernumber = 'P2502210000186' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457308'
                WHERE ordernumber = 'P2502210000188' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277731'
                WHERE ordernumber = 'P2502210000195' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369274'
                WHERE ordernumber = 'P2502210000198' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457310'
                WHERE ordernumber = 'P2502210000201' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457311'
                WHERE ordernumber = 'P2502210000204' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129975'
                WHERE ordernumber = 'P2502210000208' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457312'
                WHERE ordernumber = 'P2502210000210' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457313'
                WHERE ordernumber = 'P2502210000211' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457315'
                WHERE ordernumber = 'P2502210000212' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457314'
                WHERE ordernumber = 'P2502210000213' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457317'
                WHERE ordernumber = 'P2502210000214' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457316'
                WHERE ordernumber = 'P2502210000215' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457319'
                WHERE ordernumber = 'P2502210000218' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408663'
                WHERE ordernumber = 'P2502210000219' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111677'
                WHERE ordernumber = 'P2502210000220' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P2502210000221' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89560'
                WHERE ordernumber = 'P2502210000223' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457321'
                WHERE ordernumber = 'P2502210000224' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375913'
                WHERE ordernumber = 'P2502210000227' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328429'
                WHERE ordernumber = 'P2502210000228' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457322'
                WHERE ordernumber = 'P2502210000231' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '443994'
                WHERE ordernumber = 'P2502210000234' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457322'
                WHERE ordernumber = 'P2502210000235' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457323'
                WHERE ordernumber = 'P2502210000239' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73276'
                WHERE ordernumber = 'P2502210000240' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239031'
                WHERE ordernumber = 'P2502210000241' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457326'
                WHERE ordernumber = 'P2502210000244' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P2502210000245' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457327'
                WHERE ordernumber = 'P2502210000247' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457325'
                WHERE ordernumber = 'P2502210000249' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457328'
                WHERE ordernumber = 'P2502210000256' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96408'
                WHERE ordernumber = 'P2502210000261' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457330'
                WHERE ordernumber = 'P2502210000262' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '453236'
                WHERE ordernumber = 'P2502210000266' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '453235'
                WHERE ordernumber = 'P2502210000267' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457332'
                WHERE ordernumber = 'P2502210000271' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457333'
                WHERE ordernumber = 'P2502210000273' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455630'
                WHERE ordernumber = 'P2502210000274' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P2502210000278' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457334'
                WHERE ordernumber = 'P2502210000284' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457335'
                WHERE ordernumber = 'P2502210000287' 
            
2025-02-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457336'
                WHERE ordernumber = 'P2502210000290' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344474'
                WHERE ordernumber = 'P2502210000296' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319901'
                WHERE ordernumber = 'P2502210000302' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457337'
                WHERE ordernumber = 'P2502210000303' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238119'
                WHERE ordernumber = 'P2502210000308' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306793'
                WHERE ordernumber = 'P2502210000310' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282292'
                WHERE ordernumber = 'P2502210000311' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306793'
                WHERE ordernumber = 'P2502210000312' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317689'
                WHERE ordernumber = 'P2502210000320' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457338'
                WHERE ordernumber = 'P2502210000321' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457339'
                WHERE ordernumber = 'P2502210000322' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457340'
                WHERE ordernumber = 'P2502210000325' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457342'
                WHERE ordernumber = 'P2502210000328' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99718'
                WHERE ordernumber = 'P2502210000330' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457344'
                WHERE ordernumber = 'P2502210000333' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457343'
                WHERE ordernumber = 'P2502210000335' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457346'
                WHERE ordernumber = 'P2502210000340' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457345'
                WHERE ordernumber = 'P2502210000341' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '152005'
                WHERE ordernumber = 'P2502210000345' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232177'
                WHERE ordernumber = 'P2502210000347' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457348'
                WHERE ordernumber = 'P2502210000348' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457347'
                WHERE ordernumber = 'P2502210000354' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97753'
                WHERE ordernumber = 'P2502210000355' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335809'
                WHERE ordernumber = 'P2502210000358' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457097'
                WHERE ordernumber = 'P2502210000364' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398503'
                WHERE ordernumber = 'P2502210000365' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457350'
                WHERE ordernumber = 'P2502210000368' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379510'
                WHERE ordernumber = 'P2502210000369' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277769'
                WHERE ordernumber = 'P2502210000375' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398503'
                WHERE ordernumber = 'P2502210000376' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457352'
                WHERE ordernumber = 'P2502210000378' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '451143'
                WHERE ordernumber = 'P2502210000379' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457353'
                WHERE ordernumber = 'P2502210000380' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103218'
                WHERE ordernumber = 'P2502210000382' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457355'
                WHERE ordernumber = 'P2502210000385' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457356'
                WHERE ordernumber = 'P2502210000388' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457354'
                WHERE ordernumber = 'P2502210000389' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457359'
                WHERE ordernumber = 'P2502210000396' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457353'
                WHERE ordernumber = 'P2502210000398' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234976'
                WHERE ordernumber = 'P2502210000400' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457357'
                WHERE ordernumber = 'P2502210000401' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456894'
                WHERE ordernumber = 'P2502210000402' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309427'
                WHERE ordernumber = 'P2502210000404' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66828'
                WHERE ordernumber = 'P2502210000405' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457359'
                WHERE ordernumber = 'P2502210000412' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457363'
                WHERE ordernumber = 'P2502210000414' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457362'
                WHERE ordernumber = 'P2502210000418' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279158'
                WHERE ordernumber = 'P2502210000419' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457365'
                WHERE ordernumber = 'P2502210000424' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425619'
                WHERE ordernumber = 'P2502210000425' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457368'
                WHERE ordernumber = 'P2502210000427' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457367'
                WHERE ordernumber = 'P2502210000431' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457361'
                WHERE ordernumber = 'P2502210000432' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457369'
                WHERE ordernumber = 'P2502210000436' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274934'
                WHERE ordernumber = 'P2502210000444' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301441'
                WHERE ordernumber = 'P2502210000447' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457373'
                WHERE ordernumber = 'P2502210000449' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274934'
                WHERE ordernumber = 'P2502210000450' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398219'
                WHERE ordernumber = 'P2502210000451' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457371'
                WHERE ordernumber = 'P2502210000455' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457370'
                WHERE ordernumber = 'P2502210000460' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457374'
                WHERE ordernumber = 'P2502210000461' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455261'
                WHERE ordernumber = 'P2502210000463' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430755'
                WHERE ordernumber = 'P2502210000465' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457375'
                WHERE ordernumber = 'P2502210000468' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276466'
                WHERE ordernumber = 'P2502210000469' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457377'
                WHERE ordernumber = 'P2502210000470' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457376'
                WHERE ordernumber = 'P2502210000477' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457379'
                WHERE ordernumber = 'P2502210000481' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457378'
                WHERE ordernumber = 'P2502210000483' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457380'
                WHERE ordernumber = 'P2502210000484' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114727'
                WHERE ordernumber = 'P2502210000488' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390775'
                WHERE ordernumber = 'P2502210000489' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457381'
                WHERE ordernumber = 'P2502210000497' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219104'
                WHERE ordernumber = 'P2502210000498' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240937'
                WHERE ordernumber = 'P2502210000500' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457383'
                WHERE ordernumber = 'P2502210000504' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455890'
                WHERE ordernumber = 'P2502210000513' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457386'
                WHERE ordernumber = 'P2502210000515' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263276'
                WHERE ordernumber = 'P2502210000519' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313207'
                WHERE ordernumber = 'P2502210000528' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403750'
                WHERE ordernumber = 'P2502210000536' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457019'
                WHERE ordernumber = 'P2502210000537' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456683'
                WHERE ordernumber = 'P2502210000539' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457388'
                WHERE ordernumber = 'P2502210000541' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457389'
                WHERE ordernumber = 'P2502210000542' 
            
2025-02-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457387'
                WHERE ordernumber = 'P2502210000543' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306209'
                WHERE ordernumber = 'P2502210000544' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '171872'
                WHERE ordernumber = 'P2502210000550' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455723'
                WHERE ordernumber = 'P2502210000554' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457391'
                WHERE ordernumber = 'P2502210000558' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457392'
                WHERE ordernumber = 'P2502210000560' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455638'
                WHERE ordernumber = 'P2502210000561' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '376268'
                WHERE ordernumber = 'P2502210000563' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241779'
                WHERE ordernumber = 'P2502210000566' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457394'
                WHERE ordernumber = 'P2502210000567' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406417'
                WHERE ordernumber = 'P2502210000569' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457395'
                WHERE ordernumber = 'P2502210000581' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '49446'
                WHERE ordernumber = 'P2502210000585' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457397'
                WHERE ordernumber = 'P2502210000589' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457398'
                WHERE ordernumber = 'P2502210000595' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100049'
                WHERE ordernumber = 'P2502210000601' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456111'
                WHERE ordernumber = 'P2502210000605' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457400'
                WHERE ordernumber = 'P2502210000606' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457399'
                WHERE ordernumber = 'P2502210000610' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456111'
                WHERE ordernumber = 'P2502210000611' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288448'
                WHERE ordernumber = 'P2502210000614' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457399'
                WHERE ordernumber = 'P2502210000622' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457401'
                WHERE ordernumber = 'P2502210000623' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440156'
                WHERE ordernumber = 'P2502210000631' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296903'
                WHERE ordernumber = 'P2502210000633' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457404'
                WHERE ordernumber = 'P2502210000634' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457402'
                WHERE ordernumber = 'P2502210000635' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457407'
                WHERE ordernumber = 'P2502210000636' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457406'
                WHERE ordernumber = 'P2502210000637' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456896'
                WHERE ordernumber = 'P2502210000638' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '373918'
                WHERE ordernumber = 'P2502210000641' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '162239'
                WHERE ordernumber = 'P2502210000646' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305418'
                WHERE ordernumber = 'P2502210000651' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457408'
                WHERE ordernumber = 'P2502210000653' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283000'
                WHERE ordernumber = 'P2502210000655' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '420582'
                WHERE ordernumber = 'P2502210000656' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403278'
                WHERE ordernumber = 'P2502210000657' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457409'
                WHERE ordernumber = 'P2502210000663' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229034'
                WHERE ordernumber = 'P2502210000668' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457410'
                WHERE ordernumber = 'P2502210000670' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457411'
                WHERE ordernumber = 'P2502210000673' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457412'
                WHERE ordernumber = 'P2502210000674' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457390'
                WHERE ordernumber = 'P2502210000677' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '152691'
                WHERE ordernumber = 'P2502210000683' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457413'
                WHERE ordernumber = 'P2502210000685' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455492'
                WHERE ordernumber = 'P2502210000687' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342773'
                WHERE ordernumber = 'P2502210000689' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347340'
                WHERE ordernumber = 'P2502210000692' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457414'
                WHERE ordernumber = 'P2502210000695' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242519'
                WHERE ordernumber = 'P2502210000700' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383880'
                WHERE ordernumber = 'P2502210000703' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222832'
                WHERE ordernumber = 'P2502210000705' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401951'
                WHERE ordernumber = 'P2502210000709' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384279'
                WHERE ordernumber = 'P2502210000711' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '156328'
                WHERE ordernumber = 'P2502210000712' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457416'
                WHERE ordernumber = 'P2502210000713' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '448573'
                WHERE ordernumber = 'P2502210000715' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457420'
                WHERE ordernumber = 'P2502210000717' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457417'
                WHERE ordernumber = 'P2502210000718' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '171068'
                WHERE ordernumber = 'P2502210000721' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457421'
                WHERE ordernumber = 'P2502210000723' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113772'
                WHERE ordernumber = 'P2502210000724' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457423'
                WHERE ordernumber = 'P2502210000726' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238267'
                WHERE ordernumber = 'P2502210000727' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '429392'
                WHERE ordernumber = 'P2502210000728' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457422'
                WHERE ordernumber = 'P2502210000729' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457418'
                WHERE ordernumber = 'P2502210000732' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457424'
                WHERE ordernumber = 'P2502210000734' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '174963'
                WHERE ordernumber = 'P2502210000736' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457425'
                WHERE ordernumber = 'P2502210000737' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457426'
                WHERE ordernumber = 'P2502210000742' 
            
2025-02-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457427'
                WHERE ordernumber = 'P2502210000743'