2024-10-05 01:00:02 -- 將會員中心id寫入data-lake
2024-10-05 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-10-04%';
        
2024-10-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378461'
                WHERE ordernumber = 'P201004110218952' 
            
2024-10-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424015'
                WHERE ordernumber = 'P181004110311643' 
            
2024-10-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424014'
                WHERE ordernumber = 'P191004110317990' 
            
2024-10-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424016'
                WHERE ordernumber = 'P191004110451350' 
            
2024-10-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424017'
                WHERE ordernumber = 'P191004110638934' 
            
2024-10-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424018'
                WHERE ordernumber = 'P201004110719656' 
            
2024-10-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423299'
                WHERE ordernumber = 'P191004110742137' 
            
2024-10-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424021'
                WHERE ordernumber = 'P191004110851579' 
            
2024-10-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272118'
                WHERE ordernumber = 'P191004111236209' 
            
2024-10-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424022'
                WHERE ordernumber = 'P201004111339323' 
            
2024-10-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424020'
                WHERE ordernumber = 'P191004111358940' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378639'
                WHERE ordernumber = 'P201004111449563' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398005'
                WHERE ordernumber = 'P631004111829116' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348816'
                WHERE ordernumber = 'P201004112022702' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424024'
                WHERE ordernumber = 'P201004112343759' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424023'
                WHERE ordernumber = 'P191004112350699' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296804'
                WHERE ordernumber = 'P421004112439394' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361444'
                WHERE ordernumber = 'P191004112505304' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P421004112515496' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423348'
                WHERE ordernumber = 'P181004112935387' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423469'
                WHERE ordernumber = 'P201004113025970' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130063'
                WHERE ordernumber = 'P191004113345416' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424025'
                WHERE ordernumber = 'P201004113401777' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406903'
                WHERE ordernumber = 'P201004113531698' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285867'
                WHERE ordernumber = 'P191004113617163' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305733'
                WHERE ordernumber = 'P201004113707117' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406903'
                WHERE ordernumber = 'P201004113829451' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103118'
                WHERE ordernumber = 'P191004114018135' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206917'
                WHERE ordernumber = 'P191004114310268' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271807'
                WHERE ordernumber = 'P201004114337954' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421792'
                WHERE ordernumber = 'P421004114350123' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229420'
                WHERE ordernumber = 'P191004114719267' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267121'
                WHERE ordernumber = 'P201004114801528' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P191004114925665' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298474'
                WHERE ordernumber = 'P421004115202523' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424026'
                WHERE ordernumber = 'P191004115733376' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424027'
                WHERE ordernumber = 'P191004115857167' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P191004120122986' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315690'
                WHERE ordernumber = 'P201004120146898' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424029'
                WHERE ordernumber = 'P201004120329238' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424028'
                WHERE ordernumber = 'P711004120415365' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424031'
                WHERE ordernumber = 'P191004120749280' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227730'
                WHERE ordernumber = 'P421004120933792' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424033'
                WHERE ordernumber = 'P201004121308495' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424032'
                WHERE ordernumber = 'P421004121337884' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422972'
                WHERE ordernumber = 'P711004121536997' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154281'
                WHERE ordernumber = 'P201004121625461' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381200'
                WHERE ordernumber = 'P201004121850242' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424037'
                WHERE ordernumber = 'P191004122547158' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424036'
                WHERE ordernumber = 'P711004122641502' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315956'
                WHERE ordernumber = 'P201004122811724' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397713'
                WHERE ordernumber = 'P201004122916841' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424010'
                WHERE ordernumber = 'P191004122956233' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412009'
                WHERE ordernumber = 'P201004123040842' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237223'
                WHERE ordernumber = 'P191004123118392' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379578'
                WHERE ordernumber = 'P181004123247791' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424038'
                WHERE ordernumber = 'P191004123337687' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140855'
                WHERE ordernumber = 'P191004124028242' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424040'
                WHERE ordernumber = 'P421004124123255' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424039'
                WHERE ordernumber = 'P201004124223912' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353461'
                WHERE ordernumber = 'P421004124541348' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424041'
                WHERE ordernumber = 'P711004124604874' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297418'
                WHERE ordernumber = 'P421004125026618' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423683'
                WHERE ordernumber = 'P191004130239473' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424044'
                WHERE ordernumber = 'P421004130428168' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305995'
                WHERE ordernumber = 'P711004130608485' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424045'
                WHERE ordernumber = 'P191004130939298' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137581'
                WHERE ordernumber = 'P191004131143706' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160054'
                WHERE ordernumber = 'P201004131529819' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424048'
                WHERE ordernumber = 'P191004131802220' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419442'
                WHERE ordernumber = 'P201004131915646' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393290'
                WHERE ordernumber = 'P421004132002967' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424050'
                WHERE ordernumber = 'P421004132500337' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424052'
                WHERE ordernumber = 'P711004132655602' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336110'
                WHERE ordernumber = 'P421004132703904' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424051'
                WHERE ordernumber = 'P731004132951191' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419442'
                WHERE ordernumber = 'P201004133004158' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423662'
                WHERE ordernumber = 'P421004133119664' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419442'
                WHERE ordernumber = 'P201004133219336' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424053'
                WHERE ordernumber = 'P711004133543289' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412987'
                WHERE ordernumber = 'P201004133612419' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424054'
                WHERE ordernumber = 'P201004133736162' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94047'
                WHERE ordernumber = 'P201004133927802' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284262'
                WHERE ordernumber = 'P191004134043707' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344253'
                WHERE ordernumber = 'P191004134552416' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424056'
                WHERE ordernumber = 'P191004134848758' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '201864'
                WHERE ordernumber = 'P731004135007961' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161924'
                WHERE ordernumber = 'P201004135152831' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230279'
                WHERE ordernumber = 'P191004135247549' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '195649'
                WHERE ordernumber = 'P191004135709556' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424057'
                WHERE ordernumber = 'P731004135734978' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386301'
                WHERE ordernumber = 'P201004135909965' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '195649'
                WHERE ordernumber = 'P191004140234247' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366096'
                WHERE ordernumber = 'P421004140447569' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424058'
                WHERE ordernumber = 'P201004140535898' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307869'
                WHERE ordernumber = 'P191004140856589' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '200925'
                WHERE ordernumber = 'P711004141013229' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423237'
                WHERE ordernumber = 'P191004141058565' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222184'
                WHERE ordernumber = 'P191004141239635' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402013'
                WHERE ordernumber = 'P201004141356348' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424059'
                WHERE ordernumber = 'P731004141438166' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391540'
                WHERE ordernumber = 'P421004141553230' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98697'
                WHERE ordernumber = 'P191004142409704' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424061'
                WHERE ordernumber = 'P421004142754885' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424060'
                WHERE ordernumber = 'P731004142833160' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424061'
                WHERE ordernumber = 'P421004143004311' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424063'
                WHERE ordernumber = 'P731004143200549' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420918'
                WHERE ordernumber = 'P421004143639701' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424064'
                WHERE ordernumber = 'P711004143724910' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '87588'
                WHERE ordernumber = 'P191004143905657' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396828'
                WHERE ordernumber = 'P201004143916478' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73995'
                WHERE ordernumber = 'P421004144019763' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135323'
                WHERE ordernumber = 'P201004144154795' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424065'
                WHERE ordernumber = 'P711004144220911' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217788'
                WHERE ordernumber = 'P711004144409566' 
            
2024-10-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340315'
                WHERE ordernumber = 'P201004144823422' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307658'
                WHERE ordernumber = 'P421004144959714' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424067'
                WHERE ordernumber = 'P191004145038188' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307658'
                WHERE ordernumber = 'P421004145046731' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415286'
                WHERE ordernumber = 'P191004145154205' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424070'
                WHERE ordernumber = 'P711004145221390' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424068'
                WHERE ordernumber = 'P191004145417640' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424073'
                WHERE ordernumber = 'P711004145432970' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424068'
                WHERE ordernumber = 'P191004145447976' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423987'
                WHERE ordernumber = 'P731004145505743' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424075'
                WHERE ordernumber = 'P711004145909736' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424076'
                WHERE ordernumber = 'P191004150306655' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424071'
                WHERE ordernumber = 'P731004150311127' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424076'
                WHERE ordernumber = 'P191004150322307' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424072'
                WHERE ordernumber = 'P731004150431504' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218447'
                WHERE ordernumber = 'P631004150634516' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424078'
                WHERE ordernumber = 'P191004150712536' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424079'
                WHERE ordernumber = 'P731004150834684' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424074'
                WHERE ordernumber = 'P191004150909622' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424082'
                WHERE ordernumber = 'P711004151203978' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422077'
                WHERE ordernumber = 'P731004151617573' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423843'
                WHERE ordernumber = 'P191004151917728' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424083'
                WHERE ordernumber = 'P191004152057505' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424029'
                WHERE ordernumber = 'P201004152102247' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424084'
                WHERE ordernumber = 'P201004152409992' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424085'
                WHERE ordernumber = 'P201004152614427' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420800'
                WHERE ordernumber = 'P191004152904215' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424081'
                WHERE ordernumber = 'P191004153205416' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424086'
                WHERE ordernumber = 'P421004153305982' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P191004153529760' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P191004154049195' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424090'
                WHERE ordernumber = 'P191004154207447' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424092'
                WHERE ordernumber = 'P711004154755702' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424093'
                WHERE ordernumber = 'P711004154845818' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424091'
                WHERE ordernumber = 'P421004154858591' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401452'
                WHERE ordernumber = 'P201004155212367' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424095'
                WHERE ordernumber = 'P191004155313206' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424090'
                WHERE ordernumber = 'P191004155605423' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390474'
                WHERE ordernumber = 'P191004160138799' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234079'
                WHERE ordernumber = 'P201004160241169' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233074'
                WHERE ordernumber = 'P201004160850738' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '2588'
                WHERE ordernumber = 'P421004161402465' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158709'
                WHERE ordernumber = 'P201004161454460' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352472'
                WHERE ordernumber = 'P201004161704548' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423032'
                WHERE ordernumber = 'P181004161832717' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424101'
                WHERE ordernumber = 'P731004161932538' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424100'
                WHERE ordernumber = 'P731004162056805' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339414'
                WHERE ordernumber = 'P421004162215384' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424047'
                WHERE ordernumber = 'P201004162447420' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424047'
                WHERE ordernumber = 'P201004162833869' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424102'
                WHERE ordernumber = 'P191004162847337' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417735'
                WHERE ordernumber = 'P201004163024186' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289089'
                WHERE ordernumber = 'P201004163114385' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424047'
                WHERE ordernumber = 'P201004163244877' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404707'
                WHERE ordernumber = 'P181004163812179' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358805'
                WHERE ordernumber = 'P201004163827922' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411421'
                WHERE ordernumber = 'P181004163942188' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371599'
                WHERE ordernumber = 'P201004164244775' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424104'
                WHERE ordernumber = 'P181004164249875' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423243'
                WHERE ordernumber = 'P181004164416933' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396266'
                WHERE ordernumber = 'P181004164743936' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278151'
                WHERE ordernumber = 'P201004165124483' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424105'
                WHERE ordernumber = 'P711004165317923' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422443'
                WHERE ordernumber = 'P201004170122884' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422443'
                WHERE ordernumber = 'P201004170220653' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424107'
                WHERE ordernumber = 'P201004170422786' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424108'
                WHERE ordernumber = 'P711004170541971' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424106'
                WHERE ordernumber = 'P181004170556114' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366196'
                WHERE ordernumber = 'P191004170559600' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377516'
                WHERE ordernumber = 'P201004171021609' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368164'
                WHERE ordernumber = 'P201004171400422' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255135'
                WHERE ordernumber = 'P711004171425729' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424109'
                WHERE ordernumber = 'P181004171501394' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317026'
                WHERE ordernumber = 'P201004171817300' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314886'
                WHERE ordernumber = 'P181004172001789' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403084'
                WHERE ordernumber = 'P181004172157330' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424110'
                WHERE ordernumber = 'P421004172159958' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424111'
                WHERE ordernumber = 'P711004172316184' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422961'
                WHERE ordernumber = 'P421004172323818' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319561'
                WHERE ordernumber = 'P711004172520798' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291669'
                WHERE ordernumber = 'P201004172542921' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217788'
                WHERE ordernumber = 'P711004173241836' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424113'
                WHERE ordernumber = 'P421004173610826' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424117'
                WHERE ordernumber = 'P201004173851209' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271852'
                WHERE ordernumber = 'P201004174150121' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424118'
                WHERE ordernumber = 'P711004174255661' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403612'
                WHERE ordernumber = 'P421004174313341' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421833'
                WHERE ordernumber = 'P201004174437418' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424119'
                WHERE ordernumber = 'P711004175146734' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424120'
                WHERE ordernumber = 'P181004175159656' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424121'
                WHERE ordernumber = 'P201004175218894' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225398'
                WHERE ordernumber = 'P181004175317739' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303275'
                WHERE ordernumber = 'P201004175417738' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424123'
                WHERE ordernumber = 'P181004175727924' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424122'
                WHERE ordernumber = 'P421004175813829' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424124'
                WHERE ordernumber = 'P181004180140955' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424125'
                WHERE ordernumber = 'P731004180308847' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114040'
                WHERE ordernumber = 'P181004180748171' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424126'
                WHERE ordernumber = 'P201004180858633' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129423'
                WHERE ordernumber = 'P181004180920690' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424127'
                WHERE ordernumber = 'P181004181446249' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424129'
                WHERE ordernumber = 'P181004182456539' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141559'
                WHERE ordernumber = 'P201004182501649' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424130'
                WHERE ordernumber = 'P181004182606792' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317946'
                WHERE ordernumber = 'P711004182726166' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329666'
                WHERE ordernumber = 'P181004182734524' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424131'
                WHERE ordernumber = 'P181004183014488' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424132'
                WHERE ordernumber = 'P181004183102162' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114408'
                WHERE ordernumber = 'P181004183154716' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424133'
                WHERE ordernumber = 'P201004183231238' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424135'
                WHERE ordernumber = 'P181004183404612' 
            
2024-10-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420897'
                WHERE ordernumber = 'P201004183641926' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222217'
                WHERE ordernumber = 'P181004185049800' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303878'
                WHERE ordernumber = 'P201004185203733' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287392'
                WHERE ordernumber = 'P731004185524693' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424137'
                WHERE ordernumber = 'P711004185733625' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424138'
                WHERE ordernumber = 'P181004190009345' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424143'
                WHERE ordernumber = 'P201004190240130' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424142'
                WHERE ordernumber = 'P191004190411429' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424144'
                WHERE ordernumber = 'P201004190557426' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424139'
                WHERE ordernumber = 'P191004190626267' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424141'
                WHERE ordernumber = 'P191004190903142' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424147'
                WHERE ordernumber = 'P731004191222718' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424145'
                WHERE ordernumber = 'P711004191318303' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424146'
                WHERE ordernumber = 'P191004191350663' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424148'
                WHERE ordernumber = 'P731004191628127' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424149'
                WHERE ordernumber = 'P191004191708773' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378658'
                WHERE ordernumber = 'P191004192220159' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405797'
                WHERE ordernumber = 'P191004192311859' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424151'
                WHERE ordernumber = 'P191004192412192' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285530'
                WHERE ordernumber = 'P201004192534137' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424150'
                WHERE ordernumber = 'P711004192553526' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266911'
                WHERE ordernumber = 'P201004192702534' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424152'
                WHERE ordernumber = 'P201004192827187' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424153'
                WHERE ordernumber = 'P711004193115808' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217788'
                WHERE ordernumber = 'P711004193407224' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409791'
                WHERE ordernumber = 'P191004193438180' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384880'
                WHERE ordernumber = 'P201004193608566' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424154'
                WHERE ordernumber = 'P191004194453660' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '166490'
                WHERE ordernumber = 'P201004194808329' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421916'
                WHERE ordernumber = 'P191004195239625' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424156'
                WHERE ordernumber = 'P711004195320594' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421036'
                WHERE ordernumber = 'P191004195352522' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424157'
                WHERE ordernumber = 'P191004195815996' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '290405'
                WHERE ordernumber = 'P191004195832418' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423749'
                WHERE ordernumber = 'P731004200842570' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424161'
                WHERE ordernumber = 'P731004202146443' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424162'
                WHERE ordernumber = 'P711004203440862' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '204706'
                WHERE ordernumber = 'P711004204426854' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423284'
                WHERE ordernumber = 'P731004204451392' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424163'
                WHERE ordernumber = 'P711004204639996' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424164'
                WHERE ordernumber = 'P711004205002714' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424166'
                WHERE ordernumber = 'P731004211038507' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240353'
                WHERE ordernumber = 'P711004211404436' 
            
2024-10-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424169'
                WHERE ordernumber = 'P731004215017446'