2024-12-28 01:00:01 -- 將會員中心id寫入data-lake
2024-12-28 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 '2024-12-27%';
        
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94231'
                WHERE ordernumber = 'P2412270000011' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405523'
                WHERE ordernumber = 'P2412270000025' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440021'
                WHERE ordernumber = 'P2412270000028' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294541'
                WHERE ordernumber = 'P2412270000029' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440022'
                WHERE ordernumber = 'P2412270000030' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440026'
                WHERE ordernumber = 'P2412270000031' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440023'
                WHERE ordernumber = 'P2412270000032' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '438825'
                WHERE ordernumber = 'P2412270000033' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440029'
                WHERE ordernumber = 'P2412270000034' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440031'
                WHERE ordernumber = 'P2412270000036' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '312854'
                WHERE ordernumber = 'P2412270000037' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '65371'
                WHERE ordernumber = 'P2412270000042' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440032'
                WHERE ordernumber = 'P2412270000044' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439895'
                WHERE ordernumber = 'P2412270000046' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440035'
                WHERE ordernumber = 'P2412270000047' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422304'
                WHERE ordernumber = 'P2412270000048' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '203355'
                WHERE ordernumber = 'P2412270000049' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440038'
                WHERE ordernumber = 'P2412270000053' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '70452'
                WHERE ordernumber = 'P2412270000054' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247872'
                WHERE ordernumber = 'P2412270000056' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277359'
                WHERE ordernumber = 'P2412270000057' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439994'
                WHERE ordernumber = 'P2412270000058' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229469'
                WHERE ordernumber = 'P2412270000062' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391919'
                WHERE ordernumber = 'P2412270000063' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377318'
                WHERE ordernumber = 'P2412270000064' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440033'
                WHERE ordernumber = 'P2412270000065' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '439895'
                WHERE ordernumber = 'P2412270000066' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440040'
                WHERE ordernumber = 'P2412270000070' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424995'
                WHERE ordernumber = 'P2412270000076' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440033'
                WHERE ordernumber = 'P2412270000078' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395944'
                WHERE ordernumber = 'P2412270000079' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440045'
                WHERE ordernumber = 'P2412270000084' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437707'
                WHERE ordernumber = 'P2412270000085' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440049'
                WHERE ordernumber = 'P2412270000095' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440050'
                WHERE ordernumber = 'P2412270000097' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435103'
                WHERE ordernumber = 'P2412270000100' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440052'
                WHERE ordernumber = 'P2412270000102' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440055'
                WHERE ordernumber = 'P2412270000104' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432056'
                WHERE ordernumber = 'P2412270000105' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237288'
                WHERE ordernumber = 'P2412270000106' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381630'
                WHERE ordernumber = 'P2412270000108' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440056'
                WHERE ordernumber = 'P2412270000109' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440057'
                WHERE ordernumber = 'P2412270000110' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297757'
                WHERE ordernumber = 'P2412270000112' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '62840'
                WHERE ordernumber = 'P2412270000115' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440048'
                WHERE ordernumber = 'P2412270000117' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440048'
                WHERE ordernumber = 'P2412270000120' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '44587'
                WHERE ordernumber = 'P2412270000121' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440059'
                WHERE ordernumber = 'P2412270000126' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394735'
                WHERE ordernumber = 'P2412270000128' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440061'
                WHERE ordernumber = 'P2412270000130' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '39181'
                WHERE ordernumber = 'P2412270000131' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P2412270000132' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355350'
                WHERE ordernumber = 'P2412270000135' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440063'
                WHERE ordernumber = 'P2412270000136' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355350'
                WHERE ordernumber = 'P2412270000141' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '115536'
                WHERE ordernumber = 'P2412270000142' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440067'
                WHERE ordernumber = 'P2412270000146' 
            
2024-12-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254027'
                WHERE ordernumber = 'P2412270000148' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440072'
                WHERE ordernumber = 'P2412270000150' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260980'
                WHERE ordernumber = 'P2412270000151' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355350'
                WHERE ordernumber = 'P2412270000155' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341918'
                WHERE ordernumber = 'P2412270000160' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387244'
                WHERE ordernumber = 'P2412270000161' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408489'
                WHERE ordernumber = 'P2412270000162' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391604'
                WHERE ordernumber = 'P2412270000165' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '49213'
                WHERE ordernumber = 'P2412270000166' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440077'
                WHERE ordernumber = 'P2412270000169' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440079'
                WHERE ordernumber = 'P2412270000171' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440078'
                WHERE ordernumber = 'P2412270000172' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440081'
                WHERE ordernumber = 'P2412270000173' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74449'
                WHERE ordernumber = 'P2412270000178' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P2412270000179' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P2412270000180' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439686'
                WHERE ordernumber = 'P2412270000185' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281391'
                WHERE ordernumber = 'P2412270000188' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440085'
                WHERE ordernumber = 'P2412270000189' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440087'
                WHERE ordernumber = 'P2412270000191' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '32781'
                WHERE ordernumber = 'P2412270000198' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338933'
                WHERE ordernumber = 'P2412270000200' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426282'
                WHERE ordernumber = 'P2412270000202' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286749'
                WHERE ordernumber = 'P2412270000203' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440097'
                WHERE ordernumber = 'P2412270000205' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365637'
                WHERE ordernumber = 'P2412270000208' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432291'
                WHERE ordernumber = 'P2412270000209' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440095'
                WHERE ordernumber = 'P2412270000210' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P2412270000212' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440100'
                WHERE ordernumber = 'P2412270000216' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439102'
                WHERE ordernumber = 'P2412270000217' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96828'
                WHERE ordernumber = 'P2412270000218' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440102'
                WHERE ordernumber = 'P2412270000220' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398304'
                WHERE ordernumber = 'P2412270000222' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '42540'
                WHERE ordernumber = 'P2412270000227' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439782'
                WHERE ordernumber = 'P2412270000228' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253575'
                WHERE ordernumber = 'P2412270000229' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404598'
                WHERE ordernumber = 'P2412270000230' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213393'
                WHERE ordernumber = 'P2412270000231' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99210'
                WHERE ordernumber = 'P2412270000235' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440106'
                WHERE ordernumber = 'P2412270000237' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440115'
                WHERE ordernumber = 'P2412270000241' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364956'
                WHERE ordernumber = 'P2412270000242' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440114'
                WHERE ordernumber = 'P2412270000243' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246310'
                WHERE ordernumber = 'P2412270000247' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64255'
                WHERE ordernumber = 'P2412270000250' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347541'
                WHERE ordernumber = 'P2412270000255' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440120'
                WHERE ordernumber = 'P2412270000257' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440119'
                WHERE ordernumber = 'P2412270000262' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382478'
                WHERE ordernumber = 'P2412270000264' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440123'
                WHERE ordernumber = 'P2412270000265' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282828'
                WHERE ordernumber = 'P2412270000266' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440124'
                WHERE ordernumber = 'P2412270000271' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440127'
                WHERE ordernumber = 'P2412270000279' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373741'
                WHERE ordernumber = 'P2412270000282' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440112'
                WHERE ordernumber = 'P2412270000283' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440131'
                WHERE ordernumber = 'P2412270000284' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375124'
                WHERE ordernumber = 'P2412270000286' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352199'
                WHERE ordernumber = 'P2412270000290' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440134'
                WHERE ordernumber = 'P2412270000291' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426697'
                WHERE ordernumber = 'P2412270000297' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121245'
                WHERE ordernumber = 'P2412270000300' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427648'
                WHERE ordernumber = 'P2412270000302' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313349'
                WHERE ordernumber = 'P2412270000306' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440074'
                WHERE ordernumber = 'P2412270000309' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90167'
                WHERE ordernumber = 'P2412270000321' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440144'
                WHERE ordernumber = 'P2412270000322' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '439356'
                WHERE ordernumber = 'P2412270000334' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440146'
                WHERE ordernumber = 'P2412270000344' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440152'
                WHERE ordernumber = 'P2412270000349' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97572'
                WHERE ordernumber = 'P2412270000350' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251258'
                WHERE ordernumber = 'P2412270000351' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344871'
                WHERE ordernumber = 'P2412270000353' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440154'
                WHERE ordernumber = 'P2412270000355' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440103'
                WHERE ordernumber = 'P2412270000362' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P2412270000363' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440103'
                WHERE ordernumber = 'P2412270000364' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334955'
                WHERE ordernumber = 'P2412270000365' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401296'
                WHERE ordernumber = 'P2412270000366' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440156'
                WHERE ordernumber = 'P2412270000372' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440155'
                WHERE ordernumber = 'P2412270000373' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2412270000374' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306488'
                WHERE ordernumber = 'P2412270000377' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354400'
                WHERE ordernumber = 'P2412270000393' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440158'
                WHERE ordernumber = 'P2412270000394' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305084'
                WHERE ordernumber = 'P2412270000395' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237215'
                WHERE ordernumber = 'P2412270000396' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140792'
                WHERE ordernumber = 'P2412270000400' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437997'
                WHERE ordernumber = 'P2412270000406' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387865'
                WHERE ordernumber = 'P2412270000408' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287585'
                WHERE ordernumber = 'P2412270000412' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440167'
                WHERE ordernumber = 'P2412270000420' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440168'
                WHERE ordernumber = 'P2412270000426' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420184'
                WHERE ordernumber = 'P2412270000428' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74135'
                WHERE ordernumber = 'P2412270000432' 
            
2024-12-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '440171'
                WHERE ordernumber = 'P2412270000434' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164144'
                WHERE ordernumber = 'P2412270000439' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117304'
                WHERE ordernumber = 'P2412270000445' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76999'
                WHERE ordernumber = 'P2412270000449' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440172'
                WHERE ordernumber = 'P2412270000451' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440177'
                WHERE ordernumber = 'P2412270000458' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266595'
                WHERE ordernumber = 'P2412270000459' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440179'
                WHERE ordernumber = 'P2412270000460' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440180'
                WHERE ordernumber = 'P2412270000461' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440178'
                WHERE ordernumber = 'P2412270000464' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120526'
                WHERE ordernumber = 'P2412270000468' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440156'
                WHERE ordernumber = 'P2412270000470' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440186'
                WHERE ordernumber = 'P2412270000479' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440186'
                WHERE ordernumber = 'P2412270000480' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353694'
                WHERE ordernumber = 'P2412270000481' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440187'
                WHERE ordernumber = 'P2412270000483' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400880'
                WHERE ordernumber = 'P2412270000488' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440190'
                WHERE ordernumber = 'P2412270000490' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334955'
                WHERE ordernumber = 'P2412270000491' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440189'
                WHERE ordernumber = 'P2412270000495' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440189'
                WHERE ordernumber = 'P2412270000496' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250051'
                WHERE ordernumber = 'P2412270000502' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215062'
                WHERE ordernumber = 'P2412270000505' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333607'
                WHERE ordernumber = 'P2412270000506' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440192'
                WHERE ordernumber = 'P2412270000511' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429864'
                WHERE ordernumber = 'P2412270000516' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440198'
                WHERE ordernumber = 'P2412270000522' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431194'
                WHERE ordernumber = 'P2412270000523' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440196'
                WHERE ordernumber = 'P2412270000525' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415732'
                WHERE ordernumber = 'P2412270000533' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440202'
                WHERE ordernumber = 'P2412270000539' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440192'
                WHERE ordernumber = 'P2412270000541' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355079'
                WHERE ordernumber = 'P2412270000542' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440206'
                WHERE ordernumber = 'P2412270000547' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '439381'
                WHERE ordernumber = 'P2412270000549' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440207'
                WHERE ordernumber = 'P2412270000550' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440208'
                WHERE ordernumber = 'P2412270000551' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440197'
                WHERE ordernumber = 'P2412270000552' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424029'
                WHERE ordernumber = 'P2412270000555' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251529'
                WHERE ordernumber = 'P2412270000556' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440178'
                WHERE ordernumber = 'P2412270000558' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440203'
                WHERE ordernumber = 'P2412270000560' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440203'
                WHERE ordernumber = 'P2412270000561' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380374'
                WHERE ordernumber = 'P2412270000566' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438772'
                WHERE ordernumber = 'P2412270000567' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249779'
                WHERE ordernumber = 'P2412270000568' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P2412270000569' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440213'
                WHERE ordernumber = 'P2412270000575' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440214'
                WHERE ordernumber = 'P2412270000576' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440216'
                WHERE ordernumber = 'P2412270000578' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440219'
                WHERE ordernumber = 'P2412270000585' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '36124'
                WHERE ordernumber = 'P2412270000587' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440217'
                WHERE ordernumber = 'P2412270000589' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440223'
                WHERE ordernumber = 'P2412270000594' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440224'
                WHERE ordernumber = 'P2412270000596' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440226'
                WHERE ordernumber = 'P2412270000597' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308916'
                WHERE ordernumber = 'P2412270000600' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243113'
                WHERE ordernumber = 'P2412270000602' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369233'
                WHERE ordernumber = 'P2412270000604' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440222'
                WHERE ordernumber = 'P2412270000605' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440229'
                WHERE ordernumber = 'P2412270000614' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346317'
                WHERE ordernumber = 'P2412270000622' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440231'
                WHERE ordernumber = 'P2412270000623' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440214'
                WHERE ordernumber = 'P2412270000628' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '438018'
                WHERE ordernumber = 'P2412270000629' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440234'
                WHERE ordernumber = 'P2412270000631' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440236'
                WHERE ordernumber = 'P2412270000634' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440237'
                WHERE ordernumber = 'P2412270000635' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112250'
                WHERE ordernumber = 'P2412270000637' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440243'
                WHERE ordernumber = 'P2412270000641' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293997'
                WHERE ordernumber = 'P2412270000642' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266918'
                WHERE ordernumber = 'P2412270000643' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422323'
                WHERE ordernumber = 'P2412270000644' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418169'
                WHERE ordernumber = 'P2412270000649' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440250'
                WHERE ordernumber = 'P2412270000660' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440251'
                WHERE ordernumber = 'P2412270000666' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440253'
                WHERE ordernumber = 'P2412270000669' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440243'
                WHERE ordernumber = 'P2412270000671' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404113'
                WHERE ordernumber = 'P2412270000678' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169'
                WHERE ordernumber = 'P2412270000681' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440255'
                WHERE ordernumber = 'P2412270000682' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434239'
                WHERE ordernumber = 'P2412270000688' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '83954'
                WHERE ordernumber = 'P2412270000690' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173742'
                WHERE ordernumber = 'P2412270000691' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242440'
                WHERE ordernumber = 'P2412270000698' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431884'
                WHERE ordernumber = 'P2412270000701' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440258'
                WHERE ordernumber = 'P2412270000702' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440261'
                WHERE ordernumber = 'P2412270000708' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325212'
                WHERE ordernumber = 'P2412270000709' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440262'
                WHERE ordernumber = 'P2412270000713' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129909'
                WHERE ordernumber = 'P2412270000717' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399734'
                WHERE ordernumber = 'P2412270000720' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129909'
                WHERE ordernumber = 'P2412270000723' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81970'
                WHERE ordernumber = 'P2412270000727' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P2412270000731' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P2412270000738' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323764'
                WHERE ordernumber = 'P2412270000743' 
            
2024-12-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '440267'
                WHERE ordernumber = 'P2412270000745' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440269'
                WHERE ordernumber = 'P2412270000747' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298154'
                WHERE ordernumber = 'P2412270000748' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219473'
                WHERE ordernumber = 'P2412270000752' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '328345'
                WHERE ordernumber = 'P2412270000753' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242243'
                WHERE ordernumber = 'P2412270000756' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440266'
                WHERE ordernumber = 'P2412270000757' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '432415'
                WHERE ordernumber = 'P2412270000761' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440271'
                WHERE ordernumber = 'P2412270000766' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264976'
                WHERE ordernumber = 'P2412270000772' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '438762'
                WHERE ordernumber = 'P2412270000773' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278217'
                WHERE ordernumber = 'P2412270000777' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440273'
                WHERE ordernumber = 'P2412270000778' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440274'
                WHERE ordernumber = 'P2412270000780' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283781'
                WHERE ordernumber = 'P2412270000783' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421338'
                WHERE ordernumber = 'P2412270000788' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389208'
                WHERE ordernumber = 'P2412270000790' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440000'
                WHERE ordernumber = 'P2412270000793' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '115998'
                WHERE ordernumber = 'P2412270000794' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440277'
                WHERE ordernumber = 'P2412270000796' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440278'
                WHERE ordernumber = 'P2412270000797' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440279'
                WHERE ordernumber = 'P2412270000798' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440280'
                WHERE ordernumber = 'P2412270000801' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385884'
                WHERE ordernumber = 'P2412270000804' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '439554'
                WHERE ordernumber = 'P2412270000806' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440284'
                WHERE ordernumber = 'P2412270000809' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440287'
                WHERE ordernumber = 'P2412270000815' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440290'
                WHERE ordernumber = 'P2412270000819' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '431055'
                WHERE ordernumber = 'P2412270000823' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409455'
                WHERE ordernumber = 'P2412270000824' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '213581'
                WHERE ordernumber = 'P2412270000826' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440278'
                WHERE ordernumber = 'P2412270000829' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440293'
                WHERE ordernumber = 'P2412270000832' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395575'
                WHERE ordernumber = 'P2412270000833' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440295'
                WHERE ordernumber = 'P2412270000835' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379770'
                WHERE ordernumber = 'P2412270000836' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440297'
                WHERE ordernumber = 'P2412270000838' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440299'
                WHERE ordernumber = 'P2412270000843' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440301'
                WHERE ordernumber = 'P2412270000846' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '434768'
                WHERE ordernumber = 'P2412270000848' 
            
2024-12-28 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '440302'
                WHERE ordernumber = 'P2412270000850'