2024-08-13 01:00:02 -- 將會員中心id寫入data-lake
2024-08-13 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-08-12%';
        
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '361342'
                WHERE ordernumber = 'P630812100651316' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307378'
                WHERE ordernumber = 'P420812110624424' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407486'
                WHERE ordernumber = 'P420812110745634' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406292'
                WHERE ordernumber = 'P190812110845768' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '15675'
                WHERE ordernumber = 'P180812112141393' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305084'
                WHERE ordernumber = 'P420812112742368' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407500'
                WHERE ordernumber = 'P180812113110939' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '333902'
                WHERE ordernumber = 'P190812113228781' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206252'
                WHERE ordernumber = 'P190812113311289' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407502'
                WHERE ordernumber = 'P180812113538946' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331413'
                WHERE ordernumber = 'P420812113655991' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360498'
                WHERE ordernumber = 'P200812113900935' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407502'
                WHERE ordernumber = 'P180812114139660' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99639'
                WHERE ordernumber = 'P180812114902454' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407510'
                WHERE ordernumber = 'P420812114947585' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240990'
                WHERE ordernumber = 'P200812115039326' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407512'
                WHERE ordernumber = 'P420812115217708' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407513'
                WHERE ordernumber = 'P200812115429837' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407515'
                WHERE ordernumber = 'P180812115811949' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407516'
                WHERE ordernumber = 'P420812120027385' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372728'
                WHERE ordernumber = 'P420812120049917' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407517'
                WHERE ordernumber = 'P180812120127121' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407518'
                WHERE ordernumber = 'P180812120348841' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407519'
                WHERE ordernumber = 'P180812120510725' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209599'
                WHERE ordernumber = 'P180812120752662' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406005'
                WHERE ordernumber = 'P180812121617230' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378451'
                WHERE ordernumber = 'P180812121953564' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180812122024114' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389788'
                WHERE ordernumber = 'P420812122026324' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407525'
                WHERE ordernumber = 'P190812122114403' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407526'
                WHERE ordernumber = 'P180812122335159' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243328'
                WHERE ordernumber = 'P190812122554596' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112585'
                WHERE ordernumber = 'P200812122713349' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395158'
                WHERE ordernumber = 'P420812123606455' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389934'
                WHERE ordernumber = 'P420812123917140' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255397'
                WHERE ordernumber = 'P200812124512573' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270100'
                WHERE ordernumber = 'P180812125604182' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382970'
                WHERE ordernumber = 'P420812125750192' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '327398'
                WHERE ordernumber = 'P180812125800726' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407536'
                WHERE ordernumber = 'P180812125912710' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407538'
                WHERE ordernumber = 'P420812130315686' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407541'
                WHERE ordernumber = 'P200812130420140' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407539'
                WHERE ordernumber = 'P200812130440672' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407418'
                WHERE ordernumber = 'P420812131022476' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407545'
                WHERE ordernumber = 'P420812131514939' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95916'
                WHERE ordernumber = 'P200812131535202' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95916'
                WHERE ordernumber = 'P200812131610809' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407547'
                WHERE ordernumber = 'P180812131621853' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398832'
                WHERE ordernumber = 'P200812131849162' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407548'
                WHERE ordernumber = 'P420812131915233' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379849'
                WHERE ordernumber = 'P180812132005758' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '322990'
                WHERE ordernumber = 'P180812132154114' 
            
2024-08-13 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407550'
                WHERE ordernumber = 'P200812132417873' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407554'
                WHERE ordernumber = 'P420812133354432' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315543'
                WHERE ordernumber = 'P200812133832351' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404543'
                WHERE ordernumber = 'P420812134432269' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407558'
                WHERE ordernumber = 'P420812135740379' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131449'
                WHERE ordernumber = 'P180812141347832' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99590'
                WHERE ordernumber = 'P200812141523857' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296804'
                WHERE ordernumber = 'P200812143411562' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407570'
                WHERE ordernumber = 'P420812143702813' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405662'
                WHERE ordernumber = 'P180812143855296' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387566'
                WHERE ordernumber = 'P420812144601478' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259875'
                WHERE ordernumber = 'P200812144701337' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407575'
                WHERE ordernumber = 'P200812145049235' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407575'
                WHERE ordernumber = 'P200812145107651' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407576'
                WHERE ordernumber = 'P200812145359333' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407576'
                WHERE ordernumber = 'P200812145508500' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407576'
                WHERE ordernumber = 'P200812145637142' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306488'
                WHERE ordernumber = 'P200812145718705' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407578'
                WHERE ordernumber = 'P200812145906794' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407578'
                WHERE ordernumber = 'P200812150202309' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407580'
                WHERE ordernumber = 'P180812150433132' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314728'
                WHERE ordernumber = 'P420812150505311' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338874'
                WHERE ordernumber = 'P420812151202871' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407587'
                WHERE ordernumber = 'P180812151718113' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112676'
                WHERE ordernumber = 'P190812152045173' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303485'
                WHERE ordernumber = 'P180812152228557' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200812152522615' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391040'
                WHERE ordernumber = 'P180812152547698' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123629'
                WHERE ordernumber = 'P200812154109897' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407595'
                WHERE ordernumber = 'P420812154648363' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407594'
                WHERE ordernumber = 'P200812154726483' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88427'
                WHERE ordernumber = 'P180812154831551' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407591'
                WHERE ordernumber = 'P420812154908531' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407599'
                WHERE ordernumber = 'P180812155503246' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157035'
                WHERE ordernumber = 'P200812155625214' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407603'
                WHERE ordernumber = 'P420812160022346' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157035'
                WHERE ordernumber = 'P200812160408429' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307658'
                WHERE ordernumber = 'P420812161010554' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407613'
                WHERE ordernumber = 'P200812161305209' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407603'
                WHERE ordernumber = 'P420812161312326' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379518'
                WHERE ordernumber = 'P180812161756171' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229628'
                WHERE ordernumber = 'P180812161837616' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307594'
                WHERE ordernumber = 'P180812162155660' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407620'
                WHERE ordernumber = 'P180812162615440' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244296'
                WHERE ordernumber = 'P180812162719284' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407624'
                WHERE ordernumber = 'P180812163550714' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165748'
                WHERE ordernumber = 'P180812163740263' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399880'
                WHERE ordernumber = 'P180812163950797' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342723'
                WHERE ordernumber = 'P420812164542730' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303066'
                WHERE ordernumber = 'P200812164932996' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393246'
                WHERE ordernumber = 'P420812164935152' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245711'
                WHERE ordernumber = 'P200812165026219' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375193'
                WHERE ordernumber = 'P180812165048786' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '33821'
                WHERE ordernumber = 'P630812165143150' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407629'
                WHERE ordernumber = 'P200812165346370' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375193'
                WHERE ordernumber = 'P180812165357580' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407630'
                WHERE ordernumber = 'P200812165619957' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397351'
                WHERE ordernumber = 'P420812165933834' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110061'
                WHERE ordernumber = 'P200812170107461' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407637'
                WHERE ordernumber = 'P420812171217556' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401701'
                WHERE ordernumber = 'P420812172025258' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403589'
                WHERE ordernumber = 'P420812173102490' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285615'
                WHERE ordernumber = 'P180812173256182' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407651'
                WHERE ordernumber = 'P180812173426275' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169376'
                WHERE ordernumber = 'P190812173446846' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395320'
                WHERE ordernumber = 'P630812173509171' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407656'
                WHERE ordernumber = 'P420812174432713' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330344'
                WHERE ordernumber = 'P200812174903972' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400984'
                WHERE ordernumber = 'P630812175308591' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273597'
                WHERE ordernumber = 'P200812175311910' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105183'
                WHERE ordernumber = 'P200812175816214' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388142'
                WHERE ordernumber = 'P420812180429627' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334547'
                WHERE ordernumber = 'P420812180651532' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102858'
                WHERE ordernumber = 'P200812180753267' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330367'
                WHERE ordernumber = 'P180812181001296' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407665'
                WHERE ordernumber = 'P180812181519673' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211211'
                WHERE ordernumber = 'P200812181633141' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304980'
                WHERE ordernumber = 'P420812181719512' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407669'
                WHERE ordernumber = 'P200812182134160' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405218'
                WHERE ordernumber = 'P180812182308304' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143999'
                WHERE ordernumber = 'P200812182432396' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407670'
                WHERE ordernumber = 'P180812182601427' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '150183'
                WHERE ordernumber = 'P180812182753722' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407672'
                WHERE ordernumber = 'P420812182816919' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387799'
                WHERE ordernumber = 'P420812185351598' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406840'
                WHERE ordernumber = 'P200812185504921' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406509'
                WHERE ordernumber = 'P200812185954479' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407677'
                WHERE ordernumber = 'P420812190121552' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407678'
                WHERE ordernumber = 'P190812190239937' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404252'
                WHERE ordernumber = 'P200812190429305' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407679'
                WHERE ordernumber = 'P190812190447505' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116943'
                WHERE ordernumber = 'P200812190533432' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407680'
                WHERE ordernumber = 'P200812190631357' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269946'
                WHERE ordernumber = 'P200812190715968' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351776'
                WHERE ordernumber = 'P200812190918504' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365708'
                WHERE ordernumber = 'P200812191242192' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138578'
                WHERE ordernumber = 'P190812191913811' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103513'
                WHERE ordernumber = 'P190812192128244' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407681'
                WHERE ordernumber = 'P190812192445995' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282815'
                WHERE ordernumber = 'P190812192947631' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313849'
                WHERE ordernumber = 'P630812193308218' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140770'
                WHERE ordernumber = 'P630812193537981' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407469'
                WHERE ordernumber = 'P190812193957586' 
            
2024-08-13 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407469'
                WHERE ordernumber = 'P190812194043186' 
            
2024-08-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407686'
                WHERE ordernumber = 'P200812194827738' 
            
2024-08-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403893'
                WHERE ordernumber = 'P200812195135636' 
            
2024-08-13 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128881'
                WHERE ordernumber = 'P630812202100684'