2024-07-31 01:00:03 -- 將會員中心id寫入data-lake
2024-07-31 01:00:03 -- 
            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-07-30%';
        
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98527'
                WHERE ordernumber = 'P200730110232779' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403989'
                WHERE ordernumber = 'P200730110517677' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403921'
                WHERE ordernumber = 'P180730110522670' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394309'
                WHERE ordernumber = 'P420730110529398' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342970'
                WHERE ordernumber = 'P200730110750741' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230299'
                WHERE ordernumber = 'P190730110758680' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351122'
                WHERE ordernumber = 'P200730110924817' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278615'
                WHERE ordernumber = 'P190730111324628' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160441'
                WHERE ordernumber = 'P200730112007180' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357914'
                WHERE ordernumber = 'P200730112059966' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348859'
                WHERE ordernumber = 'P180730112516387' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403996'
                WHERE ordernumber = 'P180730112631967' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403997'
                WHERE ordernumber = 'P420730112659374' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '61970'
                WHERE ordernumber = 'P190730113057150' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247930'
                WHERE ordernumber = 'P180730113238167' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262644'
                WHERE ordernumber = 'P420730113254928' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305755'
                WHERE ordernumber = 'P190730113703361' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160264'
                WHERE ordernumber = 'P180730113809619' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284514'
                WHERE ordernumber = 'P200730114056518' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404000'
                WHERE ordernumber = 'P420730114350549' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404001'
                WHERE ordernumber = 'P180730114656675' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244080'
                WHERE ordernumber = 'P180730114909991' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393527'
                WHERE ordernumber = 'P180730115103896' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281601'
                WHERE ordernumber = 'P190730115153210' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116608'
                WHERE ordernumber = 'P190730120203545' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404004'
                WHERE ordernumber = 'P190730120413220' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404003'
                WHERE ordernumber = 'P200730120900188' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404007'
                WHERE ordernumber = 'P180730121642710' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389797'
                WHERE ordernumber = 'P420730121931703' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403941'
                WHERE ordernumber = 'P200730122146336' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '23542'
                WHERE ordernumber = 'P200730122742775' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338423'
                WHERE ordernumber = 'P180730122838196' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98337'
                WHERE ordernumber = 'P200730122941257' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389187'
                WHERE ordernumber = 'P190730123210194' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399651'
                WHERE ordernumber = 'P180730123349199' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404012'
                WHERE ordernumber = 'P180730123902749' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404013'
                WHERE ordernumber = 'P180730124104809' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340280'
                WHERE ordernumber = 'P420730124620992' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402156'
                WHERE ordernumber = 'P200730124706561' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317880'
                WHERE ordernumber = 'P420730124738323' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379412'
                WHERE ordernumber = 'P180730124810827' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127964'
                WHERE ordernumber = 'P200730124830169' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404015'
                WHERE ordernumber = 'P200730125235248' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404017'
                WHERE ordernumber = 'P200730125841482' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100292'
                WHERE ordernumber = 'P180730130033732' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404018'
                WHERE ordernumber = 'P200730130033948' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330603'
                WHERE ordernumber = 'P180730130153880' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404023'
                WHERE ordernumber = 'P420730130832645' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404024'
                WHERE ordernumber = 'P200730131000806' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355569'
                WHERE ordernumber = 'P180730131108383' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404021'
                WHERE ordernumber = 'P420730131143694' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404025'
                WHERE ordernumber = 'P420730131248552' 
            
2024-07-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404026'
                WHERE ordernumber = 'P420730131409813' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404028'
                WHERE ordernumber = 'P180730131608950' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395813'
                WHERE ordernumber = 'P420730131644183' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404029'
                WHERE ordernumber = 'P180730132010387' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379045'
                WHERE ordernumber = 'P420730132224676' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404030'
                WHERE ordernumber = 'P180730132354227' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404031'
                WHERE ordernumber = 'P190730132413649' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404032'
                WHERE ordernumber = 'P180730132505495' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404016'
                WHERE ordernumber = 'P200730132522976' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400529'
                WHERE ordernumber = 'P180730132930652' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96436'
                WHERE ordernumber = 'P190730133418387' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96436'
                WHERE ordernumber = 'P190730133437605' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404035'
                WHERE ordernumber = 'P420730133632331' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395791'
                WHERE ordernumber = 'P420730134015265' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404037'
                WHERE ordernumber = 'P420730134221755' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404037'
                WHERE ordernumber = 'P420730134221755' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404040'
                WHERE ordernumber = 'P190730134638560' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252199'
                WHERE ordernumber = 'P200730135407763' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403157'
                WHERE ordernumber = 'P180730135813842' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276711'
                WHERE ordernumber = 'P190730140119387' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404046'
                WHERE ordernumber = 'P420730140259267' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404045'
                WHERE ordernumber = 'P180730140333810' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276711'
                WHERE ordernumber = 'P190730140346598' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402050'
                WHERE ordernumber = 'P420730141019734' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404047'
                WHERE ordernumber = 'P180730141125886' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102566'
                WHERE ordernumber = 'P180730141227257' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404048'
                WHERE ordernumber = 'P180730141515912' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404051'
                WHERE ordernumber = 'P180730141652963' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404053'
                WHERE ordernumber = 'P190730141947311' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404055'
                WHERE ordernumber = 'P420730142700817' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404057'
                WHERE ordernumber = 'P180730142816989' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234855'
                WHERE ordernumber = 'P200730142833297' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380321'
                WHERE ordernumber = 'P200730143804198' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280355'
                WHERE ordernumber = 'P190730143851773' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373247'
                WHERE ordernumber = 'P200730143930158' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404059'
                WHERE ordernumber = 'P190730144202593' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270938'
                WHERE ordernumber = 'P200730144234517' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404061'
                WHERE ordernumber = 'P200730144847483' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404052'
                WHERE ordernumber = 'P200730144924683' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303949'
                WHERE ordernumber = 'P190730145006502' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400510'
                WHERE ordernumber = 'P180730145043238' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271644'
                WHERE ordernumber = 'P190730145104597' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404064'
                WHERE ordernumber = 'P190730145232131' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94496'
                WHERE ordernumber = 'P180730145448865' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404065'
                WHERE ordernumber = 'P190730145633439' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404066'
                WHERE ordernumber = 'P190730145756451' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284262'
                WHERE ordernumber = 'P180730145829835' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273360'
                WHERE ordernumber = 'P200730150613330' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224705'
                WHERE ordernumber = 'P200730150740428' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404068'
                WHERE ordernumber = 'P190730150833710' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389962'
                WHERE ordernumber = 'P420730150835396' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402169'
                WHERE ordernumber = 'P420730151149443' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404059'
                WHERE ordernumber = 'P190730151410510' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318024'
                WHERE ordernumber = 'P200730151617640' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404069'
                WHERE ordernumber = 'P420730151931475' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404070'
                WHERE ordernumber = 'P180730152258744' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340788'
                WHERE ordernumber = 'P200730152300651' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360387'
                WHERE ordernumber = 'P200730152409410' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404071'
                WHERE ordernumber = 'P180730152748729' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386314'
                WHERE ordernumber = 'P200730152954717' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307431'
                WHERE ordernumber = 'P180730153137750' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404073'
                WHERE ordernumber = 'P200730153211239' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404074'
                WHERE ordernumber = 'P420730153315844' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404075'
                WHERE ordernumber = 'P420730153433276' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384245'
                WHERE ordernumber = 'P200730153531638' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404077'
                WHERE ordernumber = 'P420730153543791' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403832'
                WHERE ordernumber = 'P420730154213113' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380535'
                WHERE ordernumber = 'P420730154306265' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220763'
                WHERE ordernumber = 'P180730154318935' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369275'
                WHERE ordernumber = 'P420730154448206' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404081'
                WHERE ordernumber = 'P420730154743399' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369275'
                WHERE ordernumber = 'P420730154857349' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404082'
                WHERE ordernumber = 'P190730155105464' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404084'
                WHERE ordernumber = 'P420730155653717' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404084'
                WHERE ordernumber = 'P420730155838326' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392160'
                WHERE ordernumber = 'P190730160031281' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404086'
                WHERE ordernumber = 'P180730160046822' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404089'
                WHERE ordernumber = 'P180730160243222' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '192344'
                WHERE ordernumber = 'P190730160250828' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387267'
                WHERE ordernumber = 'P420730160400151' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350656'
                WHERE ordernumber = 'P200730160437657' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393765'
                WHERE ordernumber = 'P420730160900814' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88988'
                WHERE ordernumber = 'P420730161042239' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404095'
                WHERE ordernumber = 'P420730161433546' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404096'
                WHERE ordernumber = 'P180730161547407' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404098'
                WHERE ordernumber = 'P200730161751251' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404099'
                WHERE ordernumber = 'P180730161926771' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404100'
                WHERE ordernumber = 'P180730162057545' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103181'
                WHERE ordernumber = 'P200730162146958' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404101'
                WHERE ordernumber = 'P180730162350436' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404102'
                WHERE ordernumber = 'P180730162536311' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404103'
                WHERE ordernumber = 'P180730162944160' 
            
2024-07-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206261'
                WHERE ordernumber = 'P180730163439478' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404105'
                WHERE ordernumber = 'P180730163652744' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404111'
                WHERE ordernumber = 'P200730164120374' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402479'
                WHERE ordernumber = 'P420730164535391' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404112'
                WHERE ordernumber = 'P190730164821551' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404114'
                WHERE ordernumber = 'P200730165203841' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404116'
                WHERE ordernumber = 'P420730165610229' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404117'
                WHERE ordernumber = 'P190730165707486' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '136582'
                WHERE ordernumber = 'P190730165812924' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137782'
                WHERE ordernumber = 'P190730165858991' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404119'
                WHERE ordernumber = 'P200730165959250' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217043'
                WHERE ordernumber = 'P200730170211601' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404122'
                WHERE ordernumber = 'P200730170637644' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '356628'
                WHERE ordernumber = 'P180730171111863' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404125'
                WHERE ordernumber = 'P200730171116123' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404126'
                WHERE ordernumber = 'P190730171150396' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404127'
                WHERE ordernumber = 'P180730171439485' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '143679'
                WHERE ordernumber = 'P420730171504447' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105583'
                WHERE ordernumber = 'P190730171741426' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404120'
                WHERE ordernumber = 'P190730171827548' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404129'
                WHERE ordernumber = 'P420730172007990' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299129'
                WHERE ordernumber = 'P200730172134629' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404131'
                WHERE ordernumber = 'P420730172604120' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342072'
                WHERE ordernumber = 'P200730172818360' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400543'
                WHERE ordernumber = 'P190730172820799' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391928'
                WHERE ordernumber = 'P180730172913380' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393465'
                WHERE ordernumber = 'P180730173032664' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342097'
                WHERE ordernumber = 'P190730173427479' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '189231'
                WHERE ordernumber = 'P200730173517996' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403928'
                WHERE ordernumber = 'P180730173752716' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242590'
                WHERE ordernumber = 'P200730174019337' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404134'
                WHERE ordernumber = 'P180730174515738' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278468'
                WHERE ordernumber = 'P190730174558828' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '260860'
                WHERE ordernumber = 'P420730174730294' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386122'
                WHERE ordernumber = 'P630730174902742' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248179'
                WHERE ordernumber = 'P180730175101962' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404137'
                WHERE ordernumber = 'P420730175939611' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237226'
                WHERE ordernumber = 'P180730175949718' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368140'
                WHERE ordernumber = 'P200730175952767' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98137'
                WHERE ordernumber = 'P190730180027789' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403141'
                WHERE ordernumber = 'P190730180831235' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403141'
                WHERE ordernumber = 'P190730180939384' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '395863'
                WHERE ordernumber = 'P180730180944500' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '265656'
                WHERE ordernumber = 'P200730180957349' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404138'
                WHERE ordernumber = 'P200730181053151' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404139'
                WHERE ordernumber = 'P180730181400545' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '139001'
                WHERE ordernumber = 'P200730181652230' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '265656'
                WHERE ordernumber = 'P200730181743583' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404140'
                WHERE ordernumber = 'P420730182206504' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404141'
                WHERE ordernumber = 'P420730182308742' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404142'
                WHERE ordernumber = 'P420730182442536' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394233'
                WHERE ordernumber = 'P200730183307797' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '251046'
                WHERE ordernumber = 'P180730183349207' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287840'
                WHERE ordernumber = 'P200730183522468' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283784'
                WHERE ordernumber = 'P200730183646202' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266600'
                WHERE ordernumber = 'P180730183911493' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350286'
                WHERE ordernumber = 'P200730184251148' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397894'
                WHERE ordernumber = 'P420730184307372' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404041'
                WHERE ordernumber = 'P200730184850530' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266145'
                WHERE ordernumber = 'P200730185154830' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404147'
                WHERE ordernumber = 'P420730185236362' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404148'
                WHERE ordernumber = 'P200730190015703' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '62247'
                WHERE ordernumber = 'P190730190401164' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403922'
                WHERE ordernumber = 'P200730190519229' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '262490'
                WHERE ordernumber = 'P200730191019245' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397626'
                WHERE ordernumber = 'P200730191146587' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101615'
                WHERE ordernumber = 'P200730191904749' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404151'
                WHERE ordernumber = 'P200730192016856' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400231'
                WHERE ordernumber = 'P200730192326899' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400231'
                WHERE ordernumber = 'P200730192404297' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390504'
                WHERE ordernumber = 'P200730192654346' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404155'
                WHERE ordernumber = 'P200730193157596' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404157'
                WHERE ordernumber = 'P190730193255680' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400673'
                WHERE ordernumber = 'P200730193721898' 
            
2024-07-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398016'
                WHERE ordernumber = 'P200730194114168'