2025-02-19 01:00:01 -- 將會員中心id寫入data-lake
2025-02-19 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2025-02-18%';
        
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245532'
                WHERE ordernumber = 'P2502180000011' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343510'
                WHERE ordernumber = 'P2502180000015' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314044'
                WHERE ordernumber = 'P2502180000017' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456735'
                WHERE ordernumber = 'P2502180000019' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2502180000022' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456736'
                WHERE ordernumber = 'P2502180000023' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456737'
                WHERE ordernumber = 'P2502180000024' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456739'
                WHERE ordernumber = 'P2502180000027' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456740'
                WHERE ordernumber = 'P2502180000028' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '455694'
                WHERE ordernumber = 'P2502180000029' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '171098'
                WHERE ordernumber = 'P2502180000031' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456742'
                WHERE ordernumber = 'P2502180000032' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315315'
                WHERE ordernumber = 'P2502180000033' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348885'
                WHERE ordernumber = 'P2502180000037' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '448953'
                WHERE ordernumber = 'P2502180000039' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251899'
                WHERE ordernumber = 'P2502180000042' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456747'
                WHERE ordernumber = 'P2502180000045' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456749'
                WHERE ordernumber = 'P2502180000047' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314867'
                WHERE ordernumber = 'P2502180000049' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456744'
                WHERE ordernumber = 'P2502180000053' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342315'
                WHERE ordernumber = 'P2502180000054' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94924'
                WHERE ordernumber = 'P2502180000056' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435704'
                WHERE ordernumber = 'P2502180000057' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '452617'
                WHERE ordernumber = 'P2502180000058' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P2502180000064' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P2502180000066' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456751'
                WHERE ordernumber = 'P2502180000067' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243585'
                WHERE ordernumber = 'P2502180000068' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '321976'
                WHERE ordernumber = 'P2502180000069' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456753'
                WHERE ordernumber = 'P2502180000070' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456752'
                WHERE ordernumber = 'P2502180000072' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429813'
                WHERE ordernumber = 'P2502180000073' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P2502180000074' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389786'
                WHERE ordernumber = 'P2502180000075' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P2502180000076' 
            
2025-02-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251967'
                WHERE ordernumber = 'P2502180000077' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269289'
                WHERE ordernumber = 'P2502180000078' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456758'
                WHERE ordernumber = 'P2502180000082' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '120323'
                WHERE ordernumber = 'P2502180000083' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367376'
                WHERE ordernumber = 'P2502180000084' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456759'
                WHERE ordernumber = 'P2502180000085' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327936'
                WHERE ordernumber = 'P2502180000087' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456760'
                WHERE ordernumber = 'P2502180000088' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456500'
                WHERE ordernumber = 'P2502180000089' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456690'
                WHERE ordernumber = 'P2502180000090' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355995'
                WHERE ordernumber = 'P2502180000093' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96628'
                WHERE ordernumber = 'P2502180000094' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456762'
                WHERE ordernumber = 'P2502180000095' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396454'
                WHERE ordernumber = 'P2502180000096' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '452555'
                WHERE ordernumber = 'P2502180000098' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456763'
                WHERE ordernumber = 'P2502180000101' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455628'
                WHERE ordernumber = 'P2502180000106' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314836'
                WHERE ordernumber = 'P2502180000107' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456733'
                WHERE ordernumber = 'P2502180000108' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228119'
                WHERE ordernumber = 'P2502180000110' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366235'
                WHERE ordernumber = 'P2502180000113' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234846'
                WHERE ordernumber = 'P2502180000115' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '438122'
                WHERE ordernumber = 'P2502180000117' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162674'
                WHERE ordernumber = 'P2502180000120' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85466'
                WHERE ordernumber = 'P2502180000124' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456766'
                WHERE ordernumber = 'P2502180000127' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140074'
                WHERE ordernumber = 'P2502180000129' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456766'
                WHERE ordernumber = 'P2502180000132' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221248'
                WHERE ordernumber = 'P2502180000134' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456767'
                WHERE ordernumber = 'P2502180000137' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456766'
                WHERE ordernumber = 'P2502180000138' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456769'
                WHERE ordernumber = 'P2502180000143' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273486'
                WHERE ordernumber = 'P2502180000145' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93409'
                WHERE ordernumber = 'P2502180000146' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456768'
                WHERE ordernumber = 'P2502180000149' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262372'
                WHERE ordernumber = 'P2502180000150' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456771'
                WHERE ordernumber = 'P2502180000154' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320487'
                WHERE ordernumber = 'P2502180000155' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456772'
                WHERE ordernumber = 'P2502180000157' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456773'
                WHERE ordernumber = 'P2502180000158' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456774'
                WHERE ordernumber = 'P2502180000159' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456776'
                WHERE ordernumber = 'P2502180000165' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456775'
                WHERE ordernumber = 'P2502180000166' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456777'
                WHERE ordernumber = 'P2502180000169' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456778'
                WHERE ordernumber = 'P2502180000170' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456779'
                WHERE ordernumber = 'P2502180000171' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456780'
                WHERE ordernumber = 'P2502180000173' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456781'
                WHERE ordernumber = 'P2502180000175' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456782'
                WHERE ordernumber = 'P2502180000176' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428851'
                WHERE ordernumber = 'P2502180000177' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283734'
                WHERE ordernumber = 'P2502180000179' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456782'
                WHERE ordernumber = 'P2502180000182' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137654'
                WHERE ordernumber = 'P2502180000183' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456785'
                WHERE ordernumber = 'P2502180000184' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111821'
                WHERE ordernumber = 'P2502180000187' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456787'
                WHERE ordernumber = 'P2502180000189' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340469'
                WHERE ordernumber = 'P2502180000192' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456788'
                WHERE ordernumber = 'P2502180000196' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456789'
                WHERE ordernumber = 'P2502180000200' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456790'
                WHERE ordernumber = 'P2502180000206' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456792'
                WHERE ordernumber = 'P2502180000212' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456793'
                WHERE ordernumber = 'P2502180000217' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P2502180000219' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456794'
                WHERE ordernumber = 'P2502180000220' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229705'
                WHERE ordernumber = 'P2502180000222' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456798'
                WHERE ordernumber = 'P2502180000230' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433201'
                WHERE ordernumber = 'P2502180000232' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456727'
                WHERE ordernumber = 'P2502180000233' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456797'
                WHERE ordernumber = 'P2502180000236' 
            
2025-02-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456802'
                WHERE ordernumber = 'P2502180000237' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456804'
                WHERE ordernumber = 'P2502180000240' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456803'
                WHERE ordernumber = 'P2502180000242' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456805'
                WHERE ordernumber = 'P2502180000244' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273139'
                WHERE ordernumber = 'P2502180000246' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273139'
                WHERE ordernumber = 'P2502180000247' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97952'
                WHERE ordernumber = 'P2502180000249' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456806'
                WHERE ordernumber = 'P2502180000250' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415119'
                WHERE ordernumber = 'P2502180000251' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311871'
                WHERE ordernumber = 'P2502180000252' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456808'
                WHERE ordernumber = 'P2502180000253' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456807'
                WHERE ordernumber = 'P2502180000257' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95730'
                WHERE ordernumber = 'P2502180000258' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456809'
                WHERE ordernumber = 'P2502180000259' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311871'
                WHERE ordernumber = 'P2502180000260' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456811'
                WHERE ordernumber = 'P2502180000263' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349895'
                WHERE ordernumber = 'P2502180000267' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312978'
                WHERE ordernumber = 'P2502180000269' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456813'
                WHERE ordernumber = 'P2502180000270' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456814'
                WHERE ordernumber = 'P2502180000274' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456815'
                WHERE ordernumber = 'P2502180000278' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456816'
                WHERE ordernumber = 'P2502180000279' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270129'
                WHERE ordernumber = 'P2502180000281' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394910'
                WHERE ordernumber = 'P2502180000287' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456817'
                WHERE ordernumber = 'P2502180000288' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333766'
                WHERE ordernumber = 'P2502180000290' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456818'
                WHERE ordernumber = 'P2502180000291' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456819'
                WHERE ordernumber = 'P2502180000295' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343888'
                WHERE ordernumber = 'P2502180000296' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456822'
                WHERE ordernumber = 'P2502180000297' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374360'
                WHERE ordernumber = 'P2502180000303' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129318'
                WHERE ordernumber = 'P2502180000304' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105869'
                WHERE ordernumber = 'P2502180000305' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456825'
                WHERE ordernumber = 'P2502180000308' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302695'
                WHERE ordernumber = 'P2502180000310' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456820'
                WHERE ordernumber = 'P2502180000312' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404310'
                WHERE ordernumber = 'P2502180000315' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326202'
                WHERE ordernumber = 'P2502180000316' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220663'
                WHERE ordernumber = 'P2502180000323' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294579'
                WHERE ordernumber = 'P2502180000325' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364337'
                WHERE ordernumber = 'P2502180000328' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217329'
                WHERE ordernumber = 'P2502180000329' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456826'
                WHERE ordernumber = 'P2502180000330' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163105'
                WHERE ordernumber = 'P2502180000335' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456827'
                WHERE ordernumber = 'P2502180000337' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456828'
                WHERE ordernumber = 'P2502180000338' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428596'
                WHERE ordernumber = 'P2502180000339' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456829'
                WHERE ordernumber = 'P2502180000340' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456830'
                WHERE ordernumber = 'P2502180000341' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456831'
                WHERE ordernumber = 'P2502180000343' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126094'
                WHERE ordernumber = 'P2502180000346' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104725'
                WHERE ordernumber = 'P2502180000352' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162980'
                WHERE ordernumber = 'P2502180000353' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456833'
                WHERE ordernumber = 'P2502180000356' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456832'
                WHERE ordernumber = 'P2502180000357' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456834'
                WHERE ordernumber = 'P2502180000367' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127600'
                WHERE ordernumber = 'P2502180000369' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385996'
                WHERE ordernumber = 'P2502180000370' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158358'
                WHERE ordernumber = 'P2502180000371' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456836'
                WHERE ordernumber = 'P2502180000373' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275929'
                WHERE ordernumber = 'P2502180000374' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456837'
                WHERE ordernumber = 'P2502180000378' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456838'
                WHERE ordernumber = 'P2502180000379' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456840'
                WHERE ordernumber = 'P2502180000382' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456841'
                WHERE ordernumber = 'P2502180000387' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456842'
                WHERE ordernumber = 'P2502180000391' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '46375'
                WHERE ordernumber = 'P2502180000395' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456843'
                WHERE ordernumber = 'P2502180000396' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456844'
                WHERE ordernumber = 'P2502180000398' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347634'
                WHERE ordernumber = 'P2502180000403' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252912'
                WHERE ordernumber = 'P2502180000404' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131920'
                WHERE ordernumber = 'P2502180000415' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456846'
                WHERE ordernumber = 'P2502180000424' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456851'
                WHERE ordernumber = 'P2502180000429' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456852'
                WHERE ordernumber = 'P2502180000432' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456835'
                WHERE ordernumber = 'P2502180000435' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456851'
                WHERE ordernumber = 'P2502180000436' 
            
2025-02-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430372'
                WHERE ordernumber = 'P2502180000439' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283975'
                WHERE ordernumber = 'P2502180000440' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456853'
                WHERE ordernumber = 'P2502180000441' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456854'
                WHERE ordernumber = 'P2502180000444' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '115357'
                WHERE ordernumber = 'P2502180000447' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '115357'
                WHERE ordernumber = 'P2502180000450' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245523'
                WHERE ordernumber = 'P2502180000453' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456855'
                WHERE ordernumber = 'P2502180000455' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456856'
                WHERE ordernumber = 'P2502180000461' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '213581'
                WHERE ordernumber = 'P2502180000462' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '119802'
                WHERE ordernumber = 'P2502180000466' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456859'
                WHERE ordernumber = 'P2502180000471' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '331619'
                WHERE ordernumber = 'P2502180000472' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456860'
                WHERE ordernumber = 'P2502180000475' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456862'
                WHERE ordernumber = 'P2502180000479' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273534'
                WHERE ordernumber = 'P2502180000480' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351916'
                WHERE ordernumber = 'P2502180000481' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456863'
                WHERE ordernumber = 'P2502180000483' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456864'
                WHERE ordernumber = 'P2502180000485' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '154283'
                WHERE ordernumber = 'P2502180000486' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456865'
                WHERE ordernumber = 'P2502180000491' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456866'
                WHERE ordernumber = 'P2502180000492' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '211251'
                WHERE ordernumber = 'P2502180000495' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '152135'
                WHERE ordernumber = 'P2502180000498' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214864'
                WHERE ordernumber = 'P2502180000500' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456867'
                WHERE ordernumber = 'P2502180000503' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '435372'
                WHERE ordernumber = 'P2502180000504' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456868'
                WHERE ordernumber = 'P2502180000513' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456869'
                WHERE ordernumber = 'P2502180000514' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241940'
                WHERE ordernumber = 'P2502180000516' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456871'
                WHERE ordernumber = 'P2502180000518' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337787'
                WHERE ordernumber = 'P2502180000519' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456872'
                WHERE ordernumber = 'P2502180000520' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302040'
                WHERE ordernumber = 'P2502180000521' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456873'
                WHERE ordernumber = 'P2502180000524' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456874'
                WHERE ordernumber = 'P2502180000529' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248497'
                WHERE ordernumber = 'P2502180000530' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278964'
                WHERE ordernumber = 'P2502180000532' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456857'
                WHERE ordernumber = 'P2502180000536' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456857'
                WHERE ordernumber = 'P2502180000537' 
            
2025-02-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456876'
                WHERE ordernumber = 'P2502180000539'