2024-01-06 01:00:02 -- 將會員中心id寫入data-lake
2024-01-06 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 '2024-01-05%';
        
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '89746'
                WHERE ordernumber = 'P190105110221328' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359044'
                WHERE ordernumber = 'P200105110228381' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331956'
                WHERE ordernumber = 'P190105110412499' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162314'
                WHERE ordernumber = 'P200105110428573' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296499'
                WHERE ordernumber = 'P200105110507639' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359045'
                WHERE ordernumber = 'P420105110554205' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358919'
                WHERE ordernumber = 'P420105110957981' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359042'
                WHERE ordernumber = 'P190105111035676' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308957'
                WHERE ordernumber = 'P420105111308557' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359049'
                WHERE ordernumber = 'P180105111359172' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237023'
                WHERE ordernumber = 'P200105111425290' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359043'
                WHERE ordernumber = 'P190105111437196' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329788'
                WHERE ordernumber = 'P420105111440397' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271495'
                WHERE ordernumber = 'P190105111538326' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420105111548267' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359051'
                WHERE ordernumber = 'P200105111653193' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121666'
                WHERE ordernumber = 'P190105111910442' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359055'
                WHERE ordernumber = 'P200105111947740' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278520'
                WHERE ordernumber = 'P200105112026639' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355165'
                WHERE ordernumber = 'P420105112111780' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234101'
                WHERE ordernumber = 'P200105112126451' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359057'
                WHERE ordernumber = 'P180105112434587' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359058'
                WHERE ordernumber = 'P420105112507182' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285340'
                WHERE ordernumber = 'P180105112527155' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359061'
                WHERE ordernumber = 'P190105112724562' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P200105113017481' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '221817'
                WHERE ordernumber = 'P200105113228651' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133142'
                WHERE ordernumber = 'P200105113402166' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273455'
                WHERE ordernumber = 'P200105113511436' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350568'
                WHERE ordernumber = 'P180105113854919' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359068'
                WHERE ordernumber = 'P420105114328175' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359069'
                WHERE ordernumber = 'P190105114429847' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339378'
                WHERE ordernumber = 'P420105114431360' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349044'
                WHERE ordernumber = 'P200105114759934' 
            
2024-01-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '226445'
                WHERE ordernumber = 'P200105114850700' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243405'
                WHERE ordernumber = 'P200105114945508' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359075'
                WHERE ordernumber = 'P420105115112936' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359076'
                WHERE ordernumber = 'P200105115239654' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359077'
                WHERE ordernumber = 'P190105115250415' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359078'
                WHERE ordernumber = 'P420105115359322' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358676'
                WHERE ordernumber = 'P200105115657506' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359080'
                WHERE ordernumber = 'P200105120024987' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140974'
                WHERE ordernumber = 'P200105120247315' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359082'
                WHERE ordernumber = 'P190105120259949' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352011'
                WHERE ordernumber = 'P190105120428575' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356374'
                WHERE ordernumber = 'P200105120433502' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271030'
                WHERE ordernumber = 'P180105120802315' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265892'
                WHERE ordernumber = 'P180105120944815' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90574'
                WHERE ordernumber = 'P180105121115572' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359083'
                WHERE ordernumber = 'P200105121145928' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124944'
                WHERE ordernumber = 'P180105121229870' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294302'
                WHERE ordernumber = 'P200105121249952' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285449'
                WHERE ordernumber = 'P200105121528785' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359084'
                WHERE ordernumber = 'P420105121616614' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359086'
                WHERE ordernumber = 'P180105121917115' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359089'
                WHERE ordernumber = 'P420105122344821' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359094'
                WHERE ordernumber = 'P190105123356972' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359095'
                WHERE ordernumber = 'P200105123659991' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228431'
                WHERE ordernumber = 'P180105123857217' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359098'
                WHERE ordernumber = 'P200105124020172' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265219'
                WHERE ordernumber = 'P180105124104183' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243898'
                WHERE ordernumber = 'P200105124117272' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359096'
                WHERE ordernumber = 'P200105124811999' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286241'
                WHERE ordernumber = 'P180105124824230' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359101'
                WHERE ordernumber = 'P200105124937312' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351150'
                WHERE ordernumber = 'P420105124948304' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359102'
                WHERE ordernumber = 'P200105125045536' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359103'
                WHERE ordernumber = 'P420105125245165' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359104'
                WHERE ordernumber = 'P180105125419622' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125062'
                WHERE ordernumber = 'P190105125448919' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359105'
                WHERE ordernumber = 'P180105125556651' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353989'
                WHERE ordernumber = 'P180105125850456' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359108'
                WHERE ordernumber = 'P200105130433353' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359112'
                WHERE ordernumber = 'P420105130543880' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348408'
                WHERE ordernumber = 'P200105130705809' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81124'
                WHERE ordernumber = 'P420105130746368' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359113'
                WHERE ordernumber = 'P200105130957222' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251919'
                WHERE ordernumber = 'P200105131114925' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284725'
                WHERE ordernumber = 'P200105131210361' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359114'
                WHERE ordernumber = 'P180105131335509' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132564'
                WHERE ordernumber = 'P200105132011400' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341442'
                WHERE ordernumber = 'P180105132803441' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359116'
                WHERE ordernumber = 'P200105133110664' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358819'
                WHERE ordernumber = 'P180105133129563' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359117'
                WHERE ordernumber = 'P200105133317615' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359118'
                WHERE ordernumber = 'P180105133444812' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359120'
                WHERE ordernumber = 'P180105133654135' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359122'
                WHERE ordernumber = 'P180105133806191' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292979'
                WHERE ordernumber = 'P180105133842332' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249460'
                WHERE ordernumber = 'P200105133929428' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359124'
                WHERE ordernumber = 'P190105134143354' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272621'
                WHERE ordernumber = 'P200105134201485' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272621'
                WHERE ordernumber = 'P200105134206131' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356060'
                WHERE ordernumber = 'P180105134343464' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359029'
                WHERE ordernumber = 'P180105134724792' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127285'
                WHERE ordernumber = 'P180105134829772' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341395'
                WHERE ordernumber = 'P180105134931597' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127285'
                WHERE ordernumber = 'P180105135008558' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359128'
                WHERE ordernumber = 'P180105135412194' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359132'
                WHERE ordernumber = 'P180105135540421' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159147'
                WHERE ordernumber = 'P200105135540241' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359131'
                WHERE ordernumber = 'P420105135545553' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330268'
                WHERE ordernumber = 'P420105140207280' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292526'
                WHERE ordernumber = 'P200105140252708' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338208'
                WHERE ordernumber = 'P180105140432871' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81050'
                WHERE ordernumber = 'P200105140506818' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294872'
                WHERE ordernumber = 'P180105140546732' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81050'
                WHERE ordernumber = 'P200105140558343' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294872'
                WHERE ordernumber = 'P180105140735720' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271504'
                WHERE ordernumber = 'P180105140824509' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266054'
                WHERE ordernumber = 'P200105141249424' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229003'
                WHERE ordernumber = 'P200105141636373' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359142'
                WHERE ordernumber = 'P200105141918348' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249194'
                WHERE ordernumber = 'P180105142058833' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158821'
                WHERE ordernumber = 'P180105142158910' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359150'
                WHERE ordernumber = 'P200105142208221' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248363'
                WHERE ordernumber = 'P200105142333252' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359152'
                WHERE ordernumber = 'P180105142336142' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359155'
                WHERE ordernumber = 'P200105142531115' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326775'
                WHERE ordernumber = 'P420105142738134' 
            
2024-01-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359157'
                WHERE ordernumber = 'P200105142826406' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258977'
                WHERE ordernumber = 'P180105143113413' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121245'
                WHERE ordernumber = 'P180105143240150' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359162'
                WHERE ordernumber = 'P180105143441910' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180105143514131' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336092'
                WHERE ordernumber = 'P200105143534367' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359163'
                WHERE ordernumber = 'P180105143734804' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299091'
                WHERE ordernumber = 'P180105143819588' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359165'
                WHERE ordernumber = 'P190105143831177' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283536'
                WHERE ordernumber = 'P200105144052655' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359171'
                WHERE ordernumber = 'P180105144148306' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234350'
                WHERE ordernumber = 'P180105144309247' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221698'
                WHERE ordernumber = 'P180105144448273' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359175'
                WHERE ordernumber = 'P180105145101214' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338418'
                WHERE ordernumber = 'P180105145205678' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154999'
                WHERE ordernumber = 'P200105145213700' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345577'
                WHERE ordernumber = 'P180105145300367' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90674'
                WHERE ordernumber = 'P180105145500493' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355927'
                WHERE ordernumber = 'P200105145802779' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348437'
                WHERE ordernumber = 'P180105145831601' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239207'
                WHERE ordernumber = 'P200105145900458' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359187'
                WHERE ordernumber = 'P180105150040776' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359189'
                WHERE ordernumber = 'P180105150230664' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359190'
                WHERE ordernumber = 'P420105150405388' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359191'
                WHERE ordernumber = 'P420105150439594' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114168'
                WHERE ordernumber = 'P180105150516253' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359192'
                WHERE ordernumber = 'P200105150550910' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359196'
                WHERE ordernumber = 'P420105150843936' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138827'
                WHERE ordernumber = 'P200105150900949' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180105150931252' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345976'
                WHERE ordernumber = 'P420105151220585' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359202'
                WHERE ordernumber = 'P200105151435707' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316687'
                WHERE ordernumber = 'P420105151517873' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130193'
                WHERE ordernumber = 'P200105151901708' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281627'
                WHERE ordernumber = 'P200105152037727' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229420'
                WHERE ordernumber = 'P180105152659179' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238114'
                WHERE ordernumber = 'P200105152721601' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238114'
                WHERE ordernumber = 'P200105152742317' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359208'
                WHERE ordernumber = 'P420105152801861' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359210'
                WHERE ordernumber = 'P200105152828980' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359215'
                WHERE ordernumber = 'P200105153144947' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359217'
                WHERE ordernumber = 'P180105153212813' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359218'
                WHERE ordernumber = 'P200105153244670' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '40809'
                WHERE ordernumber = 'P180105153314507' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359221'
                WHERE ordernumber = 'P420105154214183' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359226'
                WHERE ordernumber = 'P200105154508673' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359228'
                WHERE ordernumber = 'P180105154755508' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359232'
                WHERE ordernumber = 'P180105155209823' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273311'
                WHERE ordernumber = 'P200105155759913' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359238'
                WHERE ordernumber = 'P180105155805729' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359240'
                WHERE ordernumber = 'P180105155852836' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88187'
                WHERE ordernumber = 'P190105160050800' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359245'
                WHERE ordernumber = 'P420105160425348' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359244'
                WHERE ordernumber = 'P180105160627360' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359244'
                WHERE ordernumber = 'P180105160656336' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284715'
                WHERE ordernumber = 'P200105160830569' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114048'
                WHERE ordernumber = 'P180105161454275' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338980'
                WHERE ordernumber = 'P180105161603674' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338980'
                WHERE ordernumber = 'P180105161624481' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359260'
                WHERE ordernumber = 'P180105162024422' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137134'
                WHERE ordernumber = 'P190105162044520' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359262'
                WHERE ordernumber = 'P190105162152647' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244688'
                WHERE ordernumber = 'P180105162622854' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347462'
                WHERE ordernumber = 'P180105162946451' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359274'
                WHERE ordernumber = 'P190105163225434' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308903'
                WHERE ordernumber = 'P180105163337570' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359277'
                WHERE ordernumber = 'P190105163342151' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359283'
                WHERE ordernumber = 'P420105164117932' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P420105164336653' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359286'
                WHERE ordernumber = 'P180105164548422' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246001'
                WHERE ordernumber = 'P200105165132973' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359293'
                WHERE ordernumber = 'P200105165345629' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359295'
                WHERE ordernumber = 'P200105165550615' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359296'
                WHERE ordernumber = 'P180105165622450' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359300'
                WHERE ordernumber = 'P180105165806290' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359303'
                WHERE ordernumber = 'P180105165950964' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359304'
                WHERE ordernumber = 'P180105170047822' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359305'
                WHERE ordernumber = 'P180105170146763' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217471'
                WHERE ordernumber = 'P190105170211953' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329786'
                WHERE ordernumber = 'P420105170320805' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259013'
                WHERE ordernumber = 'P200105170529352' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359307'
                WHERE ordernumber = 'P180105170545956' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359309'
                WHERE ordernumber = 'P180105170632863' 
            
2024-01-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359310'
                WHERE ordernumber = 'P180105170922427' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359311'
                WHERE ordernumber = 'P200105170952600' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113698'
                WHERE ordernumber = 'P180105171134537' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280856'
                WHERE ordernumber = 'P200105171319113' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352260'
                WHERE ordernumber = 'P200105171432924' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237250'
                WHERE ordernumber = 'P200105172007956' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231547'
                WHERE ordernumber = 'P180105172116761' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359315'
                WHERE ordernumber = 'P180105172428126' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116809'
                WHERE ordernumber = 'P180105172523243' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359317'
                WHERE ordernumber = 'P200105172921298' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359229'
                WHERE ordernumber = 'P200105173437522' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359321'
                WHERE ordernumber = 'P180105173509152' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '92267'
                WHERE ordernumber = 'P190105173626504' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180105173639203' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358764'
                WHERE ordernumber = 'P180105173724388' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358764'
                WHERE ordernumber = 'P180105173751358' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347698'
                WHERE ordernumber = 'P420105173916521' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '252044'
                WHERE ordernumber = 'P200105173926593' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359326'
                WHERE ordernumber = 'P420105174257150' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359332'
                WHERE ordernumber = 'P200105175213512' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359337'
                WHERE ordernumber = 'P200105175545755' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359338'
                WHERE ordernumber = 'P420105175652219' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359340'
                WHERE ordernumber = 'P180105175813896' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '328666'
                WHERE ordernumber = 'P420105175928481' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359342'
                WHERE ordernumber = 'P200105180044744' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '89106'
                WHERE ordernumber = 'P200105180445380' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '209934'
                WHERE ordernumber = 'P190105180518309' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359346'
                WHERE ordernumber = 'P200105180543591' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359348'
                WHERE ordernumber = 'P190105180644544' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352700'
                WHERE ordernumber = 'P200105180808360' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359353'
                WHERE ordernumber = 'P180105181014654' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '89106'
                WHERE ordernumber = 'P200105181034883' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343705'
                WHERE ordernumber = 'P180105181548925' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217285'
                WHERE ordernumber = 'P180105181929955' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359358'
                WHERE ordernumber = 'P200105182105204' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359360'
                WHERE ordernumber = 'P200105182333851' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '243519'
                WHERE ordernumber = 'P180105182448719' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297714'
                WHERE ordernumber = 'P420105182502786' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359364'
                WHERE ordernumber = 'P200105182623320' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101523'
                WHERE ordernumber = 'P190105182642867' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359366'
                WHERE ordernumber = 'P180105182716111' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359368'
                WHERE ordernumber = 'P200105182942829' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305533'
                WHERE ordernumber = 'P190105183042144' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160024'
                WHERE ordernumber = 'P200105183045815' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351999'
                WHERE ordernumber = 'P190105183111543' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359370'
                WHERE ordernumber = 'P420105183146538' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245134'
                WHERE ordernumber = 'P200105183306212' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359371'
                WHERE ordernumber = 'P420105183412567' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '356228'
                WHERE ordernumber = 'P200105183501819' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '356228'
                WHERE ordernumber = 'P200105183601734' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93510'
                WHERE ordernumber = 'P190105183648864' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359375'
                WHERE ordernumber = 'P190105183800830' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359381'
                WHERE ordernumber = 'P190105183930990' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359372'
                WHERE ordernumber = 'P420105184022270' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '209214'
                WHERE ordernumber = 'P200105184025657' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359357'
                WHERE ordernumber = 'P190105184339931' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359357'
                WHERE ordernumber = 'P190105184416427' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359384'
                WHERE ordernumber = 'P420105184550301' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359388'
                WHERE ordernumber = 'P190105184716980' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359389'
                WHERE ordernumber = 'P200105184741770' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359391'
                WHERE ordernumber = 'P200105184948490' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359392'
                WHERE ordernumber = 'P420105185115329' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212237'
                WHERE ordernumber = 'P190105185452819' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359398'
                WHERE ordernumber = 'P190105185758143' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281317'
                WHERE ordernumber = 'P190105190229706' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359404'
                WHERE ordernumber = 'P200105190523330' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359405'
                WHERE ordernumber = 'P190105190529674' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359407'
                WHERE ordernumber = 'P200105190800508' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277496'
                WHERE ordernumber = 'P200105190934710' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '335026'
                WHERE ordernumber = 'P200105191340439' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '274565'
                WHERE ordernumber = 'P420105192234259' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287859'
                WHERE ordernumber = 'P200105192240187' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359432'
                WHERE ordernumber = 'P420105192806459' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359438'
                WHERE ordernumber = 'P420105193326281' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284596'
                WHERE ordernumber = 'P200105193533680' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359445'
                WHERE ordernumber = 'P420105193926320' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234882'
                WHERE ordernumber = 'P200105193951138' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358751'
                WHERE ordernumber = 'P190105194113802' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215950'
                WHERE ordernumber = 'P420105195210512' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359460'
                WHERE ordernumber = 'P200105195415882' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359461'
                WHERE ordernumber = 'P200105195936122' 
            
2024-01-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339929'
                WHERE ordernumber = 'P420105200109267'