2024-02-29 01:00:01 -- 將會員中心id寫入data-lake
2024-02-29 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-02-28%';
        
2024-02-29 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '109558'
                WHERE ordernumber = 'P200228110234948' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379247'
                WHERE ordernumber = 'P180228110613227' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379247'
                WHERE ordernumber = 'P180228110645113' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377629'
                WHERE ordernumber = 'P200228110914257' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379248'
                WHERE ordernumber = 'P190228110926452' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347464'
                WHERE ordernumber = 'P190228111105700' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '226459'
                WHERE ordernumber = 'P180228111310844' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379250'
                WHERE ordernumber = 'P180228111505688' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379251'
                WHERE ordernumber = 'P420228111526456' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212330'
                WHERE ordernumber = 'P200228111742619' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '179256'
                WHERE ordernumber = 'P190228112112788' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272568'
                WHERE ordernumber = 'P420228112212831' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379253'
                WHERE ordernumber = 'P200228112259286' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332962'
                WHERE ordernumber = 'P200228112347822' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379255'
                WHERE ordernumber = 'P190228112437779' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379255'
                WHERE ordernumber = 'P190228112521943' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379256'
                WHERE ordernumber = 'P180228112633455' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379257'
                WHERE ordernumber = 'P180228113351919' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372758'
                WHERE ordernumber = 'P200228113516138' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268741'
                WHERE ordernumber = 'P190228113525425' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341266'
                WHERE ordernumber = 'P190228114249167' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242050'
                WHERE ordernumber = 'P420228114428551' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379258'
                WHERE ordernumber = 'P190228114520289' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379259'
                WHERE ordernumber = 'P180228114545976' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '333477'
                WHERE ordernumber = 'P180228115223312' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252424'
                WHERE ordernumber = 'P180228115341721' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '63058'
                WHERE ordernumber = 'P200228115918638' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367079'
                WHERE ordernumber = 'P180228120147361' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367079'
                WHERE ordernumber = 'P180228120249641' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379261'
                WHERE ordernumber = 'P180228120533624' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376813'
                WHERE ordernumber = 'P200228120604281' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379262'
                WHERE ordernumber = 'P180228120708157' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379263'
                WHERE ordernumber = 'P420228120755791' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379264'
                WHERE ordernumber = 'P200228120858597' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239340'
                WHERE ordernumber = 'P200228121040960' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379265'
                WHERE ordernumber = 'P180228121130637' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305350'
                WHERE ordernumber = 'P200228121612758' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379266'
                WHERE ordernumber = 'P420228121644653' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299628'
                WHERE ordernumber = 'P190228121813617' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379267'
                WHERE ordernumber = 'P180228121830604' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252497'
                WHERE ordernumber = 'P190228122040486' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379268'
                WHERE ordernumber = 'P180228122309183' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377552'
                WHERE ordernumber = 'P420228122427820' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379269'
                WHERE ordernumber = 'P190228122454216' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379270'
                WHERE ordernumber = 'P190228122612284' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142915'
                WHERE ordernumber = 'P180228122745863' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354108'
                WHERE ordernumber = 'P180228123208868' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293331'
                WHERE ordernumber = 'P200228123508479' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365805'
                WHERE ordernumber = 'P180228123904686' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167240'
                WHERE ordernumber = 'P180228124045206' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273316'
                WHERE ordernumber = 'P200228125011578' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350556'
                WHERE ordernumber = 'P420228125142887' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379272'
                WHERE ordernumber = 'P180228125428812' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377224'
                WHERE ordernumber = 'P180228125703528' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379274'
                WHERE ordernumber = 'P180228125924762' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288061'
                WHERE ordernumber = 'P180228130010598' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276102'
                WHERE ordernumber = 'P180228130223260' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344637'
                WHERE ordernumber = 'P180228130306134' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379277'
                WHERE ordernumber = 'P180228130450942' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274538'
                WHERE ordernumber = 'P180228130558390' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379278'
                WHERE ordernumber = 'P420228130728604' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379279'
                WHERE ordernumber = 'P180228130746119' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371649'
                WHERE ordernumber = 'P420228130808194' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379280'
                WHERE ordernumber = 'P200228130914802' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274925'
                WHERE ordernumber = 'P200228131133794' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285340'
                WHERE ordernumber = 'P180228131455376' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359914'
                WHERE ordernumber = 'P190228131704349' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379283'
                WHERE ordernumber = 'P200228131738765' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379284'
                WHERE ordernumber = 'P200228132114648' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379285'
                WHERE ordernumber = 'P420228132248755' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99515'
                WHERE ordernumber = 'P200228132842296' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379286'
                WHERE ordernumber = 'P200228133007845' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379287'
                WHERE ordernumber = 'P420228133426895' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379288'
                WHERE ordernumber = 'P420228133653665' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379290'
                WHERE ordernumber = 'P420228134330852' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379291'
                WHERE ordernumber = 'P420228134444875' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276492'
                WHERE ordernumber = 'P200228134537753' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379292'
                WHERE ordernumber = 'P420228134540135' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379293'
                WHERE ordernumber = 'P190228134701321' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379294'
                WHERE ordernumber = 'P190228134807122' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379295'
                WHERE ordernumber = 'P420228134908358' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379296'
                WHERE ordernumber = 'P190228135124617' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379299'
                WHERE ordernumber = 'P200228140251899' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379300'
                WHERE ordernumber = 'P420228140336518' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '267520'
                WHERE ordernumber = 'P200228140623330' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379302'
                WHERE ordernumber = 'P200228140738114' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '150598'
                WHERE ordernumber = 'P420228140906741' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379303'
                WHERE ordernumber = 'P190228140918539' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364149'
                WHERE ordernumber = 'P200228141025403' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '155614'
                WHERE ordernumber = 'P420228141031956' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '321338'
                WHERE ordernumber = 'P420228141139208' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379304'
                WHERE ordernumber = 'P190228141147444' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238560'
                WHERE ordernumber = 'P200228141447622' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379305'
                WHERE ordernumber = 'P180228141556296' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379030'
                WHERE ordernumber = 'P190228142439234' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379306'
                WHERE ordernumber = 'P200228142608712' 
            
2024-02-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379305'
                WHERE ordernumber = 'P180228142629964' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264742'
                WHERE ordernumber = 'P180228143155696' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376510'
                WHERE ordernumber = 'P420228143309925' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169193'
                WHERE ordernumber = 'P180228143358468' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379307'
                WHERE ordernumber = 'P180228143707208' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379310'
                WHERE ordernumber = 'P420228144018300' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379240'
                WHERE ordernumber = 'P420228144145675' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281459'
                WHERE ordernumber = 'P190228144306694' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379311'
                WHERE ordernumber = 'P180228144355330' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379313'
                WHERE ordernumber = 'P200228144538559' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379131'
                WHERE ordernumber = 'P180228144600869' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379312'
                WHERE ordernumber = 'P190228144641314' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311238'
                WHERE ordernumber = 'P190228144753603' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272885'
                WHERE ordernumber = 'P200228145146112' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379314'
                WHERE ordernumber = 'P190228145315858' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '175105'
                WHERE ordernumber = 'P200228145606637' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234151'
                WHERE ordernumber = 'P200228145632744' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379316'
                WHERE ordernumber = 'P190228145705371' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303396'
                WHERE ordernumber = 'P200228145929379' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122246'
                WHERE ordernumber = 'P200228150024333' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379317'
                WHERE ordernumber = 'P180228150039850' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106167'
                WHERE ordernumber = 'P180228150124557' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379318'
                WHERE ordernumber = 'P200228150720533' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379320'
                WHERE ordernumber = 'P180228151003174' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379321'
                WHERE ordernumber = 'P180228151110262' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P190228151220816' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379322'
                WHERE ordernumber = 'P420228151252394' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379323'
                WHERE ordernumber = 'P180228151304579' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379324'
                WHERE ordernumber = 'P190228151503529' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350013'
                WHERE ordernumber = 'P420228151926415' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350013'
                WHERE ordernumber = 'P420228152021603' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379325'
                WHERE ordernumber = 'P180228152041848' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '44432'
                WHERE ordernumber = 'P420228152201624' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379326'
                WHERE ordernumber = 'P420228152551241' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '68024'
                WHERE ordernumber = 'P180228152723507' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277180'
                WHERE ordernumber = 'P420228152739325' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369358'
                WHERE ordernumber = 'P420228153013699' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379327'
                WHERE ordernumber = 'P180228153244856' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160202'
                WHERE ordernumber = 'P180228153428408' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379329'
                WHERE ordernumber = 'P180228153636240' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379331'
                WHERE ordernumber = 'P180228154204307' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162857'
                WHERE ordernumber = 'P200228154254489' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379330'
                WHERE ordernumber = 'P420228154300263' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379332'
                WHERE ordernumber = 'P180228154324560' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379333'
                WHERE ordernumber = 'P200228154412438' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379334'
                WHERE ordernumber = 'P180228154425402' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162857'
                WHERE ordernumber = 'P200228154709641' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355823'
                WHERE ordernumber = 'P180228154909633' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379335'
                WHERE ordernumber = 'P420228155017199' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378759'
                WHERE ordernumber = 'P200228155017891' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90195'
                WHERE ordernumber = 'P420228155206319' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277020'
                WHERE ordernumber = 'P420228155325814' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141896'
                WHERE ordernumber = 'P180228155326227' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P180228155631427' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379336'
                WHERE ordernumber = 'P420228155640397' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379337'
                WHERE ordernumber = 'P420228155818535' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379338'
                WHERE ordernumber = 'P420228160022150' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379339'
                WHERE ordernumber = 'P180228160027240' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379340'
                WHERE ordernumber = 'P420228160204403' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379341'
                WHERE ordernumber = 'P180228160229724' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379342'
                WHERE ordernumber = 'P420228160349894' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379343'
                WHERE ordernumber = 'P200228160357626' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379344'
                WHERE ordernumber = 'P200228160523734' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378942'
                WHERE ordernumber = 'P180228161417619' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379347'
                WHERE ordernumber = 'P180228161636747' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379348'
                WHERE ordernumber = 'P420228161834117' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259972'
                WHERE ordernumber = 'P420228161926331' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379349'
                WHERE ordernumber = 'P180228161931449' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379350'
                WHERE ordernumber = 'P420228162215947' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379351'
                WHERE ordernumber = 'P180228162442688' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217757'
                WHERE ordernumber = 'P180228162543627' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379354'
                WHERE ordernumber = 'P180228162715868' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379352'
                WHERE ordernumber = 'P200228162807263' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341909'
                WHERE ordernumber = 'P180228163022543' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379355'
                WHERE ordernumber = 'P200228163029291' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307508'
                WHERE ordernumber = 'P200228163052941' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379356'
                WHERE ordernumber = 'P180228163122716' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379357'
                WHERE ordernumber = 'P420228163143801' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283871'
                WHERE ordernumber = 'P180228163248975' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379360'
                WHERE ordernumber = 'P180228163535844' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379359'
                WHERE ordernumber = 'P420228163538933' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379361'
                WHERE ordernumber = 'P190228163542685' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379361'
                WHERE ordernumber = 'P190228163650566' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P420228163652808' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379362'
                WHERE ordernumber = 'P180228163834285' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379363'
                WHERE ordernumber = 'P420228163956145' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378934'
                WHERE ordernumber = 'P180228164003122' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378934'
                WHERE ordernumber = 'P180228164007232' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159046'
                WHERE ordernumber = 'P180228164145157' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100328'
                WHERE ordernumber = 'P180228164414923' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379364'
                WHERE ordernumber = 'P420228164506834' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379365'
                WHERE ordernumber = 'P180228164935140' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379367'
                WHERE ordernumber = 'P420228165010229' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379368'
                WHERE ordernumber = 'P190228165209352' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379366'
                WHERE ordernumber = 'P180228165252696' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379366'
                WHERE ordernumber = 'P180228165308229' 
            
2024-02-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379369'
                WHERE ordernumber = 'P420228165328371' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379370'
                WHERE ordernumber = 'P190228165407345' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379371'
                WHERE ordernumber = 'P180228165722529' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379372'
                WHERE ordernumber = 'P420228170059331' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379373'
                WHERE ordernumber = 'P180228170537128' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379374'
                WHERE ordernumber = 'P180228170721895' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245742'
                WHERE ordernumber = 'P420228171100566' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233858'
                WHERE ordernumber = 'P200228171528760' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377629'
                WHERE ordernumber = 'P200228171934414' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324294'
                WHERE ordernumber = 'P180228172001140' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379376'
                WHERE ordernumber = 'P200228172059239' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379377'
                WHERE ordernumber = 'P200228172309350' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379378'
                WHERE ordernumber = 'P180228172340547' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357562'
                WHERE ordernumber = 'P180228172744163' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379383'
                WHERE ordernumber = 'P180228173613489' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379384'
                WHERE ordernumber = 'P200228173750181' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379386'
                WHERE ordernumber = 'P200228174343645' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379382'
                WHERE ordernumber = 'P200228174832173' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379388'
                WHERE ordernumber = 'P420228174931669' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379382'
                WHERE ordernumber = 'P200228175006878' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379389'
                WHERE ordernumber = 'P420228175025373' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379390'
                WHERE ordernumber = 'P200228175102185' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210174'
                WHERE ordernumber = 'P180228175150196' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274179'
                WHERE ordernumber = 'P180228175430659' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379391'
                WHERE ordernumber = 'P180228175557604' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379392'
                WHERE ordernumber = 'P180228175655328' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379393'
                WHERE ordernumber = 'P180228175759674' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379395'
                WHERE ordernumber = 'P180228175903604' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379396'
                WHERE ordernumber = 'P180228180843188' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340830'
                WHERE ordernumber = 'P180228181037434' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271197'
                WHERE ordernumber = 'P180228181152945' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280432'
                WHERE ordernumber = 'P420228181545427' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117308'
                WHERE ordernumber = 'P180228182048231' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81992'
                WHERE ordernumber = 'P180228182241627' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379397'
                WHERE ordernumber = 'P200228182318273' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379398'
                WHERE ordernumber = 'P180228182355940' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358543'
                WHERE ordernumber = 'P200228182508636' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352853'
                WHERE ordernumber = 'P200228182802718' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327303'
                WHERE ordernumber = 'P180228182843391' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379400'
                WHERE ordernumber = 'P200228183346408' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379401'
                WHERE ordernumber = 'P180228184206603' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379403'
                WHERE ordernumber = 'P180228184752850' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379404'
                WHERE ordernumber = 'P180228184859544' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379405'
                WHERE ordernumber = 'P180228185008479' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379406'
                WHERE ordernumber = 'P180228185140405' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256467'
                WHERE ordernumber = 'P190228190008432' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379409'
                WHERE ordernumber = 'P190228191105597' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379192'
                WHERE ordernumber = 'P190228191315190' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272293'
                WHERE ordernumber = 'P200228191645861' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353938'
                WHERE ordernumber = 'P420228192347219' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373792'
                WHERE ordernumber = 'P190228193109118' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379410'
                WHERE ordernumber = 'P190228193723248' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74302'
                WHERE ordernumber = 'P200228194637875' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373923'
                WHERE ordernumber = 'P420228194811292' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379412'
                WHERE ordernumber = 'P190228195247764' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379414'
                WHERE ordernumber = 'P200228195429567' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379415'
                WHERE ordernumber = 'P200228195707159' 
            
2024-02-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239801'
                WHERE ordernumber = 'P200228195912862'