2024-03-31 01:00:02 -- 將會員中心id寫入data-lake
2024-03-31 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-03-30%';
        
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383714'
                WHERE ordernumber = 'P420330104933222' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249648'
                WHERE ordernumber = 'P200330110106891' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246883'
                WHERE ordernumber = 'P200330110424362' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383717'
                WHERE ordernumber = 'P190330110733440' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383718'
                WHERE ordernumber = 'P200330110802522' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '88065'
                WHERE ordernumber = 'P180330110926763' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383557'
                WHERE ordernumber = 'P190330111140130' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334578'
                WHERE ordernumber = 'P200330112051169' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383719'
                WHERE ordernumber = 'P180330112109908' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280487'
                WHERE ordernumber = 'P180330112228280' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96017'
                WHERE ordernumber = 'P180330112634695' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356610'
                WHERE ordernumber = 'P180330112807574' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345808'
                WHERE ordernumber = 'P190330113132126' 
            
2024-03-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383721'
                WHERE ordernumber = 'P180330113334538' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379193'
                WHERE ordernumber = 'P180330113932439' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246065'
                WHERE ordernumber = 'P420330114016571' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284194'
                WHERE ordernumber = 'P190330114228614' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383720'
                WHERE ordernumber = 'P180330114653636' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383722'
                WHERE ordernumber = 'P180330115219444' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383723'
                WHERE ordernumber = 'P420330115418669' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303554'
                WHERE ordernumber = 'P180330115520513' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284700'
                WHERE ordernumber = 'P180330115544228' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383724'
                WHERE ordernumber = 'P420330115636654' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99632'
                WHERE ordernumber = 'P180330115730711' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365107'
                WHERE ordernumber = 'P200330115856432' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P200330120039254' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162735'
                WHERE ordernumber = 'P180330120148636' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105063'
                WHERE ordernumber = 'P180330120343777' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96035'
                WHERE ordernumber = 'P190330120424128' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307723'
                WHERE ordernumber = 'P200330120659786' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P190330121030359' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359878'
                WHERE ordernumber = 'P200330121444403' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379856'
                WHERE ordernumber = 'P420330121559474' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278858'
                WHERE ordernumber = 'P200330122555975' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124349'
                WHERE ordernumber = 'P190330122815439' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383729'
                WHERE ordernumber = 'P180330123453580' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383731'
                WHERE ordernumber = 'P180330123719821' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366606'
                WHERE ordernumber = 'P180330123900653' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378563'
                WHERE ordernumber = 'P420330124135376' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383732'
                WHERE ordernumber = 'P420330124537942' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98376'
                WHERE ordernumber = 'P180330130757985' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107647'
                WHERE ordernumber = 'P420330133335292' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383737'
                WHERE ordernumber = 'P190330133449628' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383738'
                WHERE ordernumber = 'P190330133721804' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379469'
                WHERE ordernumber = 'P200330133725960' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383739'
                WHERE ordernumber = 'P420330134059745' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275143'
                WHERE ordernumber = 'P190330134207629' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383743'
                WHERE ordernumber = 'P190330140127686' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P190330140206597' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302680'
                WHERE ordernumber = 'P190330140421593' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383213'
                WHERE ordernumber = 'P180330140515400' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303328'
                WHERE ordernumber = 'P180330140936726' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383744'
                WHERE ordernumber = 'P190330140945330' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229749'
                WHERE ordernumber = 'P180330141103567' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379732'
                WHERE ordernumber = 'P420330141236736' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383745'
                WHERE ordernumber = 'P180330141524599' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383746'
                WHERE ordernumber = 'P180330141939406' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P420330142026341' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338916'
                WHERE ordernumber = 'P200330142310164' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276747'
                WHERE ordernumber = 'P200330142753474' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383748'
                WHERE ordernumber = 'P180330143151985' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P190330143259903' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378646'
                WHERE ordernumber = 'P420330143318815' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383749'
                WHERE ordernumber = 'P200330143337889' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128983'
                WHERE ordernumber = 'P420330143425151' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213853'
                WHERE ordernumber = 'P190330143719645' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383751'
                WHERE ordernumber = 'P420330144354501' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383752'
                WHERE ordernumber = 'P190330144529550' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348951'
                WHERE ordernumber = 'P200330144544419' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321320'
                WHERE ordernumber = 'P200330144810876' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383753'
                WHERE ordernumber = 'P420330144923876' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279465'
                WHERE ordernumber = 'P180330145701598' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '34523'
                WHERE ordernumber = 'P420330145740137' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383754'
                WHERE ordernumber = 'P180330145823821' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355441'
                WHERE ordernumber = 'P200330150044722' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240384'
                WHERE ordernumber = 'P200330150334785' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '195649'
                WHERE ordernumber = 'P190330150339807' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383755'
                WHERE ordernumber = 'P420330150559849' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382363'
                WHERE ordernumber = 'P420330151316929' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '194324'
                WHERE ordernumber = 'P190330151621957' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383757'
                WHERE ordernumber = 'P190330152120841' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299531'
                WHERE ordernumber = 'P420330152610359' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101056'
                WHERE ordernumber = 'P180330152835867' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383759'
                WHERE ordernumber = 'P420330152937229' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383761'
                WHERE ordernumber = 'P420330153553872' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '120522'
                WHERE ordernumber = 'P420330154111872' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135563'
                WHERE ordernumber = 'P200330154154231' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383762'
                WHERE ordernumber = 'P420330154307543' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309032'
                WHERE ordernumber = 'P180330154721387' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383764'
                WHERE ordernumber = 'P420330154909869' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380394'
                WHERE ordernumber = 'P420330154945441' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358443'
                WHERE ordernumber = 'P200330155205630' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252711'
                WHERE ordernumber = 'P180330155343748' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383765'
                WHERE ordernumber = 'P420330155503418' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383766'
                WHERE ordernumber = 'P180330155538648' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346893'
                WHERE ordernumber = 'P420330155849541' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228977'
                WHERE ordernumber = 'P180330160548512' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383769'
                WHERE ordernumber = 'P420330160701616' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141046'
                WHERE ordernumber = 'P420330161218296' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383771'
                WHERE ordernumber = 'P180330162539115' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P190330162718819' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383772'
                WHERE ordernumber = 'P180330162737310' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157902'
                WHERE ordernumber = 'P200330163109210' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383774'
                WHERE ordernumber = 'P180330163152935' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180330163236511' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377701'
                WHERE ordernumber = 'P180330163346438' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383775'
                WHERE ordernumber = 'P180330163612974' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '84659'
                WHERE ordernumber = 'P180330164340997' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290821'
                WHERE ordernumber = 'P180330165418363' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383776'
                WHERE ordernumber = 'P190330165433775' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383777'
                WHERE ordernumber = 'P180330165617727' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275304'
                WHERE ordernumber = 'P200330165631184' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210031'
                WHERE ordernumber = 'P590330165900318' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383778'
                WHERE ordernumber = 'P200330170146490' 
            
2024-03-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344731'
                WHERE ordernumber = 'P420330170332762' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383780'
                WHERE ordernumber = 'P180330170545724' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306059'
                WHERE ordernumber = 'P200330170654665' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383781'
                WHERE ordernumber = 'P200330170835862' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383773'
                WHERE ordernumber = 'P190330171313898' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383781'
                WHERE ordernumber = 'P200330171355280' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383782'
                WHERE ordernumber = 'P180330171558435' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383783'
                WHERE ordernumber = 'P420330171940935' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352626'
                WHERE ordernumber = 'P180330172204875' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '91230'
                WHERE ordernumber = 'P190330172239485' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217471'
                WHERE ordernumber = 'P180330172626380' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383784'
                WHERE ordernumber = 'P420330172938692' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124325'
                WHERE ordernumber = 'P180330173219978' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383785'
                WHERE ordernumber = 'P590330173421830' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154826'
                WHERE ordernumber = 'P200330174040938' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342524'
                WHERE ordernumber = 'P180330174118605' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95975'
                WHERE ordernumber = 'P180330174306496' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383786'
                WHERE ordernumber = 'P200330174639873' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280871'
                WHERE ordernumber = 'P200330174811246' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313973'
                WHERE ordernumber = 'P180330174828487' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382330'
                WHERE ordernumber = 'P200330175246397' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244494'
                WHERE ordernumber = 'P200330175637485' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383788'
                WHERE ordernumber = 'P200330180133392' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383789'
                WHERE ordernumber = 'P420330180206618' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233233'
                WHERE ordernumber = 'P200330180302194' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383791'
                WHERE ordernumber = 'P420330180630432' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348229'
                WHERE ordernumber = 'P420330180804554' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383793'
                WHERE ordernumber = 'P420330182554759' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383794'
                WHERE ordernumber = 'P420330182832797' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383795'
                WHERE ordernumber = 'P180330182926542' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380938'
                WHERE ordernumber = 'P420330183454885' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383694'
                WHERE ordernumber = 'P180330183456497' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317367'
                WHERE ordernumber = 'P420330184252575' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383796'
                WHERE ordernumber = 'P420330184626188' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119623'
                WHERE ordernumber = 'P190330184938913' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383797'
                WHERE ordernumber = 'P190330185552884' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383799'
                WHERE ordernumber = 'P420330190114330' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382769'
                WHERE ordernumber = 'P190330190205932' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383800'
                WHERE ordernumber = 'P190330190432306' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347068'
                WHERE ordernumber = 'P420330191111962' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383801'
                WHERE ordernumber = 'P190330191216517' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280076'
                WHERE ordernumber = 'P420330191745292' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383802'
                WHERE ordernumber = 'P420330192114745' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352487'
                WHERE ordernumber = 'P190330192309924' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383430'
                WHERE ordernumber = 'P420330192458240' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383804'
                WHERE ordernumber = 'P420330193530298' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383805'
                WHERE ordernumber = 'P190330193749895' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81759'
                WHERE ordernumber = 'P420330194504710' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383763'
                WHERE ordernumber = 'P420330194800495' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383792'
                WHERE ordernumber = 'P420330195024905' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383806'
                WHERE ordernumber = 'P420330195359443' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383807'
                WHERE ordernumber = 'P420330195534652' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383809'
                WHERE ordernumber = 'P420330195705908' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322219'
                WHERE ordernumber = 'P420330200102851' 
            
2024-03-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247976'
                WHERE ordernumber = 'P590330210438567'