2024-04-27 01:00:01 -- 將會員中心id寫入data-lake
2024-04-27 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-04-26%';
        
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387069'
                WHERE ordernumber = 'P420426110053777' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385422'
                WHERE ordernumber = 'P200426110152470' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385422'
                WHERE ordernumber = 'P200426110257250' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238986'
                WHERE ordernumber = 'P190426110332153' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387070'
                WHERE ordernumber = 'P200426110425843' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '140411'
                WHERE ordernumber = 'P420426110838725' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387071'
                WHERE ordernumber = 'P190426111125116' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386409'
                WHERE ordernumber = 'P190426111332444' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285014'
                WHERE ordernumber = 'P190426111621998' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387072'
                WHERE ordernumber = 'P180426111735547' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387073'
                WHERE ordernumber = 'P190426112039852' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '361104'
                WHERE ordernumber = 'P200426112047367' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387074'
                WHERE ordernumber = 'P180426112102510' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385081'
                WHERE ordernumber = 'P420426112131542' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213784'
                WHERE ordernumber = 'P200426112426629' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387076'
                WHERE ordernumber = 'P420426112446605' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208658'
                WHERE ordernumber = 'P200426113237883' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387077'
                WHERE ordernumber = 'P180426113243940' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '29673'
                WHERE ordernumber = 'P200426114019601' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231451'
                WHERE ordernumber = 'P180426114629782' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349796'
                WHERE ordernumber = 'P180426114750326' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387080'
                WHERE ordernumber = 'P190426114938968' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209500'
                WHERE ordernumber = 'P180426115542377' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287188'
                WHERE ordernumber = 'P180426115653437' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '157229'
                WHERE ordernumber = 'P200426120001116' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387082'
                WHERE ordernumber = 'P190426120637319' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130649'
                WHERE ordernumber = 'P420426121109263' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255389'
                WHERE ordernumber = 'P180426121323877' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255389'
                WHERE ordernumber = 'P180426121522363' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348545'
                WHERE ordernumber = 'P420426121623223' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387084'
                WHERE ordernumber = 'P420426121840539' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387085'
                WHERE ordernumber = 'P180426122741833' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387086'
                WHERE ordernumber = 'P200426122858650' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383431'
                WHERE ordernumber = 'P200426123119764' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387087'
                WHERE ordernumber = 'P180426123308931' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386983'
                WHERE ordernumber = 'P200426124619214' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345147'
                WHERE ordernumber = 'P180426124745302' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383273'
                WHERE ordernumber = 'P190426125645922' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240859'
                WHERE ordernumber = 'P180426130128155' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104252'
                WHERE ordernumber = 'P420426130835470' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386550'
                WHERE ordernumber = 'P590426131112938' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387091'
                WHERE ordernumber = 'P180426131610495' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387094'
                WHERE ordernumber = 'P190426132145719' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387090'
                WHERE ordernumber = 'P590426132501508' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '53424'
                WHERE ordernumber = 'P180426132837747' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387095'
                WHERE ordernumber = 'P200426133555872' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '327916'
                WHERE ordernumber = 'P180426133720242' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387096'
                WHERE ordernumber = 'P200426133744927' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387097'
                WHERE ordernumber = 'P420426133933142' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387098'
                WHERE ordernumber = 'P630426134209311' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387100'
                WHERE ordernumber = 'P200426135257360' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387102'
                WHERE ordernumber = 'P180426140529587' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334374'
                WHERE ordernumber = 'P180426140725456' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98337'
                WHERE ordernumber = 'P200426140837595' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387104'
                WHERE ordernumber = 'P590426141504728' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218910'
                WHERE ordernumber = 'P200426141736180' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387105'
                WHERE ordernumber = 'P200426142114616' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275274'
                WHERE ordernumber = 'P180426142116492' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387107'
                WHERE ordernumber = 'P200426142237588' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387108'
                WHERE ordernumber = 'P200426142431801' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387109'
                WHERE ordernumber = 'P190426142548184' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372230'
                WHERE ordernumber = 'P180426142615478' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277595'
                WHERE ordernumber = 'P420426142713415' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344767'
                WHERE ordernumber = 'P180426144349790' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329183'
                WHERE ordernumber = 'P200426144451717' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166285'
                WHERE ordernumber = 'P190426144628580' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '66170'
                WHERE ordernumber = 'P180426144647255' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277444'
                WHERE ordernumber = 'P190426144746691' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387111'
                WHERE ordernumber = 'P200426144750909' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309518'
                WHERE ordernumber = 'P200426144848529' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111046'
                WHERE ordernumber = 'P180426145019721' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P200426145528712' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P790426145807620' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P790426150057800' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309039'
                WHERE ordernumber = 'P420426150109660' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387112'
                WHERE ordernumber = 'P180426150134883' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247930'
                WHERE ordernumber = 'P180426150433625' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247930'
                WHERE ordernumber = 'P180426150535351' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '108179'
                WHERE ordernumber = 'P180426150958118' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363806'
                WHERE ordernumber = 'P420426151058948' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387113'
                WHERE ordernumber = 'P200426151327284' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345880'
                WHERE ordernumber = 'P420426152007809' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387114'
                WHERE ordernumber = 'P200426152728610' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223258'
                WHERE ordernumber = 'P180426153038115' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248447'
                WHERE ordernumber = 'P420426153415251' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '37307'
                WHERE ordernumber = 'P630426153745261' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '124098'
                WHERE ordernumber = 'P180426153840191' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351381'
                WHERE ordernumber = 'P200426154025803' 
            
2024-04-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387115'
                WHERE ordernumber = 'P180426154351807' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387116'
                WHERE ordernumber = 'P190426154537202' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382326'
                WHERE ordernumber = 'P180426154814437' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384312'
                WHERE ordernumber = 'P590426154822140' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219508'
                WHERE ordernumber = 'P180426155002401' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219508'
                WHERE ordernumber = 'P180426155134797' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324252'
                WHERE ordernumber = 'P190426155313742' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387118'
                WHERE ordernumber = 'P420426155732446' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P180426155735875' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88468'
                WHERE ordernumber = 'P200426160443316' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387119'
                WHERE ordernumber = 'P630426160542276' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343224'
                WHERE ordernumber = 'P200426161448284' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386143'
                WHERE ordernumber = 'P630426161648143' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387120'
                WHERE ordernumber = 'P420426161933504' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324164'
                WHERE ordernumber = 'P200426162155683' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366373'
                WHERE ordernumber = 'P420426162543436' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '120930'
                WHERE ordernumber = 'P200426162616865' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387123'
                WHERE ordernumber = 'P200426162729911' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387124'
                WHERE ordernumber = 'P180426162740423' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383359'
                WHERE ordernumber = 'P420426163021234' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387126'
                WHERE ordernumber = 'P180426163424128' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387128'
                WHERE ordernumber = 'P180426164235709' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387130'
                WHERE ordernumber = 'P200426164538495' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357166'
                WHERE ordernumber = 'P420426164551751' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387131'
                WHERE ordernumber = 'P180426164913472' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335123'
                WHERE ordernumber = 'P190426164949882' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387133'
                WHERE ordernumber = 'P180426165455801' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387132'
                WHERE ordernumber = 'P200426165515199' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133488'
                WHERE ordernumber = 'P200426170138546' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80966'
                WHERE ordernumber = 'P180426170444199' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384933'
                WHERE ordernumber = 'P420426170507529' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267203'
                WHERE ordernumber = 'P180426170600195' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386801'
                WHERE ordernumber = 'P200426170625708' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113709'
                WHERE ordernumber = 'P200426170759408' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143192'
                WHERE ordernumber = 'P180426171007319' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387135'
                WHERE ordernumber = 'P630426171235845' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254829'
                WHERE ordernumber = 'P180426171447755' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387137'
                WHERE ordernumber = 'P200426171510209' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387138'
                WHERE ordernumber = 'P190426171610681' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214506'
                WHERE ordernumber = 'P180426172016826' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P190426172056558' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385387'
                WHERE ordernumber = 'P420426172231222' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387068'
                WHERE ordernumber = 'P180426172336501' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287807'
                WHERE ordernumber = 'P420426172353319' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387068'
                WHERE ordernumber = 'P180426172421725' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300680'
                WHERE ordernumber = 'P180426172832523' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330382'
                WHERE ordernumber = 'P420426172952392' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378110'
                WHERE ordernumber = 'P180426173025396' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224820'
                WHERE ordernumber = 'P200426173213524' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387140'
                WHERE ordernumber = 'P200426173501356' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116319'
                WHERE ordernumber = 'P180426173625831' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387141'
                WHERE ordernumber = 'P180426174055722' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387142'
                WHERE ordernumber = 'P180426174246909' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387143'
                WHERE ordernumber = 'P420426174506671' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387144'
                WHERE ordernumber = 'P180426174609417' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P200426174613624' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95037'
                WHERE ordernumber = 'P180426174949747' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95037'
                WHERE ordernumber = 'P180426175246747' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263790'
                WHERE ordernumber = 'P200426175415350' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386157'
                WHERE ordernumber = 'P420426175542532' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387147'
                WHERE ordernumber = 'P180426175757615' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387148'
                WHERE ordernumber = 'P180426180117307' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240510'
                WHERE ordernumber = 'P180426180404663' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387149'
                WHERE ordernumber = 'P190426180713389' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237083'
                WHERE ordernumber = 'P200426181017361' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239096'
                WHERE ordernumber = 'P200426181156360' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386892'
                WHERE ordernumber = 'P190426181335873' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379790'
                WHERE ordernumber = 'P180426181727802' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379790'
                WHERE ordernumber = 'P180426181818167' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387150'
                WHERE ordernumber = 'P420426181832778' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387152'
                WHERE ordernumber = 'P180426182151439' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387153'
                WHERE ordernumber = 'P180426182956230' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387154'
                WHERE ordernumber = 'P190426183052935' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387156'
                WHERE ordernumber = 'P180426183111235' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379871'
                WHERE ordernumber = 'P180426183146819' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387155'
                WHERE ordernumber = 'P630426183218277' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233268'
                WHERE ordernumber = 'P630426183227125' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379871'
                WHERE ordernumber = 'P180426183251531' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287048'
                WHERE ordernumber = 'P200426183624460' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321429'
                WHERE ordernumber = 'P420426183742765' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229589'
                WHERE ordernumber = 'P180426183808503' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334506'
                WHERE ordernumber = 'P420426183954498' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355726'
                WHERE ordernumber = 'P180426184159364' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118110'
                WHERE ordernumber = 'P200426184342318' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229641'
                WHERE ordernumber = 'P200426184424570' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138726'
                WHERE ordernumber = 'P200426184718842' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111720'
                WHERE ordernumber = 'P590426185026739' 
            
2024-04-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387157'
                WHERE ordernumber = 'P190426185250305' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387158'
                WHERE ordernumber = 'P190426190814632' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380403'
                WHERE ordernumber = 'P190426190942782' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296917'
                WHERE ordernumber = 'P420426192108593' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350632'
                WHERE ordernumber = 'P200426192126293' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387159'
                WHERE ordernumber = 'P200426193130327' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387159'
                WHERE ordernumber = 'P200426193318398' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378873'
                WHERE ordernumber = 'P200426193421541' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386728'
                WHERE ordernumber = 'P420426193432959' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386728'
                WHERE ordernumber = 'P420426193500840' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387160'
                WHERE ordernumber = 'P190426193521302' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127611'
                WHERE ordernumber = 'P190426194247922' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387161'
                WHERE ordernumber = 'P190426194755893' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384300'
                WHERE ordernumber = 'P630426194931987' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386266'
                WHERE ordernumber = 'P590426195322777' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P190426195507184' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387162'
                WHERE ordernumber = 'P200426195553669' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97739'
                WHERE ordernumber = 'P190426200648802' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99037'
                WHERE ordernumber = 'P190426200729748' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387163'
                WHERE ordernumber = 'P190426200936972' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325206'
                WHERE ordernumber = 'P630426202719338' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387164'
                WHERE ordernumber = 'P630426203426362' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387166'
                WHERE ordernumber = 'P590426204241573' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387168'
                WHERE ordernumber = 'P630426213241795' 
            
2024-04-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382951'
                WHERE ordernumber = 'P630426214308962'