2024-03-06 01:00:02 -- 將會員中心id寫入data-lake
2024-03-06 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-03-05%';
        
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302675'
                WHERE ordernumber = 'P200305110113768' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P200305110222271' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380152'
                WHERE ordernumber = 'P180305110347931' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380153'
                WHERE ordernumber = 'P180305110504627' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380154'
                WHERE ordernumber = 'P420305110543811' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100760'
                WHERE ordernumber = 'P190305110551480' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379761'
                WHERE ordernumber = 'P590305110700647' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420305110715831' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273047'
                WHERE ordernumber = 'P180305110918927' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380150'
                WHERE ordernumber = 'P590305111002678' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167176'
                WHERE ordernumber = 'P200305111328930' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296804'
                WHERE ordernumber = 'P200305111612383' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378495'
                WHERE ordernumber = 'P190305111838285' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380156'
                WHERE ordernumber = 'P180305112044275' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '125033'
                WHERE ordernumber = 'P180305112159175' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380158'
                WHERE ordernumber = 'P180305112519755' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380155'
                WHERE ordernumber = 'P190305112520127' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129053'
                WHERE ordernumber = 'P180305112751892' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380159'
                WHERE ordernumber = 'P180305113040141' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380161'
                WHERE ordernumber = 'P420305113455233' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180305114010570' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380162'
                WHERE ordernumber = 'P180305114245846' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380163'
                WHERE ordernumber = 'P180305114449920' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380164'
                WHERE ordernumber = 'P180305114746209' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380165'
                WHERE ordernumber = 'P420305115039501' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '173547'
                WHERE ordernumber = 'P180305115422716' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276449'
                WHERE ordernumber = 'P200305115658246' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380166'
                WHERE ordernumber = 'P180305115843571' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '68547'
                WHERE ordernumber = 'P180305120117386' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '75628'
                WHERE ordernumber = 'P420305120857531' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380168'
                WHERE ordernumber = 'P200305120927738' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217348'
                WHERE ordernumber = 'P200305121813311' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380167'
                WHERE ordernumber = 'P590305122158815' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348733'
                WHERE ordernumber = 'P180305122344112' 
            
2024-03-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266766'
                WHERE ordernumber = 'P200305122956521' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380173'
                WHERE ordernumber = 'P420305123103527' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314528'
                WHERE ordernumber = 'P180305123317244' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380174'
                WHERE ordernumber = 'P200305123334310' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305148'
                WHERE ordernumber = 'P200305123753644' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180305124103455' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380178'
                WHERE ordernumber = 'P420305124123551' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380179'
                WHERE ordernumber = 'P200305124146620' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380180'
                WHERE ordernumber = 'P180305124447674' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380172'
                WHERE ordernumber = 'P590305124523540' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215376'
                WHERE ordernumber = 'P420305124841368' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114047'
                WHERE ordernumber = 'P590305125002494' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169193'
                WHERE ordernumber = 'P180305125054992' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380183'
                WHERE ordernumber = 'P200305125717994' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310480'
                WHERE ordernumber = 'P180305125722937' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377632'
                WHERE ordernumber = 'P420305125933342' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173631'
                WHERE ordernumber = 'P180305130314711' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380185'
                WHERE ordernumber = 'P420305130519118' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380186'
                WHERE ordernumber = 'P420305130616945' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380190'
                WHERE ordernumber = 'P180305132529984' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108296'
                WHERE ordernumber = 'P180305133249331' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380193'
                WHERE ordernumber = 'P420305133727437' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340551'
                WHERE ordernumber = 'P420305133926997' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380194'
                WHERE ordernumber = 'P180305133946547' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254624'
                WHERE ordernumber = 'P180305134234885' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143087'
                WHERE ordernumber = 'P200305134356817' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380196'
                WHERE ordernumber = 'P200305134513626' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244017'
                WHERE ordernumber = 'P180305135127196' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380197'
                WHERE ordernumber = 'P180305135422114' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92404'
                WHERE ordernumber = 'P180305135827797' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380199'
                WHERE ordernumber = 'P420305135948998' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229232'
                WHERE ordernumber = 'P180305140009544' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380201'
                WHERE ordernumber = 'P200305140313686' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180305140413226' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380176'
                WHERE ordernumber = 'P180305140621783' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380176'
                WHERE ordernumber = 'P180305140706778' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343684'
                WHERE ordernumber = 'P200305140753373' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380176'
                WHERE ordernumber = 'P180305140757409' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380203'
                WHERE ordernumber = 'P200305141312925' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343537'
                WHERE ordernumber = 'P180305141505212' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380151'
                WHERE ordernumber = 'P420305141939412' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274966'
                WHERE ordernumber = 'P180305141941762' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304086'
                WHERE ordernumber = 'P180305142109178' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380205'
                WHERE ordernumber = 'P190305142631637' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380206'
                WHERE ordernumber = 'P420305142924494' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180305143315919' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342097'
                WHERE ordernumber = 'P190305143439698' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P180305144754732' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342097'
                WHERE ordernumber = 'P190305144843801' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268829'
                WHERE ordernumber = 'P190305145108203' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380209'
                WHERE ordernumber = 'P180305145411484' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380211'
                WHERE ordernumber = 'P190305145535607' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380212'
                WHERE ordernumber = 'P180305145558361' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380213'
                WHERE ordernumber = 'P180305145807621' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380215'
                WHERE ordernumber = 'P200305150243882' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380214'
                WHERE ordernumber = 'P180305150254202' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366074'
                WHERE ordernumber = 'P420305151107301' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180305151827926' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160130'
                WHERE ordernumber = 'P180305151919774' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200305152121565' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380220'
                WHERE ordernumber = 'P200305152216329' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380217'
                WHERE ordernumber = 'P590305152257302' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113281'
                WHERE ordernumber = 'P200305152413405' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377415'
                WHERE ordernumber = 'P180305152643664' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377415'
                WHERE ordernumber = 'P180305153230219' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P190305153456161' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377415'
                WHERE ordernumber = 'P180305153545718' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380223'
                WHERE ordernumber = 'P200305153720904' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142030'
                WHERE ordernumber = 'P200305154020755' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380224'
                WHERE ordernumber = 'P200305154756785' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267353'
                WHERE ordernumber = 'P190305154910846' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377184'
                WHERE ordernumber = 'P180305155410276' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380167'
                WHERE ordernumber = 'P420305155707118' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '51812'
                WHERE ordernumber = 'P200305155708515' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299561'
                WHERE ordernumber = 'P200305160011541' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380169'
                WHERE ordernumber = 'P420305160011346' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380226'
                WHERE ordernumber = 'P180305160159158' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380227'
                WHERE ordernumber = 'P420305160358352' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350014'
                WHERE ordernumber = 'P200305160803599' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171742'
                WHERE ordernumber = 'P590305160909528' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380229'
                WHERE ordernumber = 'P180305161127838' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94655'
                WHERE ordernumber = 'P200305161551327' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94655'
                WHERE ordernumber = 'P200305161712384' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359887'
                WHERE ordernumber = 'P180305162021153' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380230'
                WHERE ordernumber = 'P420305162051948' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247927'
                WHERE ordernumber = 'P180305162517313' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283224'
                WHERE ordernumber = 'P200305162538361' 
            
2024-03-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380232'
                WHERE ordernumber = 'P420305163414785' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380231'
                WHERE ordernumber = 'P420305163539472' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160114'
                WHERE ordernumber = 'P180305163734920' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380233'
                WHERE ordernumber = 'P200305164109632' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380234'
                WHERE ordernumber = 'P200305164344388' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380236'
                WHERE ordernumber = 'P420305164727195' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380239'
                WHERE ordernumber = 'P200305165004659' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365988'
                WHERE ordernumber = 'P420305165128547' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380240'
                WHERE ordernumber = 'P180305165252400' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '134240'
                WHERE ordernumber = 'P180305170012853' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380241'
                WHERE ordernumber = 'P420305170054473' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288967'
                WHERE ordernumber = 'P180305170127571' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358697'
                WHERE ordernumber = 'P200305170954349' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380242'
                WHERE ordernumber = 'P200305171055233' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380243'
                WHERE ordernumber = 'P420305171309595' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339752'
                WHERE ordernumber = 'P420305171352628' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380244'
                WHERE ordernumber = 'P200305171536171' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380245'
                WHERE ordernumber = 'P420305172836570' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237657'
                WHERE ordernumber = 'P190305173212648' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '77463'
                WHERE ordernumber = 'P420305173414184' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298942'
                WHERE ordernumber = 'P190305173455883' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380247'
                WHERE ordernumber = 'P420305174143991' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '144644'
                WHERE ordernumber = 'P190305174253639' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169653'
                WHERE ordernumber = 'P200305174302816' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259028'
                WHERE ordernumber = 'P200305174349180' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380248'
                WHERE ordernumber = 'P420305175020449' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380251'
                WHERE ordernumber = 'P200305175811259' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320796'
                WHERE ordernumber = 'P180305175932267' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380252'
                WHERE ordernumber = 'P200305175943206' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310783'
                WHERE ordernumber = 'P190305180147428' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304060'
                WHERE ordernumber = 'P190305180332776' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212750'
                WHERE ordernumber = 'P200305181231652' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380253'
                WHERE ordernumber = 'P190305181603925' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380254'
                WHERE ordernumber = 'P190305181758586' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268934'
                WHERE ordernumber = 'P420305182000780' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218988'
                WHERE ordernumber = 'P200305182117796' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380256'
                WHERE ordernumber = 'P420305183524955' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309439'
                WHERE ordernumber = 'P190305184040403' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380256'
                WHERE ordernumber = 'P420305184114638' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380258'
                WHERE ordernumber = 'P190305184541282' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226246'
                WHERE ordernumber = 'P190305185818489' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380262'
                WHERE ordernumber = 'P190305185940743' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380263'
                WHERE ordernumber = 'P420305190306784' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380264'
                WHERE ordernumber = 'P200305190909841' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380095'
                WHERE ordernumber = 'P420305191202715' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346212'
                WHERE ordernumber = 'P190305191519183' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380266'
                WHERE ordernumber = 'P200305191745717' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380265'
                WHERE ordernumber = 'P200305191823931' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380268'
                WHERE ordernumber = 'P200305191906617' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380267'
                WHERE ordernumber = 'P590305192253872' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379361'
                WHERE ordernumber = 'P190305192605759' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379361'
                WHERE ordernumber = 'P190305193131168' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351596'
                WHERE ordernumber = 'P200305193232203' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294187'
                WHERE ordernumber = 'P420305194138711' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380270'
                WHERE ordernumber = 'P420305194330676' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327536'
                WHERE ordernumber = 'P200305194335730' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380272'
                WHERE ordernumber = 'P190305194546524' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380273'
                WHERE ordernumber = 'P190305194759355' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154784'
                WHERE ordernumber = 'P190305195138427' 
            
2024-03-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380278'
                WHERE ordernumber = 'P590305203222651'