2024-11-29 01:00:02 -- 將會員中心id寫入data-lake
2024-11-29 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-11-28%';
        
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '203673'
                WHERE ordernumber = 'P2411280000116' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96065'
                WHERE ordernumber = 'P2411280000266' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '53118'
                WHERE ordernumber = 'P2411280000345' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432136'
                WHERE ordernumber = 'P2411280000448' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308889'
                WHERE ordernumber = 'P2411280000675' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430228'
                WHERE ordernumber = 'P2411280000877' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221764'
                WHERE ordernumber = 'P2411280000992' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111810'
                WHERE ordernumber = 'P2411280001071' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223476'
                WHERE ordernumber = 'P2411280001219' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355659'
                WHERE ordernumber = 'P2411280001542' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432140'
                WHERE ordernumber = 'P2411280001658' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299439'
                WHERE ordernumber = 'P2411280001766' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432139'
                WHERE ordernumber = 'P2411280001846' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432142'
                WHERE ordernumber = 'P2411280002191' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432143'
                WHERE ordernumber = 'P2411280002247' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346893'
                WHERE ordernumber = 'P2411280002417' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346893'
                WHERE ordernumber = 'P2411280002539' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385092'
                WHERE ordernumber = 'P2411280002653' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125819'
                WHERE ordernumber = 'P2411280002871' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430313'
                WHERE ordernumber = 'P2411280002925' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390247'
                WHERE ordernumber = 'P2411280003139' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432148'
                WHERE ordernumber = 'P2411280003210' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432149'
                WHERE ordernumber = 'P2411280003433' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432150'
                WHERE ordernumber = 'P2411280003562' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432152'
                WHERE ordernumber = 'P2411280003630' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258488'
                WHERE ordernumber = 'P2411280003714' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421740'
                WHERE ordernumber = 'P2411280003832' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432153'
                WHERE ordernumber = 'P2411280003991' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331314'
                WHERE ordernumber = 'P2411280004164' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432154'
                WHERE ordernumber = 'P2411280004224' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '189982'
                WHERE ordernumber = 'P2411280004324' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430317'
                WHERE ordernumber = 'P2411280004432' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285742'
                WHERE ordernumber = 'P2411280004792' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102848'
                WHERE ordernumber = 'P2411280005210' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432155'
                WHERE ordernumber = 'P2411280005695' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '59256'
                WHERE ordernumber = 'P2411280005773' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423342'
                WHERE ordernumber = 'P2411280006232' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426282'
                WHERE ordernumber = 'P2411280006532' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432156'
                WHERE ordernumber = 'P2411280006649' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324080'
                WHERE ordernumber = 'P2411280006790' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428344'
                WHERE ordernumber = 'P2411280006923' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432157'
                WHERE ordernumber = 'P2411280007082' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432157'
                WHERE ordernumber = 'P2411280007136' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385427'
                WHERE ordernumber = 'P2411280007216' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99853'
                WHERE ordernumber = 'P2411280007392' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160964'
                WHERE ordernumber = 'P2411280007441' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305464'
                WHERE ordernumber = 'P2411280007590' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432160'
                WHERE ordernumber = 'P2411280007610' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104419'
                WHERE ordernumber = 'P2411280008033' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111094'
                WHERE ordernumber = 'P2411280008157' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432162'
                WHERE ordernumber = 'P2411280008242' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432161'
                WHERE ordernumber = 'P2411280008389' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135260'
                WHERE ordernumber = 'P2411280008430' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '56139'
                WHERE ordernumber = 'P2411280008556' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P2411280008632' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432163'
                WHERE ordernumber = 'P2411280008925' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100767'
                WHERE ordernumber = 'P2411280009177' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '75232'
                WHERE ordernumber = 'P2411280009558' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163759'
                WHERE ordernumber = 'P2411280009653' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432166'
                WHERE ordernumber = 'P2411280009772' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286412'
                WHERE ordernumber = 'P2411280010264' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431855'
                WHERE ordernumber = 'P2411280010370' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286412'
                WHERE ordernumber = 'P2411280010420' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P2411280010567' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431887'
                WHERE ordernumber = 'P2411280010721' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290320'
                WHERE ordernumber = 'P2411280010825' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432171'
                WHERE ordernumber = 'P2411280010927' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432172'
                WHERE ordernumber = 'P2411280011130' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432173'
                WHERE ordernumber = 'P2411280011211' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432171'
                WHERE ordernumber = 'P2411280011313' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432174'
                WHERE ordernumber = 'P2411280011423' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343932'
                WHERE ordernumber = 'P2411280011536' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432175'
                WHERE ordernumber = 'P2411280011810' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432177'
                WHERE ordernumber = 'P2411280011983' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432178'
                WHERE ordernumber = 'P2411280012054' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432179'
                WHERE ordernumber = 'P2411280012367' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432180'
                WHERE ordernumber = 'P2411280012497' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353653'
                WHERE ordernumber = 'P2411280013116' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432181'
                WHERE ordernumber = 'P2411280013291' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127878'
                WHERE ordernumber = 'P2411280013337' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432183'
                WHERE ordernumber = 'P2411280013454' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432182'
                WHERE ordernumber = 'P2411280013533' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432184'
                WHERE ordernumber = 'P2411280013612' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428754'
                WHERE ordernumber = 'P2411280013792' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432186'
                WHERE ordernumber = 'P2411280013888' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387919'
                WHERE ordernumber = 'P2411280013999' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432187'
                WHERE ordernumber = 'P2411280014089' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369358'
                WHERE ordernumber = 'P2411280014256' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368618'
                WHERE ordernumber = 'P2411280014328' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111624'
                WHERE ordernumber = 'P2411280014428' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432192'
                WHERE ordernumber = 'P2411280014586' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234147'
                WHERE ordernumber = 'P2411280014635' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254470'
                WHERE ordernumber = 'P2411280014965' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90879'
                WHERE ordernumber = 'P2411280015173' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432195'
                WHERE ordernumber = 'P2411280015255' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425100'
                WHERE ordernumber = 'P2411280015345' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342543'
                WHERE ordernumber = 'P2411280015423' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '38656'
                WHERE ordernumber = 'P2411280015536' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100928'
                WHERE ordernumber = 'P2411280015611' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337587'
                WHERE ordernumber = 'P2411280015954' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432196'
                WHERE ordernumber = 'P2411280016143' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432197'
                WHERE ordernumber = 'P2411280016288' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432198'
                WHERE ordernumber = 'P2411280016589' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388429'
                WHERE ordernumber = 'P2411280016630' 
            
2024-11-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432200'
                WHERE ordernumber = 'P2411280016771' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245310'
                WHERE ordernumber = 'P2411280016953' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432199'
                WHERE ordernumber = 'P2411280017077' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307717'
                WHERE ordernumber = 'P2411280017378' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94626'
                WHERE ordernumber = 'P2411280017537' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432201'
                WHERE ordernumber = 'P2411280017835' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432203'
                WHERE ordernumber = 'P2411280018243' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406397'
                WHERE ordernumber = 'P2411280018338' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432204'
                WHERE ordernumber = 'P2411280018523' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344300'
                WHERE ordernumber = 'P2411280018631' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432205'
                WHERE ordernumber = 'P2411280018779' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431283'
                WHERE ordernumber = 'P2411280019119' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432208'
                WHERE ordernumber = 'P2411280019420' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432206'
                WHERE ordernumber = 'P2411280019959' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '40258'
                WHERE ordernumber = 'P2411280020016' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163897'
                WHERE ordernumber = 'P2411280020348' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432210'
                WHERE ordernumber = 'P2411280020492' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432211'
                WHERE ordernumber = 'P2411280020558' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432212'
                WHERE ordernumber = 'P2411280020630' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432213'
                WHERE ordernumber = 'P2411280020746' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '429395'
                WHERE ordernumber = 'P2411280020823' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432215'
                WHERE ordernumber = 'P2411280020955' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412123'
                WHERE ordernumber = 'P2411280021158' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '430258'
                WHERE ordernumber = 'P2411280021251' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374241'
                WHERE ordernumber = 'P2411280021391' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285899'
                WHERE ordernumber = 'P2411280021455' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432217'
                WHERE ordernumber = 'P2411280021531' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272211'
                WHERE ordernumber = 'P2411280021620' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426136'
                WHERE ordernumber = 'P2411280021850' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432216'
                WHERE ordernumber = 'P2411280022075' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432216'
                WHERE ordernumber = 'P2411280022141' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251351'
                WHERE ordernumber = 'P2411280022210' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245667'
                WHERE ordernumber = 'P2411280022331' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432220'
                WHERE ordernumber = 'P2411280022531' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378510'
                WHERE ordernumber = 'P2411280022641' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432223'
                WHERE ordernumber = 'P2411280023238' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432224'
                WHERE ordernumber = 'P2411280023396' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432225'
                WHERE ordernumber = 'P2411280023512' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432226'
                WHERE ordernumber = 'P2411280023620' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341702'
                WHERE ordernumber = 'P2411280023778' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341702'
                WHERE ordernumber = 'P2411280023956' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259908'
                WHERE ordernumber = 'P2411280024113' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432227'
                WHERE ordernumber = 'P2411280024233' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432228'
                WHERE ordernumber = 'P2411280024386' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347486'
                WHERE ordernumber = 'P2411280024437' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '62760'
                WHERE ordernumber = 'P2411280024530' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432230'
                WHERE ordernumber = 'P2411280024818' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162673'
                WHERE ordernumber = 'P2411280025010' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432232'
                WHERE ordernumber = 'P2411280025247' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339162'
                WHERE ordernumber = 'P2411280025345' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432233'
                WHERE ordernumber = 'P2411280025517' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432235'
                WHERE ordernumber = 'P2411280025958' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285817'
                WHERE ordernumber = 'P2411280026069' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432236'
                WHERE ordernumber = 'P2411280026286' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432237'
                WHERE ordernumber = 'P2411280026451' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295857'
                WHERE ordernumber = 'P2411280026571' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432238'
                WHERE ordernumber = 'P2411280026693' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312240'
                WHERE ordernumber = 'P2411280026928' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89001'
                WHERE ordernumber = 'P2411280027140' 
            
2024-11-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '432239'
                WHERE ordernumber = 'P2411280027461'