2024-04-06 01:00:03 -- 將會員中心id寫入data-lake
2024-04-06 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-04-05%';
        
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228920'
                WHERE ordernumber = 'P420405102842666' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366123'
                WHERE ordernumber = 'P420405104536456' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384412'
                WHERE ordernumber = 'P420405105506179' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384413'
                WHERE ordernumber = 'P630405110230552' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384414'
                WHERE ordernumber = 'P180405110437460' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '52659'
                WHERE ordernumber = 'P420405110508236' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384415'
                WHERE ordernumber = 'P180405110817223' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384416'
                WHERE ordernumber = 'P420405110916316' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384417'
                WHERE ordernumber = 'P180405111020552' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384418'
                WHERE ordernumber = 'P180405111221916' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384419'
                WHERE ordernumber = 'P180405111332255' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340218'
                WHERE ordernumber = 'P180405111652147' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206892'
                WHERE ordernumber = 'P180405111851151' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356999'
                WHERE ordernumber = 'P420405112700487' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284634'
                WHERE ordernumber = 'P200405112724774' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118623'
                WHERE ordernumber = 'P630405113041130' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132641'
                WHERE ordernumber = 'P190405113053155' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384422'
                WHERE ordernumber = 'P200405113155686' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368246'
                WHERE ordernumber = 'P180405113206598' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384424'
                WHERE ordernumber = 'P180405113607437' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384426'
                WHERE ordernumber = 'P200405113922619' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384428'
                WHERE ordernumber = 'P200405114119703' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384429'
                WHERE ordernumber = 'P180405114217615' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384428'
                WHERE ordernumber = 'P200405114344923' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164924'
                WHERE ordernumber = 'P200405114515972' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278116'
                WHERE ordernumber = 'P200405114608440' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351044'
                WHERE ordernumber = 'P200405114816158' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304095'
                WHERE ordernumber = 'P180405115316377' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384430'
                WHERE ordernumber = 'P190405115337545' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384431'
                WHERE ordernumber = 'P180405115423147' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169365'
                WHERE ordernumber = 'P180405120042297' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162735'
                WHERE ordernumber = 'P190405120351313' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384432'
                WHERE ordernumber = 'P180405120641271' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384434'
                WHERE ordernumber = 'P180405120837337' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117531'
                WHERE ordernumber = 'P180405121412574' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323717'
                WHERE ordernumber = 'P180405121509302' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111293'
                WHERE ordernumber = 'P180405121727471' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287589'
                WHERE ordernumber = 'P180405121944837' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384437'
                WHERE ordernumber = 'P180405123044284' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384438'
                WHERE ordernumber = 'P200405123153906' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345817'
                WHERE ordernumber = 'P630405123456753' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322'
                WHERE ordernumber = 'P180405123904831' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384440'
                WHERE ordernumber = 'P420405124040932' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384445'
                WHERE ordernumber = 'P180405125222618' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384446'
                WHERE ordernumber = 'P200405125453746' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384441'
                WHERE ordernumber = 'P590405125639581' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113490'
                WHERE ordernumber = 'P200405125757778' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95002'
                WHERE ordernumber = 'P180405130555464' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384447'
                WHERE ordernumber = 'P590405130754950' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384449'
                WHERE ordernumber = 'P190405130813247' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384450'
                WHERE ordernumber = 'P180405130901216' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384448'
                WHERE ordernumber = 'P590405130943173' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384451'
                WHERE ordernumber = 'P180405131153411' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384452'
                WHERE ordernumber = 'P180405131506784' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384453'
                WHERE ordernumber = 'P180405131611840' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337289'
                WHERE ordernumber = 'P180405131832126' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160365'
                WHERE ordernumber = 'P200405132728815' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251367'
                WHERE ordernumber = 'P420405133807551' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275812'
                WHERE ordernumber = 'P180405134225683' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384454'
                WHERE ordernumber = 'P630405134313281' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379915'
                WHERE ordernumber = 'P180405134353506' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384455'
                WHERE ordernumber = 'P180405134751492' 
            
2024-04-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384456'
                WHERE ordernumber = 'P180405135105944' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246109'
                WHERE ordernumber = 'P180405135211936' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112837'
                WHERE ordernumber = 'P180405135437173' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384457'
                WHERE ordernumber = 'P190405135818218' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384407'
                WHERE ordernumber = 'P180405135846777' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314818'
                WHERE ordernumber = 'P180405140001257' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384459'
                WHERE ordernumber = 'P190405140118746' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132149'
                WHERE ordernumber = 'P180405140142398' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382343'
                WHERE ordernumber = 'P200405140424454' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384460'
                WHERE ordernumber = 'P180405140903751' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230845'
                WHERE ordernumber = 'P180405141147765' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383157'
                WHERE ordernumber = 'P590405141259702' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383157'
                WHERE ordernumber = 'P590405141425226' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384462'
                WHERE ordernumber = 'P180405141629906' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384464'
                WHERE ordernumber = 'P420405141856221' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384466'
                WHERE ordernumber = 'P180405142035724' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305788'
                WHERE ordernumber = 'P190405142114553' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315321'
                WHERE ordernumber = 'P420405142254113' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255145'
                WHERE ordernumber = 'P180405142403187' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384467'
                WHERE ordernumber = 'P420405142412556' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383970'
                WHERE ordernumber = 'P190405142414419' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383970'
                WHERE ordernumber = 'P190405142450820' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222035'
                WHERE ordernumber = 'P180405142520381' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339882'
                WHERE ordernumber = 'P200405142602582' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384468'
                WHERE ordernumber = 'P420405142631654' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318038'
                WHERE ordernumber = 'P420405142701522' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293046'
                WHERE ordernumber = 'P180405142750751' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383681'
                WHERE ordernumber = 'P190405143202129' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384470'
                WHERE ordernumber = 'P190405143328635' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384471'
                WHERE ordernumber = 'P200405143412340' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384469'
                WHERE ordernumber = 'P590405143844722' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384473'
                WHERE ordernumber = 'P180405145205893' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228942'
                WHERE ordernumber = 'P180405145355779' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384474'
                WHERE ordernumber = 'P420405145807421' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '190272'
                WHERE ordernumber = 'P180405145830666' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298834'
                WHERE ordernumber = 'P180405150237819' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384475'
                WHERE ordernumber = 'P190405150405205' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384476'
                WHERE ordernumber = 'P180405150447581' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381834'
                WHERE ordernumber = 'P180405150708728' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384477'
                WHERE ordernumber = 'P180405151222298' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288047'
                WHERE ordernumber = 'P180405151527876' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248874'
                WHERE ordernumber = 'P180405151617131' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288047'
                WHERE ordernumber = 'P180405151729192' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314251'
                WHERE ordernumber = 'P200405151826701' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384478'
                WHERE ordernumber = 'P190405151829516' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P180405151850599' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314251'
                WHERE ordernumber = 'P200405151914850' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340497'
                WHERE ordernumber = 'P180405152122659' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384465'
                WHERE ordernumber = 'P180405152202963' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384479'
                WHERE ordernumber = 'P200405152333633' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384480'
                WHERE ordernumber = 'P180405152350367' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379682'
                WHERE ordernumber = 'P630405152448244' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384481'
                WHERE ordernumber = 'P200405152449745' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384482'
                WHERE ordernumber = 'P180405152549603' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384483'
                WHERE ordernumber = 'P630405153207762' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384484'
                WHERE ordernumber = 'P630405153421597' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384485'
                WHERE ordernumber = 'P180405153611432' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384486'
                WHERE ordernumber = 'P180405153930145' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267352'
                WHERE ordernumber = 'P180405154034367' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384488'
                WHERE ordernumber = 'P630405154638608' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384487'
                WHERE ordernumber = 'P180405154704277' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384489'
                WHERE ordernumber = 'P420405154757768' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384490'
                WHERE ordernumber = 'P180405154927930' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384491'
                WHERE ordernumber = 'P630405155057566' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285742'
                WHERE ordernumber = 'P180405155333756' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384492'
                WHERE ordernumber = 'P420405155550781' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384493'
                WHERE ordernumber = 'P180405155937497' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384495'
                WHERE ordernumber = 'P180405160039556' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384494'
                WHERE ordernumber = 'P630405160049416' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74302'
                WHERE ordernumber = 'P200405160127280' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320317'
                WHERE ordernumber = 'P200405160220511' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280280'
                WHERE ordernumber = 'P630405160610562' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384496'
                WHERE ordernumber = 'P420405160627255' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353079'
                WHERE ordernumber = 'P180405160705128' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276896'
                WHERE ordernumber = 'P420405160835189' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113035'
                WHERE ordernumber = 'P180405160920172' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384497'
                WHERE ordernumber = 'P200405161004681' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346559'
                WHERE ordernumber = 'P190405161434437' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384498'
                WHERE ordernumber = 'P180405161505798' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365102'
                WHERE ordernumber = 'P200405162149542' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384499'
                WHERE ordernumber = 'P420405162312120' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384500'
                WHERE ordernumber = 'P180405162405803' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384501'
                WHERE ordernumber = 'P420405162517154' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137641'
                WHERE ordernumber = 'P180405163207925' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154494'
                WHERE ordernumber = 'P420405163249848' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383164'
                WHERE ordernumber = 'P200405163321149' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384463'
                WHERE ordernumber = 'P420405163347619' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384503'
                WHERE ordernumber = 'P180405163405526' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384168'
                WHERE ordernumber = 'P180405163607124' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384504'
                WHERE ordernumber = 'P630405163718337' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384505'
                WHERE ordernumber = 'P180405163912951' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384507'
                WHERE ordernumber = 'P190405164026295' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288281'
                WHERE ordernumber = 'P200405164052931' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384508'
                WHERE ordernumber = 'P190405164204631' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384509'
                WHERE ordernumber = 'P180405164211671' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384510'
                WHERE ordernumber = 'P180405164420941' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100393'
                WHERE ordernumber = 'P180405164446957' 
            
2024-04-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384506'
                WHERE ordernumber = 'P200405164511382' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384510'
                WHERE ordernumber = 'P180405164533183' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384506'
                WHERE ordernumber = 'P200405164552964' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384511'
                WHERE ordernumber = 'P420405164625688' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384512'
                WHERE ordernumber = 'P180405164757549' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384513'
                WHERE ordernumber = 'P200405164917664' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '373709'
                WHERE ordernumber = 'P420405165127854' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '38369'
                WHERE ordernumber = 'P200405165201786' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384514'
                WHERE ordernumber = 'P180405165422573' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103860'
                WHERE ordernumber = 'P180405165623897' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '330853'
                WHERE ordernumber = 'P420405165635683' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '280922'
                WHERE ordernumber = 'P190405165758554' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383445'
                WHERE ordernumber = 'P420405165940295' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169917'
                WHERE ordernumber = 'P630405170044609' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384516'
                WHERE ordernumber = 'P190405170053405' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384517'
                WHERE ordernumber = 'P590405170206180' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371905'
                WHERE ordernumber = 'P200405170207457' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '74509'
                WHERE ordernumber = 'P190405170225301' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383784'
                WHERE ordernumber = 'P420405170533423' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '74509'
                WHERE ordernumber = 'P190405170615894' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '248609'
                WHERE ordernumber = 'P200405170829400' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384519'
                WHERE ordernumber = 'P190405171042503' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384520'
                WHERE ordernumber = 'P180405171255776' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384521'
                WHERE ordernumber = 'P420405171824958' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384522'
                WHERE ordernumber = 'P200405172222589' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384522'
                WHERE ordernumber = 'P200405172334111' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384523'
                WHERE ordernumber = 'P420405172405752' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302958'
                WHERE ordernumber = 'P200405172438901' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180405172530333' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384524'
                WHERE ordernumber = 'P180405173222506' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '136524'
                WHERE ordernumber = 'P190405173542214' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310894'
                WHERE ordernumber = 'P180405173649382' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '82116'
                WHERE ordernumber = 'P180405173837668' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384525'
                WHERE ordernumber = 'P180405174504986' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384527'
                WHERE ordernumber = 'P420405174726846' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384526'
                WHERE ordernumber = 'P200405174730295' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384528'
                WHERE ordernumber = 'P420405174842262' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212202'
                WHERE ordernumber = 'P180405175151314' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384529'
                WHERE ordernumber = 'P180405175657355' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384530'
                WHERE ordernumber = 'P180405175758968' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366269'
                WHERE ordernumber = 'P180405180017367' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384531'
                WHERE ordernumber = 'P190405180039659' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384532'
                WHERE ordernumber = 'P200405180332337' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384533'
                WHERE ordernumber = 'P630405180653343' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276013'
                WHERE ordernumber = 'P180405180718824' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384534'
                WHERE ordernumber = 'P420405180911547' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384535'
                WHERE ordernumber = 'P180405181004941' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284935'
                WHERE ordernumber = 'P180405181413162' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384536'
                WHERE ordernumber = 'P420405181603704' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '164605'
                WHERE ordernumber = 'P180405181630522' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384538'
                WHERE ordernumber = 'P630405182215295' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384537'
                WHERE ordernumber = 'P180405182306483' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384540'
                WHERE ordernumber = 'P420405182705195' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384541'
                WHERE ordernumber = 'P630405182837910' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384539'
                WHERE ordernumber = 'P590405183214950' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384542'
                WHERE ordernumber = 'P180405183541642' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384543'
                WHERE ordernumber = 'P190405183627762' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384544'
                WHERE ordernumber = 'P420405183934828' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384545'
                WHERE ordernumber = 'P200405184032203' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '141799'
                WHERE ordernumber = 'P200405185250936' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317718'
                WHERE ordernumber = 'P420405185611434' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384547'
                WHERE ordernumber = 'P190405190001800' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381128'
                WHERE ordernumber = 'P190405190518836' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '316630'
                WHERE ordernumber = 'P630405191137777' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384550'
                WHERE ordernumber = 'P420405191501239' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249126'
                WHERE ordernumber = 'P190405191546531' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384549'
                WHERE ordernumber = 'P630405191613919' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '367952'
                WHERE ordernumber = 'P190405191859368' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337886'
                WHERE ordernumber = 'P200405192324277' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '361422'
                WHERE ordernumber = 'P200405192730191' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384552'
                WHERE ordernumber = 'P190405193651872' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358829'
                WHERE ordernumber = 'P420405193814380' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384554'
                WHERE ordernumber = 'P630405194420770' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313541'
                WHERE ordernumber = 'P190405194854994' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384559'
                WHERE ordernumber = 'P630405204009600' 
            
2024-04-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384561'
                WHERE ordernumber = 'P630405210601377'