2024-04-03 01:00:02 -- 將會員中心id寫入data-lake
2024-04-03 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-04-02%';
        
2024-04-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290291'
                WHERE ordernumber = 'P630402102922942' 
            
2024-04-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '153994'
                WHERE ordernumber = 'P630402104315513' 
            
2024-04-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317666'
                WHERE ordernumber = 'P200402110231446' 
            
2024-04-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346065'
                WHERE ordernumber = 'P200402110336583' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384114'
                WHERE ordernumber = 'P180402110433593' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79385'
                WHERE ordernumber = 'P200402110507736' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271216'
                WHERE ordernumber = 'P180402110617325' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226422'
                WHERE ordernumber = 'P190402110723785' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377729'
                WHERE ordernumber = 'P190402110957545' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384115'
                WHERE ordernumber = 'P200402111523691' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384116'
                WHERE ordernumber = 'P190402111748470' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384116'
                WHERE ordernumber = 'P190402111820555' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384117'
                WHERE ordernumber = 'P420402111839277' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293682'
                WHERE ordernumber = 'P200402112520835' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301528'
                WHERE ordernumber = 'P420402112910892' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274766'
                WHERE ordernumber = 'P180402113724145' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311867'
                WHERE ordernumber = 'P200402113815462' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384121'
                WHERE ordernumber = 'P180402113836304' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231565'
                WHERE ordernumber = 'P180402113916721' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384122'
                WHERE ordernumber = 'P200402114002426' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384123'
                WHERE ordernumber = 'P180402114109683' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384124'
                WHERE ordernumber = 'P420402114323267' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311867'
                WHERE ordernumber = 'P200402114413809' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378994'
                WHERE ordernumber = 'P200402114452755' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384125'
                WHERE ordernumber = 'P420402114714866' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384126'
                WHERE ordernumber = 'P630402114920181' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384127'
                WHERE ordernumber = 'P180402115001193' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180402115219417' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180402115326224' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378451'
                WHERE ordernumber = 'P180402115717142' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279917'
                WHERE ordernumber = 'P180402115914562' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384128'
                WHERE ordernumber = 'P200402115915643' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384129'
                WHERE ordernumber = 'P190402115956215' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267896'
                WHERE ordernumber = 'P200402120013240' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339424'
                WHERE ordernumber = 'P200402120915565' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160202'
                WHERE ordernumber = 'P180402121044636' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229641'
                WHERE ordernumber = 'P200402121600954' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121942'
                WHERE ordernumber = 'P180402122232366' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272421'
                WHERE ordernumber = 'P200402122512508' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330898'
                WHERE ordernumber = 'P180402123039590' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262406'
                WHERE ordernumber = 'P180402123351788' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384130'
                WHERE ordernumber = 'P180402123539535' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239169'
                WHERE ordernumber = 'P200402123816668' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296876'
                WHERE ordernumber = 'P420402123853677' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384131'
                WHERE ordernumber = 'P630402123951972' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384132'
                WHERE ordernumber = 'P630402124145128' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166671'
                WHERE ordernumber = 'P420402124313589' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138293'
                WHERE ordernumber = 'P180402124409301' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282441'
                WHERE ordernumber = 'P200402124632384' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296906'
                WHERE ordernumber = 'P420402125010269' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138293'
                WHERE ordernumber = 'P180402125329515' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379585'
                WHERE ordernumber = 'P420402125431879' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384101'
                WHERE ordernumber = 'P200402125510590' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119732'
                WHERE ordernumber = 'P190402125530713' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231792'
                WHERE ordernumber = 'P180402125653698' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296490'
                WHERE ordernumber = 'P190402125655314' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384133'
                WHERE ordernumber = 'P420402125803233' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342844'
                WHERE ordernumber = 'P420402130442426' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384135'
                WHERE ordernumber = 'P180402131212838' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289833'
                WHERE ordernumber = 'P200402132120545' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384136'
                WHERE ordernumber = 'P180402132532407' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384137'
                WHERE ordernumber = 'P180402132820469' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207945'
                WHERE ordernumber = 'P420402132959332' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384138'
                WHERE ordernumber = 'P180402133105545' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384139'
                WHERE ordernumber = 'P180402133333516' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378637'
                WHERE ordernumber = 'P180402133423115' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384141'
                WHERE ordernumber = 'P180402133639750' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278339'
                WHERE ordernumber = 'P200402133714354' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331068'
                WHERE ordernumber = 'P420402134054448' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '60568'
                WHERE ordernumber = 'P200402134713598' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383315'
                WHERE ordernumber = 'P200402134819546' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102064'
                WHERE ordernumber = 'P200402135156331' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '78136'
                WHERE ordernumber = 'P180402135200224' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384143'
                WHERE ordernumber = 'P180402140038479' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244057'
                WHERE ordernumber = 'P200402140124562' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306297'
                WHERE ordernumber = 'P180402140343953' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269539'
                WHERE ordernumber = 'P200402140859566' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161113'
                WHERE ordernumber = 'P200402141335403' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345721'
                WHERE ordernumber = 'P200402143505303' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348897'
                WHERE ordernumber = 'P180402143703681' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230473'
                WHERE ordernumber = 'P190402143729159' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125858'
                WHERE ordernumber = 'P180402144044200' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P180402144819727' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379529'
                WHERE ordernumber = 'P200402144828775' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277214'
                WHERE ordernumber = 'P190402144914179' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365076'
                WHERE ordernumber = 'P200402145017180' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358828'
                WHERE ordernumber = 'P200402145104441' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384147'
                WHERE ordernumber = 'P420402145600833' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384148'
                WHERE ordernumber = 'P180402145836839' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384149'
                WHERE ordernumber = 'P190402150137379' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280459'
                WHERE ordernumber = 'P200402150253797' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384151'
                WHERE ordernumber = 'P180402150748892' 
            
2024-04-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384152'
                WHERE ordernumber = 'P190402151108441' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334332'
                WHERE ordernumber = 'P420402151120562' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229781'
                WHERE ordernumber = 'P200402151433274' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384154'
                WHERE ordernumber = 'P180402151817450' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384155'
                WHERE ordernumber = 'P180402152002748' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232968'
                WHERE ordernumber = 'P200402152757910' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384156'
                WHERE ordernumber = 'P200402152924816' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162239'
                WHERE ordernumber = 'P200402153035910' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334039'
                WHERE ordernumber = 'P200402153503729' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384157'
                WHERE ordernumber = 'P200402153835400' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384103'
                WHERE ordernumber = 'P180402153838541' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384158'
                WHERE ordernumber = 'P420402153851135' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93985'
                WHERE ordernumber = 'P630402154106658' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371043'
                WHERE ordernumber = 'P630402154245167' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98299'
                WHERE ordernumber = 'P180402154628959' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384160'
                WHERE ordernumber = 'P180402154756713' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180402155826241' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230767'
                WHERE ordernumber = 'P190402155925712' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160927'
                WHERE ordernumber = 'P630402160929950' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384013'
                WHERE ordernumber = 'P180402161130117' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310339'
                WHERE ordernumber = 'P200402161258659' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382335'
                WHERE ordernumber = 'P180402161552147' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382335'
                WHERE ordernumber = 'P180402161644648' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299626'
                WHERE ordernumber = 'P200402161650957' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301547'
                WHERE ordernumber = 'P200402161825990' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287192'
                WHERE ordernumber = 'P200402161955193' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304553'
                WHERE ordernumber = 'P630402162938277' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274925'
                WHERE ordernumber = 'P200402163024293' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384106'
                WHERE ordernumber = 'P180402163025558' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384106'
                WHERE ordernumber = 'P180402163100271' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327300'
                WHERE ordernumber = 'P200402163118738' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384161'
                WHERE ordernumber = 'P180402163648893' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384162'
                WHERE ordernumber = 'P180402164744684' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163291'
                WHERE ordernumber = 'P200402165050171' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378060'
                WHERE ordernumber = 'P200402165230323' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380975'
                WHERE ordernumber = 'P180402165558575' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258844'
                WHERE ordernumber = 'P180402170355812' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348856'
                WHERE ordernumber = 'P630402171538290' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384166'
                WHERE ordernumber = 'P420402171546687' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384167'
                WHERE ordernumber = 'P180402171819561' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108462'
                WHERE ordernumber = 'P180402172355628' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310710'
                WHERE ordernumber = 'P190402172533371' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384168'
                WHERE ordernumber = 'P180402172615795' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285711'
                WHERE ordernumber = 'P180402173416904' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '204611'
                WHERE ordernumber = 'P420402173450524' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320796'
                WHERE ordernumber = 'P180402173508654' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384169'
                WHERE ordernumber = 'P190402173620757' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384170'
                WHERE ordernumber = 'P180402173628149' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384171'
                WHERE ordernumber = 'P180402174057566' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380263'
                WHERE ordernumber = 'P420402174449666' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384173'
                WHERE ordernumber = 'P180402174935976' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384159'
                WHERE ordernumber = 'P630402175358936' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238532'
                WHERE ordernumber = 'P180402175459112' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265972'
                WHERE ordernumber = 'P200402175523594' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247115'
                WHERE ordernumber = 'P180402175615951' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384174'
                WHERE ordernumber = 'P190402175801745' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384175'
                WHERE ordernumber = 'P420402175900515' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271937'
                WHERE ordernumber = 'P190402180023366' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214506'
                WHERE ordernumber = 'P180402180107536' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315127'
                WHERE ordernumber = 'P200402180536671' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334547'
                WHERE ordernumber = 'P420402180654118' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383810'
                WHERE ordernumber = 'P180402180712793' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383810'
                WHERE ordernumber = 'P180402180753799' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337422'
                WHERE ordernumber = 'P180402180955136' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377420'
                WHERE ordernumber = 'P190402181244534' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384178'
                WHERE ordernumber = 'P180402181325826' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384177'
                WHERE ordernumber = 'P590402181428751' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384179'
                WHERE ordernumber = 'P180402181907417' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384181'
                WHERE ordernumber = 'P420402182423422' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384182'
                WHERE ordernumber = 'P180402182434472' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384180'
                WHERE ordernumber = 'P180402182625344' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76999'
                WHERE ordernumber = 'P200402183137590' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384184'
                WHERE ordernumber = 'P630402183316479' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384185'
                WHERE ordernumber = 'P200402183316737' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377192'
                WHERE ordernumber = 'P200402183711933' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384186'
                WHERE ordernumber = 'P190402183812887' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '144711'
                WHERE ordernumber = 'P420402184036682' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356802'
                WHERE ordernumber = 'P200402184103968' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265715'
                WHERE ordernumber = 'P200402184353901' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384187'
                WHERE ordernumber = 'P190402184459973' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384188'
                WHERE ordernumber = 'P200402184505391' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384189'
                WHERE ordernumber = 'P630402184726660' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383225'
                WHERE ordernumber = 'P190402185014836' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384190'
                WHERE ordernumber = 'P420402185103251' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '46166'
                WHERE ordernumber = 'P190402185124421' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211862'
                WHERE ordernumber = 'P190402185714709' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376195'
                WHERE ordernumber = 'P190402185906700' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384192'
                WHERE ordernumber = 'P630402190101186' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384193'
                WHERE ordernumber = 'P190402190251285' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384196'
                WHERE ordernumber = 'P630402190832639' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97587'
                WHERE ordernumber = 'P420402191009366' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282254'
                WHERE ordernumber = 'P200402191304234' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353977'
                WHERE ordernumber = 'P190402191821969' 
            
2024-04-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384198'
                WHERE ordernumber = 'P200402191830843' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384199'
                WHERE ordernumber = 'P420402191941932' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P200402192200334' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219726'
                WHERE ordernumber = 'P190402192300515' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313363'
                WHERE ordernumber = 'P190402193656133' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103229'
                WHERE ordernumber = 'P590402194449844' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278230'
                WHERE ordernumber = 'P200402194529671' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '84688'
                WHERE ordernumber = 'P190402195042464' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283444'
                WHERE ordernumber = 'P190402195433438' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214757'
                WHERE ordernumber = 'P630402195737454' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384200'
                WHERE ordernumber = 'P590402195833644' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101791'
                WHERE ordernumber = 'P200402200039410' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384194'
                WHERE ordernumber = 'P630402201134304' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '290291'
                WHERE ordernumber = 'P630402202643653' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384207'
                WHERE ordernumber = 'P630402205445253' 
            
2024-04-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384210'
                WHERE ordernumber = 'P630402213918477'